Show Source

• averageBundleFill: number(double)

  Applies to aggregate storage cubes only. Estimated average number of values per compression dimension bundle. Choosing a compression dimension that has a higher average bundle fill means that the cube compresses better.

• averageValueLength: number(double)

  Estimated average number of bytes required to store a value. Dimensions with a smaller average value length compress the cube better.

• dimensionName: string

  Dimension name hypothetically considered to be the aggregate storage compression dimension, for purposes of estimating compression statistics.

• isCompression: boolean

  Whether this is an aggregate storage compression dimension. By default, the compression dimension is the Accounts dimension. There can be only one compression dimension in an aggregate storage cube.

• level0MB: number(double)

  Estimated size of the compressed cube, in megabytes. A smaller expected level-0 size indicates that choosing this dimension enables better compression. Except for the scenario in which there is no compression dimension (None), all estimates assume that all pages are compressed. Since compressed pages require additional overhead that uncompressed pages do not, the estimated level-0 database size for some dimensions may be larger than the value for None.

• storedLevel0Members: number(double)

  Number of stored level 0 members. Aggregate storage compression dimensions with a large number of stored level 0 members do not perform optimally. As with any dynamically calculated dimension, upper-level retrievals from compression dimensions generally are slower.

{
    "type":"object",
    "description":"<p>Estimated compression statistics for an aggregate storage cube, with different dimensions hypothetically used as the compression dimension. These estimates can help you choose the best compression dimension.</p>",
    "properties":{
        "isCompression":{
            "type":"boolean",
            "description":"<p>Whether this is an aggregate storage compression dimension. By default, the compression dimension is the Accounts dimension. There can be only one compression dimension in an aggregate storage cube.</p>"
        },
        "storedLevel0Members":{
            "type":"number",
            "description":"<p>Number of stored level 0 members. Aggregate storage compression dimensions with a large number of stored level 0 members do not perform optimally. As with any dynamically calculated dimension, upper-level retrievals from compression dimensions generally are slower.</p>",
            "format":"double"
        },
        "averageBundleFill":{
            "type":"number",
            "description":"<p>Applies to aggregate storage cubes only. Estimated average number of values per compression dimension bundle. Choosing a compression dimension that has a higher average bundle fill means that the cube compresses better.</p>",
            "format":"double"
        },
        "averageValueLength":{
            "type":"number",
            "description":"<p>Estimated average number of bytes required to store a value. Dimensions with a smaller average value length compress the cube better.</p>",
            "format":"double"
        },
        "level0MB":{
            "type":"number",
            "description":"<p>Estimated size of the compressed cube, in megabytes. A smaller expected level-0 size indicates that choosing this dimension enables better compression. Except for the scenario in which there is no compression dimension (None), all estimates assume that all pages are compressed. Since compressed pages require additional overhead that uncompressed pages do not, the estimated level-0 database size for some dimensions may be larger than the value for None.</p>",
            "format":"double"
        },
        "dimensionName":{
            "type":"string",
            "description":"<p>Dimension name hypothetically considered to be the aggregate storage compression dimension, for purposes of estimating compression statistics.</p>"
        }
    }
}