After a sub dimension is added as child to a normal P/C Dimension, you can configure select its items, process it and browse the result.
Note 1 - Sub dimensions is based on a P/C dimensions that must have been processed. It inherits meta data from this.
Note 2 - when used in modules for Profitbase InVision and SSAS tabular, P/C dimensions must have the [Also Create As Wide] checked.
Select the [Sub Dimension Definition] tab at top.
If an Item is checked all its children will be disabled. If the Sub tree is used in a Measure Group in a OLAP database, the Dimension tree will only display this Item and its parents, but no children. Children Items will be replaced with the selected Items ID. Items that do not have a selected parent will be put in a new node w/ID ‘**’.
When Sub Trees is used in Data Warehouse Output, the produced output Fact Tables (OLAP Measure Groups) will have the original ItemID’s replaced by the ItemID’s selected in the Sub Dimension Tree or by ‘**’. This acts as an Aggregation or reductions of the Fact / Measure Data.
Right click in the Edit Tree to get:
Click on [Tasks and Data] to open a processing dialog. The dimension will be processed automatically. Observe the result and log. Click the [Process] button o re-process.
After the dimension table is created click [Validate] to check the configuration and result.
After processing the sub dimension, it can be browsed in eigther tree view or table mode.