Question:
I'm using and ODS which has an aggregation by 0CALDAY and then I'm trying to rollup to the cube by 0CALWEEK.
The ODS is containing a Key Figure where I need to display the last value for the 0CALWEEK. I tried to use KF with last value for 0CALWEEK or MAXIMUM value for 0CALWEEK but it doesn't work.
Does someone know if last value or maximum value aggregation work if the ODS is by day and the cube is by week.
If someone know please let me know how to set up the KF.
Thanks,
Teresa.
Answer:
Me too need the same.
Pls let me know if u find the answer.
Thx...
Answer:
Can you write an example, there could be a better ways to achieve this.
Regards,
_________________
Ali H. Alwan
Atos Origin Middle East
Saudi Arabia
Answer:
I think you can have at query level aggragation on these key figures by 0calmonth and 0calday wise... Im doubt if you use this same on target level, ur data can't be consistent..