Difference between revisions of "Multidimensional Table Designer"
(→Designer) |
|||
Line 12: | Line 12: | ||
[[Image:MultidimensionalTableDesigner.png|thumb|center|500px]] | [[Image:MultidimensionalTableDesigner.png|thumb|center|500px]] | ||
+ | |||
+ | [[Image:MultidimensionalTableResults.png|thumb|center|500px]] |
Revision as of 15:27, 30 April 2012
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.