Applies only to aggregate storage databases. Returns various kinds of outline paging statistics pertaining to the selected dimension and the selected outline paging section.
GETOPGDIMSTATISTICS dimensionname opgsection
dimensionname | The name of the dimension for which you want statistics. | |||||||||||||||||||||||||||
opgsection | The number of the outline paging section for which
you want statistics. The .otl outline file is
divided into sections, which are referred to as outline paging (OPG) sections.
Related metadata is grouped into each section.
For example, the Member Formula section contains all member formulas
for the specified dimension. Metadata is paged from the .otl outline file into the outline
paging cache.
Grouping metadata into sections provides more efficient metadata retrieval.
If you do not specify opgsection, Analytic Services prompts you to choose a section. |
The following columns are the output of GETOPGDIMSTATISTICS:
The version of the OPG section Number of unique keys in the OPG section Number of key/data pairs in the OPG section Underlying page size of the OPG section The minimum keys per page The length of fixed-length records The padding byte value for fixed-length records Number of levels in the OPG section Number of internal pages in the OPG section Number of leaf pages in the OPG section Number of duplicate pages in the OPG section Number of overflow pages in the OPG section Number of pages on the free list Number of bytes free in internal pages Number of bytes free in leaf pages Number of bytes free in duplicate pages Number of bytes free in overflow pages
SELECT Sample Basic; GETOPGDIMSTATISTICS Product;
Returns a prompt that provides the following list of outline paging (OPG) sections:
1) Member Data 2) Member Name Namespace 3) Member Formula 4) Member UDA 5) Member UDA Namespace 6) Attibute To Base Member Association 7) Member Comment 8) Member Alias Namespace
Selecting 1
returns the following information:
GetDimOPGState: ------- Statistics Data of OPG Section < Member Data > ------- The version of the OPG section : 9 Number of unique keys in the OPG section : 22 Number of key/data pairs in the OPG section : 22 Underlying page size of the OPG section : 1024 bytes The minimum keys per page : 2 The length of fixed-length records : 0 The padding byte value for fixed-length records : 32 Number of levels in the OPG section : 2 Number of internal pages in the OPG section : 1 Number of leaf pages in the OPG section : 2 Number of duplicate pages in the OPG section : 0 Number of overflow pages in the OPG section : 0 Number of pages on the free list : 0 Number of bytes free in internal pages : 966 Number of bytes free in leaf pages : 236 Number of bytes free in duplicate pages : 0 Number of bytes free in overflow pages : 0
GETOPGCACHESTATISTICS
GETDBACTIVE
GETDBINFO
GETDBSTATE
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |