Database Reference
In-Depth Information
4. Click on the Edit MDX button, and have a look at the code generated to cre-
ate the named set, which looks like this:
{([Product].[Product Hierarchy].[Product
Category].&[1]),
([Product].[Product Hierarchy].[Product
Category].&[3])}
5. Click on OK to create the set.
6. As you now can see Product Hierarchy is now removed from the PivotTable
Rows field and instead you can see that the My New Set is added to the re-
port.
Note
There are some limitations with the named set that you create. One is
that you cannot add it to the filters; another one is that you cannot add
another value from the same dimension hierarchy to the report.
Calculated measures
Another important feature in Excel when used as an analytical client is the ability to
create named measures that can be used in your PivotTables. In order to create a
measure, follow the given steps:
1. Click anywhere in the PivotTable, and then click on the Analyze tab in the
PivotTable contextual menu.
2. Click on the OLAP Tools button and the MDX Calculated Measure button.
3. In the New Calculated Measure dialog, type Sales plus 10 pct in the
Name field.
4. In the Measure Group drop-down field click on Fact Internet Sales as the
associated measure group for your new calculated measure.
5. Add the following MDX code to the MDX window:
[Measures].[Sales Amount] * 1.1
6. This will calculate the Sales Amount plus 10 percent.
Search WWH ::




Custom Search