Cube-Based MDX Calculations - Microsoft SQL Server 2008 Analysis Services - page 197

As with calculated members, you can define assignments that will be available in the
scope of the current query, of the current session, or of the cube. Assignments created for
the entire cube are stored in an MDX script; this sort of assignment is the most
commonly used type.

To create an assignment operator for use in the scope of the cube, follow the steps listed
here in BI Dev Studio:

1. In BI Dev Studio, open the FoodMart 2008 project.
2. In the Solution Explorer, double-click the Warehouse and Sales cube to open the
cube editor.
3. On the Calculations tab, right-click anywhere in the Script Organizer, and choose
New Script from the contextual menu.
4. In the right pane of the Calculations tab, type the assignment operator or copy and
paste the code from earlier in this section, as shown in Figure 12.7.

FIGURE 12.7

You use the Calculations tab to define an assignment operator.

After you deploy the MDX script that contains the assignment operator, the formula speci-
fied in the assignment operator calculates the cell values in the subcube:

SELECT [Measures].[Store Sales] ON COLUMNS,
[Store].[Stores].[Store Country].members ON ROWS
FROM [Warehouse and Sales]
WHERE ([Time].[Time].[Year].[1997])