Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The ALLSTAT program sets the status of all dimensions in the current analytic workspace to all their values. ALLSTAT does not, however, set the status of the NAME dimension.
ALLSTAT
You can set the status of a single dimension to all its values with the LIMIT command.
ALLSTAT and the LOCK_LANGUAGE_DIMS Option
When LOCK_LANGUAGE_DIMS is TRUE
, ALLSTAT ignores language dimensions. When LOCK_LANGUAGE_DIMS is FALSE
, ALLSTAT treats language dimensions the same way it treats other dimensions.
Example 9-43 Limiting to All Values
The following STATUS statement produces the current status of the dimensions of the variable UNITS.
status units
The current status of MONTH is: Jul96 TO Dec96 The current status of PRODUCT is: Tents TO Racquets The current status of DISTRICT is: DALLAS
After you execute an ALLSTAT statement the same STATUS statement produces this output.
The current status of MONTH is: ALL The current status of PRODUCT is: ALL The current status of DISTRICT is: ALL