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