|Oracle® OLAP DML Reference
10g Release 2 (10.2)
|PDF · Mobi · ePub|
The ALLSTAT command 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.
You can set the status of a single dimension to all its values with the LIMIT command.
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.
The following STATUS statement produces the current status of the dimensions of the variable 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
The current status of MONTH is: ALL The current status of PRODUCT is: ALL The current status of DISTRICT is: ALL