BIEE RPD如何创建月末指标?
0
情景:从一张每天库存表中计算出月末库存指标
疑惑:是否用聚合规则Last_period,如何写表达式?
官文中的使用限制:
Note the following LAST_PERIOD function restrictions:
The LAST_PERIOD function is limited to defining dimension-specific aggregation rules in a repository.
When using the LAST_PERIOD function, you must select the Data is dense field on the Logical Column Aggregation tab in the Administration Tool. If you do not select this field, then the aggregation rule reverts to the LAST function.
You cannot use the LAST_PERIOD function in SQL statements.
The LAST_PERIOD function is only applicable to time dimensions. Use the LAST function for other dimensions.
Do not use the LAST_PERIOD function when defining a dimension dependent measure on more than one time dimension. Instead, use the LASTfunction when defining dimension-specific aggregation rules.
Do not use the LAST_PERIOD function as the first dimension-specific aggregate rule. It might cause queries to bring back large numbers of rows for processing in the Oracle BI Server, causing poor performance.
Note that you cannot nest PERIODROLLING, FIRST, FIRST_PERIOD, LAST, and LAST_PERIOD functions.
练习题:下面那个表达式正确获取了期末指标?
1
2
3
疑惑:是否用聚合规则Last_period,如何写表达式?
官文中的使用限制:
Note the following LAST_PERIOD function restrictions:
The LAST_PERIOD function is limited to defining dimension-specific aggregation rules in a repository.
When using the LAST_PERIOD function, you must select the Data is dense field on the Logical Column Aggregation tab in the Administration Tool. If you do not select this field, then the aggregation rule reverts to the LAST function.
You cannot use the LAST_PERIOD function in SQL statements.
The LAST_PERIOD function is only applicable to time dimensions. Use the LAST function for other dimensions.
Do not use the LAST_PERIOD function when defining a dimension dependent measure on more than one time dimension. Instead, use the LASTfunction when defining dimension-specific aggregation rules.
Do not use the LAST_PERIOD function as the first dimension-specific aggregate rule. It might cause queries to bring back large numbers of rows for processing in the Oracle BI Server, causing poor performance.
Note that you cannot nest PERIODROLLING, FIRST, FIRST_PERIOD, LAST, and LAST_PERIOD functions.
练习题:下面那个表达式正确获取了期末指标?
1
2
3
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
2 个回复
wffger 2017-07-20 回答
赞同来自:
seng - 从事BI、大数据、数据分析工作 2017-07-20 回答
赞同来自: