i have to build a cube with the following data:
- a part monthly agregated and
- a part yearly agregated.
how could i do this ?
thanks.
The usual approach is to create two different measure groups in the cube.
The first measure group would have Time granularity defined on the Month attribute, and would contain a partition based on your SQL table with monthly aggregated data.
The second measure group would similarly have granularity on Year (instead of Month), and have a partition based on the other SQL table...
Hope this helps
No comments:
Post a Comment