The ‘normal’ job of an InfoCube is to track any changes between attributes of different dimensions (like a sales transaction) and is covered by the fact table.
But there are also changes between characteristic value and dependent attribute value assignments. For example:
The material ‘BBB’ belongs no longer to material group ‘X’ but to material group ‘Y’.
Usually these changes occur rarely and in theory they are addressed as ‘slowly changing dimensions’. How these changes are handled has a big impact on reporting possibilities and data warehouse management.
Again it is to be stressed that:
Reporting possibilities differ depending on whether you define a dependent attribute as a characteristic, a navigational attribute or a node of an external hierarchy, because the locations offer different time scenarios.
<a href="http://help.sap.com/bp_biv135/documentation/Multi-dimensional_modeling_EN.doc">http://help.sap.com/bp_biv135/documentation/Multi-dimensional_modeling_EN.doc</a>
Follow the aforementioned link to get more insights.
Hope it helps
Chetan
@CP..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.