5.
Click Close
to dismiss the viewer.
6.
Click Close
to dismiss the Process
Cube dialog.
We can
get to the Browser, at this stage, and see the effects of our handiwork
within the cube, by taking the following steps.
7.
Click the ANSYS045
- Named Calculations.cube tab within the design environment, once again.
8.
Click the Browser
tab within the Cube Designer, as shown in Illustration 49.
9.
Select Cube
---> Reconnect from the main menu, as depicted in Illustration 50, to
ensure that we are browsing an updated copy.
Illustration 50: Reconnect
the Cube ... "To Ensure Freshness"
10.
Within the
tree appearing inside the Metadata pane to the left, expand Dim Sales Territory by clicking the "+"
sign to its immediate left.
11. Drag Dim Sales Territory.Sales
Territory Group to the area marked Drop Row Fields Here within the
pivot table area, as shown in Illustration 51.
Illustration 51: Creating
a PivotTable Browse ...
12. Within the Metadata pane,
once again, expand Aged Periods.
13. Drag Hierarchy to the area
marked Drop Column Fields Here within the pivot table area.
14. Expand Measures.
15. Expand the Fact Reseller Sales
folder.
16. Drag Sales Amount to the
area marked Drop Totals or Detail Fields Here within the pivot table
area.
17. The Browser pivot table
area appears as depicted in
Illustration 52.
Illustration 52: The
Browser Pivot Table with Additions ...
We can see
that the Sales Amounts totals appear within their respective "aging
buckets."
18. Expand the < 30 "aging
bucket," by clicking the "+" sign to its immediate left.
The <
30 Aged Period expands to reveal the totals, by Ship Date, that make
it up, as partially shown in Illustration 53.
Illustration 53: The Sales Amounts
Totaled by Sales Date (Partial View)
We can
visualize an array of reporting capabilities at this point, once we add
formatting, subtotal and other nuances. For now, we will conclude our article,
having focused upon the construction of one approach to the creation of an
aging capability, using Named Calculations to extend the data underlying
our cube to afford us a presentation capability that we might not otherwise
have had.
19. Examine other features of the Aged
Period dimension within the Cube Browser as desired.
20. Select File --> Save All from the main menu, to save our
work through this point, as depicted in Illustration 54.
Illustration 54: Saving Our Work
from the Session
21. Select File --> Exit, when ready, to leave the Business
Intelligence Development Studio.
Conclusion
In
this "second half" of a two-part article, we continued the
examination of Named Calculations we began in Mastering Enterprise BI: Extend the Data Source with Named
Calculations, Pt. I.
We briefly summarized our introduction in Part I, where we focused initially upon the Data Source View as a significant design
and development enhancement within Analysis Services, and then overviewed our stated objective to examine
Named Calculations. Moreover, we reviewed our initial steps in the
construction of working examples, based upon an illustrative business need to
create "aging buckets" within our cube to support a reporting and
analysis capability.
In
this article, we returned to the Named Calculations we had created in Part I, and next created a Cube containing data from our sample
relational tables. We then added a Dimension based upon two of our Named
Calculations, to contain "aging buckets. We reviewed our new Aged
Periods dimension to ascertain that its structure appeared as expected, and
then we deployed our solution, and processed our cube. Finally, we browsed the
Cube, focusing on the new aging dimension structures, to verify their
operation within the design environment.
»
See All Articles by Columnist William E. Pearson, III
Discuss this article in the MSSQL Server 2000 Analysis Services and MDX Topics Forum.
» 
Comment and Contribute
