Question:
All,
I am working on a report where I don't want to multiply the data.
The data is stored the following way:
ODS-data:
Order_|_week from_|___week to__|__Active
1000__|_____2_____|_____2_______|____1__
1000__|_____4_____|_____5_______|____1__
The reports desired layout should like the following
Order/Wk |_1_|_2_|_3_|_4_|_5_|_6_|
1000_____|_0_|_1_|_0_|_1_|_1_|_0_|
Does any one have any idea how to get to this result without have multiple entries in the info provider.
Any suggestion are very much appreciated
Raymond
Answer:
I'm afraid you'll need:
- Entries in the cube for each Order/Week (calculating the week according the from/to in the update rules from the ODS), or
- Entries in the cube for each order, and one key figure for each week (calculating the key figures in the update rules), or
- Store it in the cube as it is in the ODS, and then having restricted key figures in the query, selecting a week >= from and <= to. These would need to be fixed columns to a particular week each.
_________________
Leandro,
Tuly Idiots Shadow Supporter