I have this scenario:
1. 2 types of data (KeyFigures) : addable and non-addable.
2. report user will select time frame to report on and the report is supposed to retrieve all these keyfigures.
3. From the source, the data is in per-month values.
The report user will need to see the cumulative amount upto the selected period in the report.
4. For those addable entries, I see no problem deriving the to-date figures and storing them in cube.
5. Problem: How could the non-addable entries be processed and stored ? If these cannot be added, how could I get the to-date figure?
Would appreciate if you could give you valuable advice.