Jump to

• Request
• Response
• Examples

Get Storage Statistics

get

/essbase/rest/v1/applications/{applicationName}/databases/{databaseName}/statistics/storage

Returns storage statistics of the specified database.

Request

Path Parameters

• applicationName: string

  Application name.

• databaseName: string

  Database name.

Back to Top

Response

Supported Media Types

• application/json
• application/xml

200 Response

OK

Database storage statistics returned successfully.

Body ()

Root Schema : StorageStatistics

Type: object

Show Source

• aggregateDataSize(optional): integer(int32)

  For aggregate storage cubes, the total disk space occupied by aggregate cells

• averageClusteringRatio(optional): number(double)

  A measure of the fragmentation of the page file. A value close to 1 indicates the degree of fragmentation is low. A value close to zero indicates a high degree of fragmentation that could affect calculation and query performance.

• blockDensity(optional): number(double)

  The average block density (calculated using all currently loaded blocks)

• blockSize(optional): integer(int32)
• compressionRatio(optional): number(double)

  Average data block compression ratio

• costOfQueryingIncrementalData(optional): number(double)

  For aggregate storage cubes, the average percentage of query time spent processing incremental data slices. This is useful in deciding when slices should be merged together to improve query performance.

• dimensions(optional): array dimensions
• existingLevelZeroBlocks(optional): number(double)

  The number of non-missing leaf (lowest level) blocks in the cube

• existingUpperLevelBlocks(optional): number(double)

  The number of non-missing, non-leaf (upper level) blocks in the cube

• indexFileSize(optional): integer(int64)
• inputLevelDataSize(optional): integer(int32)

  For aggregate storage cubes, the total disk space used by input-level data

• maxKeyLengthBits(optional): integer(int32)

  For aggregate storage cubes, the sum of all the bits used by each dimension. For example, there are 20 bits in the key used for dimensions, and the first 4 are used by Year.

• maxKeyLengthBytes(optional): integer(int32)

  For aggregate storage cubes, how many bytes the key uses per cell

• numberOfAggregateCells(optional): integer(int32)

  For aggregate storage cubes, the number of cells stored in aggregate views

• numberOfAggregateViews(optional): integer(int32)

  For aggregate storage cubes, the number of aggregate views, including those automatically built on incremental slices

• numberOfExistingBlocks(optional): number(double)

  Total number of existing data blocks (not the maximum)

• numberOfIncrementalAggregateCells(optional): integer(int32)

  For aggregate storage cubes, the number of cells stored in the incremental slices' aggregate views

• numberOfIncrementalDataSlices(optional): integer(int32)

  For aggregate storage cubes, the number of data slices resulting from incremental data loads

• numberOfIncrementalInputCells(optional): integer(int32)

  For aggregate storage cubes, the number of level-0 cells in the incremental data slices

• numberOfInputLevelCells(optional): integer(int32)

  For aggregate storage cubes, the number of existing level-0 cells in the database, including incremental slices

• pageFileSize(optional): integer(int64)
• percentageOfMaximumBlocksExisting(optional): number(double)
• potentialNumberOfBlocks(optional): number(double)

{
    "type":"object",
    "properties":{
        "dimensions":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/StatisticsDimensions"
            }
        },
        "maxKeyLengthBits":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the sum of all the bits used by each dimension. For example, there are 20 bits in the key used for dimensions, and the first 4 are used by Year.</p>",
            "format":"int32"
        },
        "maxKeyLengthBytes":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, how many bytes the key uses per cell</p>",
            "format":"int32"
        },
        "numberOfInputLevelCells":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of existing level-0 cells in the database, including incremental slices</p>",
            "format":"int32"
        },
        "numberOfIncrementalDataSlices":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of data slices resulting from incremental data loads</p>",
            "format":"int32"
        },
        "numberOfIncrementalInputCells":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of level-0 cells in the incremental data slices</p>",
            "format":"int32"
        },
        "numberOfAggregateViews":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of aggregate views, including those automatically built on incremental slices</p>",
            "format":"int32"
        },
        "numberOfAggregateCells":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of cells stored in aggregate views</p>",
            "format":"int32"
        },
        "numberOfIncrementalAggregateCells":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of cells stored in the incremental slices' aggregate views</p>",
            "format":"int32"
        },
        "costOfQueryingIncrementalData":{
            "type":"number",
            "description":"<p>For aggregate storage cubes, the average percentage of query time spent processing incremental data slices. This is useful in deciding when slices should be merged together to improve query performance.</p>",
            "format":"double"
        },
        "inputLevelDataSize":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the total disk space used by input-level data</p>",
            "format":"int32"
        },
        "aggregateDataSize":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the total disk space occupied by aggregate cells</p>",
            "format":"int32"
        },
        "numberOfExistingBlocks":{
            "type":"number",
            "description":"<p>Total number of existing data blocks (not the maximum)</p>",
            "format":"double"
        },
        "blockSize":{
            "type":"integer",
            "format":"int32"
        },
        "potentialNumberOfBlocks":{
            "type":"number",
            "format":"double"
        },
        "existingLevelZeroBlocks":{
            "type":"number",
            "description":"<p>The number of non-missing leaf (lowest level) blocks in the cube</p>",
            "format":"double"
        },
        "existingUpperLevelBlocks":{
            "type":"number",
            "description":"<p>The number of non-missing, non-leaf (upper level) blocks in the cube</p>",
            "format":"double"
        },
        "blockDensity":{
            "type":"number",
            "description":"<p>The average block density (calculated using all currently loaded blocks)</p>",
            "format":"double"
        },
        "percentageOfMaximumBlocksExisting":{
            "type":"number",
            "format":"double"
        },
        "compressionRatio":{
            "type":"number",
            "description":"<p>Average data block compression ratio</p>",
            "format":"double"
        },
        "averageClusteringRatio":{
            "type":"number",
            "description":"<p>A measure of the fragmentation of the page file. A value close to 1 indicates the degree of fragmentation is low. A value close to zero indicates a high degree of fragmentation that could affect calculation and query performance.</p>",
            "format":"double"
        },
        "pageFileSize":{
            "type":"integer",
            "format":"int64"
        },
        "indexFileSize":{
            "type":"integer",
            "format":"int64"
        }
    }
}

Nested Schema : dimensions

Type: array

Show Source

• Array of: object StatisticsDimensions

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/StatisticsDimensions"
    }
}

Nested Schema : StatisticsDimensions

Type: object

Show Source

• bits(optional): number(double)
• levels(optional): string
• name(optional): string

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string"
        },
        "levels":{
            "type":"string"
        },
        "bits":{
            "type":"number",
            "format":"double"
        }
    }
}

400 Response

Bad Request

Failed to get storage statistics. The application or database name may be incorrect.

500 Response

Internal Server Error.

Back to Top

Examples

The following example shows how to get storage statistics for a cube.

This example uses cURL to access the REST API from a Windows shell script. The calling user's ID and password are variables whose values are set in properties.bat.

Script with cURL Command

call properties.bat
curl -X GET "https://myserver.example.com:9001/essbase/rest/v1/applications/Sample_Dynamic/databases/Basic/statistics/storage" -H "accept: application/json" -u %User%:%Password%

Example of Response Body

{
  "storage": {
    "maxKeyLengthBits": 0,
    "maxKeyLengthBytes": 0,
    "numberOfInputLevelCells": 0,
    "numberOfIncrementalDataSlices": 0,
    "numberOfIncrementalInputCells": 0,
    "numberOfAggregateViews": 0,
    "numberOfAggregateCells": 0,
    "numberOfIncrementalAggregateCells": 0,
    "costOfQueryingIncrementalData": 0,
    "inputLevelDataSize": 0,
    "aggregateDataSize": 0,
    "numberOfExistingBlocks": 354,
    "blockSize": 672,
    "potentialNumberOfBlocks": 1900,
    "existingLevelZeroBlocks": 354,
    "existingUpperLevelBlocks": 0,
    "blockDensity": 83.61904761904762,
    "percentageOfMaximumBlocksExisting": 18.63157894736842,
    "compressionRatio": 0.9943010752688172,
    "averageClusteringRatio": 0.33334593787222777,
    "pageFileSize": 294969,
    "indexFileSize": 8216576
  }
}

Back to Top