BIEE如何设置会话变量ENABLE_DIMENSIONALITY=1?
0
BIEE设置会话变量的路径是什么?设置ENABLE_DIMENSIONALITY=1 的作用是什么?
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
2 个回复
wffger 2015-12-07 回答
赞同来自:
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.
黄金阳 - BIEE技术人员 2015-11-23 回答
赞同来自: 梁勇
参考下。
变量基本都是在RPD设置的。