Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II - Page 11July 11, 2005 At this point, we will create calculated members for the other relative time aggregations that the information consumers have requested in their business needs specifications. We will follow the steps we took in creating the Year-to-Date Total for each of the additional relative time members we need, basing our construction of the calculated members on the settings presented in the steps and tables that follow. 22. Right-click the Calculated Members folder in the tree, once again. 23. Select New Calculated Member ... on the context menu that appears. The Calculated Member Builder opens. 24. Create the Quarter-to-Date Total calculated member by completing the fields of the Calculated Member Builder, with the settings presented in Table 3 below.
Table 4: Calculated Member Builder Settings: Month-to-Date Total Calculated Member The Calculated Member Builder appears, with our input, as shown in Illustration 59.
29. Click OK. The Calculated Member Builder closes, and the new Month-to-Date Total calculated member joins the other members of the Calculated Members folder. Let's create the three "comparative" calculated members requested by the information consumers next. 30. Right-click the Calculated Members folder in the tree, once again. 31. Select New Calculated Member ... on the context menu that appears. The Calculated Member Builder opens. 32. Create the Prior Year Total calculated member by completing the fields of the Calculated Member Builder to with the settings presented in Table 5 below.
Table 5: Calculated Member Builder Settings: Prior Year Total Calculated Member The Calculated Member Builder appears, with our input, as depicted in Illustration 60.
33. Click OK. The Calculated Member Builder closes, and the new Prior Year Total calculated member joins the other calculated members in the tree, as before. NOTE: For more information on the ParallelPeriod()
function, see my 34. Right-click the Calculated Members folder in the tree, once again. 35. Select New Calculated Member ... on the context menu that appears. The Calculated Member Builder opens. 36. Create the Prior Quarter Total calculated member by completing the fields of the Calculated Member Builder, with the settings presented in Table 6 below.
Table 6: Calculated Member Builder Settings: Prior Quarter Total Calculated Member The Calculated Member Builder appears, with our input, as shown in Illustration 61.
37. Click OK. The Calculated Member Builder closes, and we see Prior Quarter Total appear in the Calculated Members folder within the tree. Let's create the final calculated member, Prior Month Total, to support the information consumers' expressed business requirements via the Relative Time dimension. 38. Right-click the Calculated Members folder in the tree, as before. 39. Select New Calculated Member ... on the context menu that appears. The Calculated Member Builder opens. 40. Create the Prior Month Total calculated member by completing the fields of the Calculated Member Builder, with the settings presented in Table 7 below.
Table 7: Calculated Member Builder Settings: Prior Month Total Calculated Member The Calculated Member Builder appears, with our input, as depicted in Illustration 62.
41. Click OK. The Calculated Member Builder closes. We see the results of our handiwork within the complete members within the Calculated Members folder that appears in Illustration 63.
We have created the members of the Relative Time dimension required to support the capabilities requested by the client information consumers. We will conclude this exercise with a quick verification of the operation of these structures in the section that follows. A subsequent article in my MSSQL Server Reporting Services series will focus upon the use of the structures within an enterprise reporting environment. |
|
|
The Network for Technology Professionals
Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers
