GETOPGDIMSTATISTICS

Applies only to aggregate storage databases. Returns various kinds of outline paging statistics pertaining to the selected dimension and the selected outline paging section.

Syntax

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.

Section Description of section contents
1 Member Data Outline navigational information (for example, parent, child, or sibling), fixed-length information (for example, the line aggregation symbol or the number of children), and text strings (for example, member names or aliases)
2 Member Name Namespace Information that matches member names to internal member identifiers (one section per database, thus the information for all dimensions is the same)
3 Member Formula All formulas for the dimension
4 Member UDA All user defined attributes (UDAs) for the dimension
5 Member UDA Namespace Information that matches UDAs to internal member identifiers
6 Attibute To Base Member Association Information that identifies the attribute member associated with each base member of the dimension
7 Member Comment All member comments for the dimension
8 Member Alias Namespace Information that matches member alias names to internal member identifiers (one section per alias table thus the information for all dimensions is the same)

If you do not specify opgsection, Analytic Services prompts you to choose a section.

Description

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

Example

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

See Also

GETOPGCACHESTATISTICS
GETDBACTIVE
GETDBINFO
GETDBSTATE

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com