Database Reference
In-Depth Information
View button is right next to the Form View button that resembles a form),
navigate all the way to the end of the MDX script, and add the following cal-
culation:
Scope
(
[Date].[Calendar].[Month].&[2008]&[5],
[product].[product
categories].[product].[Hitch Rack -
4-Bike],
[Measures].[reseller sales amount]
);
This =
(
[Date].[calendar].&[2008]&[5],
[product].[product
categories].[accessories]
) * 0.75;
3. Save the database. If you are making changes to the offline mode, you'll
need to deploy the database to the server.
4. Rerun the query specified in step 1. This time the result is $9,204.03, which
is 75 percent of the total [reseller sales amount], prior to applying the scope
assignment.
5. While still on the Calculations tab, find the [Internet Ratio to All
Products] calculation—you can hold down the CTRL key and press the
letter F to open the Find and Replace dialog. Note how the calculation com-
pares the [Internet Sales Amount] measure of the current member to
the topmost member of the dimension using the ROOT function:
CREATE MEMBER
CurrentCube.[measures].[Internet Ratio to
All Products] AS
Measures.[Internet Sales Amount] /
(
ROOT( [product] ),
Search WWH ::




Custom Search