We have the following scenario I'd like your input on:
- ODS with about 5 key fields and about 20 data fields
- The ODS contains daily level data. The users expect to report on weekly level data as well as daily data.
<u>Option 1</u>: Roll the data to the infocube at the weekly level. Create a jump query to ODS if users want to "drill down' to daily data
<u>Option 2:</u> Roll the same daily data to the infocube at the daily level, containing reference to week. Therefore all queries built on the cube will provide weekly and/or daily data.
1. If we load daily data to the cube, data volume is obviously an issue
2. What kind of performance issues (if any) might we experience with Jump Queries off an ODS?
Thanks for your input.