*SCOPE_BY

Allowed uses: Global, MDX, SQL

*SCOPE_BY = {dimensions list)

By default, the data region is restricted to only the members found in an existing data file or values from an Excel sheet for all dimensions except the account dimension. This instruction allows you to expand the scope of the data region.

Using this instruction can be useful to expand the scope of a logic execution, when data is entered through Interface for Excel, or from an import file. If, for example, the formulas to execute span across all products, regardless of what products have been modified, you can expand the scope of the execution to all products by redefining SCOPE_BY with a list of dimensions that does not include the product. In this case, the instruction could be:

*SCOPE_BY = CATEGORY, TIME, ENTITY

The logic runs for all noncalculated products.

In many cases it may be more practical to modify the scope of the logic execution using the instruction *XDIM_MEMBERSET. This instruction allows the administrator to specify what members to process for a given dimension, in effect, overriding the default scope with greater precision.