Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. II - Page 5April 10, 2006 14. Scroll to the bottom of the Dimension attributes list. 15. Click the check box to the immediate left of the bottom Attribute Name, ANSYS045 Aging Bucket Name, to select it. 16. Select ANSYS045_Aging_Bucket_Key in the selector to the immediate right of the ANSYS045 Aging Bucket Name selection, designating this as the Attribute Key Column. 17. Leave the Attribute Name Column at its default of ANSYS045_Aging_Bucket_Name. The Select Dimension Attributes page appears, with our selections, as shown in Illustration 22.
Click for larger image 18. Click Next. 19. Ensure that the default, Regular, is set within the Dimension type selector on the Specify Dimension Type page that appears next, as depicted in Illustration 23.
Click for larger image 20. Click Next. 21. Leaving all settings at default, click Next at the Define Parent-Child Relationship page that appears next, as shown in Illustration 24.
Click for larger image 22. Replace the Name on the Completing the Wizard page, which appears next, with the following: Aged Period The Completing the Wizard page appears, with our modification, as depicted in Illustration 25.
23. Click Finish. The Dimension Wizard completes its work, and then dismisses itself. We arrive at the Dimension Structure tab for the new Aged Period dimension, within the Dimension Designer, as shown in Illustration 26.
24. Right-click the new ANSYS045 Aging Bucket Name attribute, appearing just under Aged Period in the Attributes pane. 25. Select Rename from the context menu that appears, as depicted in Illustration 27.
26. Replace the existing name with the following: Aged Period The new name appears in the attribute caption box as shown in Illustration 28.
27. Right-click the Dim Time attribute, appearing just under the newly renamed Aged Period attribute in the Attributes pane. 28. Select Rename, as before. 29. Replace the existing name with the following: Trans Date The Attributes pane appears, with our modifications, as depicted in Illustration 29.
Having created a new Aged Periods Dimension to serve as the structure for our new aging capabilities, we now need to create and populate a Hierarchy to house the Named Calculations we created in Part I to act as our "aging buckets." We will accomplish this in the next steps. 30. Right-click the newly renamed Aged Period attribute in the Attributes pane. 31. Select Start New Hierarchy, as shown in Illustration 30.
A new Aged Period hierarchy appears in the Hierarchies and Levels pane of the Aged Period Dimension Structure tab of the Designer for the Aged Period dimension. |
|
|
The Network for Technology Professionals
Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers
