The scope is an optional property that defines which members the calculation applies to. If you do not set a scope, then the calculation applies to all members. The syntax for the scope string is:
dimension1:member1,member2; dimension2:member1,member2,...
For example, the following grid shows a calculated member named Average with the scope [Time]:[2000],[2002]; [Locations]:[West]
.
Locations | Time | Product 1 | Product 2 | Average |
East |
2000 | 21 | 16 | |
2001 | 17 | 14 | ||
2002 | 19 | 23 | ||
West |
2000 | 32 | 20 | 26 |
2001 | 38 | 18 | ||
2002 | 40 | 27 | 33.5 |
Note: The scope applies only to calculations on multidimensional databases.
The Scope tab has a text field that contains the text string that defines the scope. You can either type the scope in the text field or use the field and buttons to define the scope. The Scope tab contains the following fields and buttons:
|
|
![]() |
|
![]() |
|
You can specify additional scopes for your calculation by selecting another dimension and members in that dimension. If you do not define a scope, then the calculation applies to all members.