Syntax for Describing the Area
The Area identifies one or more cells in a cube.
Consider the following guidelines when you create an Area definition.
- Specify no dimension elements, or one or more dimension elements.
- Each element must be from a different dimension of the cube.
- Enclose each element in single quotes.
- Use commas to separate each element.
- Enclose the entire Area definition in brackets.
The following table shows four Area examples. Each successive example narrows the scope.
Sample Area |
Scope |
---|---|
[ ] |
All cells in the cube. |
['January'] |
All cells identified by a January element. |
['Sales','January'] |
All cells identified by the Sales and January elements. |
['Germany','Sales','January'] |
All cells identified by the Germany, Sales, and January elements. |