Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • Multidimensional Table Designer

    Introduction

    This designer allows you to create an XLCubed table from an Analysis Services cube. This can be useful for list style reporting.

    When compared to grids, these reports are easier for new users to create, but offer less functionality and interactivity.

    Designer

    After selecting a cube to report on, you will be presented with a simple designer with three areas.

    On the left is a list of the hierarchies in the cube. There can be dragged to the center section to include them as a column in the table. Individual members can be picked to restrict the rows returned.

    Finally the Measures section allows you to select the numbers you'd like to see for each row. These are displayed after the columns for the hierarchies.

    MultidimensionalTableDesigner.png
    MultidimensionalTableResults.png