dcsimg

MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of Total - Two Perspectives - Page 7

June 20, 2005

23.  Click the BrandSales_Product_Category field (second from the top in the Rows list) to select it.

24.  Click the Delete button to delete the group.

25.  Click the BrandSales_Product_Subcategory field (currently the middle entry in the Rows list) to select it.

26.  Click the Delete button to delete the group.

27.  Click the BrandSales_Brand_Name field (currently the bottom entry in the Rows list) to select it.

28.  Click the Delete button to delete the group.

29.  Click the BrandSales_Quarter field (currently the middle entry in the Columns list) to select it.

30.  Click the Delete button to delete the group.

The Groups tab appears, after our deletions, as depicted in Illustration 37.

Click for larger image

Illustration 37: Groups Tab after Eliminations

31.  Click the BrandSales_Product_Department group (now the only entry in the Rows list) to select it.

32.  Click Edit.

The Grouping and Sorting Properties dialog for the group opens to the General tab.

33.  Type the following into the Name box on the General tab, replacing the existing name:

StoreName.

34.  Select Fields!Store_Store_Name.Value within the dropdown selector of the Expression list, in the Group on section.

The Grouping and Sorting Properties dialog appears as shown in Illustration 38.


Illustration 38: The Grouping and Sorting Properties Dialog with Our Changes

35.  Click OK to accept changes and close the Grouping and Sorting Properties dialog for the StoreName group.

36.  Click OK to accept changes, and to close the Matrix Properties dialog, and to return to the Layout view in Report Designer.

Only a few minor changes remain to prepare the report for its new uses.

37.  Right-click the textbox underneath the report title, currently displaying =Fields!Product_Department.Value.

38.  Select Properties from the context menu that appears, as depicted in Illustration 39).


Illustration 39: Select Properties from the Context Menu ...

The Textbox Properties dialog opens.

39.  Replace the contents of the Name box with the following:

StoreName.

40.  Click the Function button ("fx") to the right of the Value box.

The Edit Expression dialog appears.

41.  Replace the contents of the Expression pane (the right half of the dialog) with the following expression:

= Fields!Store_Store_City.Value & " - " &  Fields!Store_Store_Name.Value

The Edit Expression dialog appears as shown in Illustration 40.


Illustration 40: Edit Expression Dialog with Our Modifications

42.  Click OK to accept changes and return to the Textbox Properties dialog, which appears as depicted in Illustration 41.


Illustration 41: Textbox Properties Dialog

43.  Click OK to close the Textbox Properties dialog.

44.  Click the textbox under the Store Cost label in the Matrix, as shown in Illustration 42, to select it.


Illustration 42: Targeting Store Cost for Elimination ...

45.  Touch the Delete key.

Store Cost disappears from the report.

46.  Click the textbox under the Store Profit label in the Matrix, as depicted in Illustration 43, to select it.


Illustration 43: Targeting Store Profit for Deletion ...

47.  Touch the Delete key.

Store Profit disappears from the report. The Multi-Layer_Calculations report, Layout view, appears as shown in Illustration 44.


Illustration 44: The Multi-Layer_Calculations Report - Layout View

We need to complete a final "cleanup" step before executing the report.

48.  Right-click the Store_Profit calculated field in the Fields list.

49.  Select Delete from the context menu that appears, as depicted in Illustration 45.


Illustration 45: Deleting the Store_Profit Calculated Field

This removes the calculated field, which is no longer relevant to our report, from the list.

50.  Click the Preview tab to execute the modified report.

The Multi-Layer_Calculations report appears as shown in Illustration 46.


Illustration 46: Multi-Layer_Calculations, Reflecting Our Modifications

The report's layout has been altered sufficiently to meet the layout requirements as expressed by the information consumers. We are now ready to insert the calculated member that we created in the cube earlier.








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers