Help Topics

Scope tab


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:

Dimension
Select the dimension whose members you want the calculation to be applied to. You can choose from the dimensions other than the dimension that the calculated member will be added to.
Scope for one or more members
Scope for one or more members
Adds members in the selected dimension to the scope.
Scope for a member expression
Scope for a member expression
Specifies a member function to add members in the selected dimension to the scope.

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.

 

Related topics: