Considering the warnings about unexpected sort order, you can use unique moves
in time-based partitioned cubes by selecting both Unique and Move on the Level
property sheet. Any changes in the model are reflected in the new child cubes.
If you make a change to the model and then build your time-based partitioned
cube group, a warning appears indicating that the model has changed. If you
continue with the build, the new child cube is built reflecting the changes.
Note: Historical information continues to exist in older child cubes; new
information is placed in the new child cubes. It is possible that rollups will not
reflect the expected values because they may be using data from two sources.
Example - Sorting in a Slowly Changing Dimension
The following report shows sales by the sales representative Marthe for 2004 and
2005.
When Marthe moved from Vancouver to Ottawa in 2006, the report displays the
historical data for 2004 and 2005 in Vancouver, and the new data for 2006 in
Ottawa.
130 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General