Default layout of a PowerPlay Cube

A default PowerCube layout is determined by the order of the dimensions and measures in a PowerPlay model. It can be adjusted in a PowerPlay model by a cube developer in Transformer.

The layout of each newly created Cube is the following:

  • Rows - first dimension from the left and categories from the first level in that dimension
  • Columns - second dimension and categories from the first level in that dimension
  • Measures - first (top) measure from the measures list

    The PowerPlay Cube report will also show row and column summary by default.

    Please refer to the screenshots below to see how PowerPlay transformer organizes measures and dimensions in a default layout.

    Default dimensions and measures in a model:
    Default dimensions and measures in a model

    Default layout of a powerplay cube:
    Default layout of a powerplay cube