BIEE如何设置会话变量ENABLE_DIMENSIONALITY=1?

0
BIEE设置会话变量的路径是什么?设置ENABLE_DIMENSIONALITY=1 的作用是什么?
已邀请:
0

wffger 2015-12-07 回答

Set following 2 variable in the prefix box as shown below. Note that setting NO_FORCE_TO_DETAIL_BIN=1 is not required in BI Server version 11.1.1.7 and later releases. 
The flow is as follows: 
(1) Create your Cross Subject Area report in answers. 
(2) Click on Advanced tab. 
(3) Look for “Prefix” section under “Advanced SQL Clauses” 
(4) Copy and paste the following in this box (see screenshot below): SET VARIABLE ENABLE_DIMENSIONALITY=1, NO_FORCE_TO_DETAIL_BIN=1; 
(5) Click “Apply SQL” button 
(6) Click on Results tab. 
(7) Review results and save your report Once variable is set in the prefix box, and you click the “Apply SQL”, this set command is appended to the Logical query.
1

黄金阳 - BIEE技术人员 2015-11-23 回答

BIEE中变量总结大全http://www.flybi.net/blog/yuvv/1950 
参考下。
变量基本都是在RPD设置的。
 

要回复问题请先登录注册