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
2017-07-20_105650.png

2
2017-07-20_112251.png

3
2017-07-20_112859.png

 
已邀请:
0

wffger 2017-07-20 回答

0

seng - 从事BI、大数据、数据分析工作 2017-07-20 回答

库存数据量如果SKU数多的话一般会比较大,而且是每天一个镜像, 这个性能上估计会有点慢吧 。

要回复问题请先登录注册