Databases Reference
In-Depth Information
Page dimensions
Page dimensions are members that only need to be mentioned once on the page
header and the resultant report will only contain data for that member. For example,
if you were to place the member
Canada
from the
Total Market
dimension as a page
dimension, all of the data in the report will be for the
Canada
market.
Row dimensions
Row dimensions are members that populate the report's row headings. For example,
if you wanted to create a report that has all of the vehicles listed on the left as row
headings, you would drag-and-drop the
Total Vehicles
dimension tile from the
Page
Dimension
section to the
Row Dimension
section and tell it to extract the children
of the
Total Vehicles
dimension.
Depending on your other choices, the resultant report will contain data displayed
with the individual vehicles listed as row headings.
Column dimensions
Just like the row dimensions, column dimensions are the members you use for the
column headings on your report. For example, a common way to set up a report that
shows a year's worth of data is to have the individual months placed horizontally
across the top of the columns. What you would do is drag-and-drop the
Calendar
Periods
dimension tile into the
Column Dimensions
section and setup the rule that
selects the desired range of months you need.
Sample query
By looking at the previous screenshot you will see that if you were to retrieve
data based on the default dimension placement, you would not get a very
informative report.
For starters, the page dimensions listed are
Total Vehicles
,
Total Market
, and
Model
Year
. Without any changes this will give you a report where all of the data returned
would be at the
Total Vehicle
,
Total Market
, and total
Model Year
level. Not a very
granular report to say the least. The fact that the
Measures
dimension is placed in
the
Row Dimensions
section and the
Calendar Periods
dimension is placed in the
Column Dimensions
section, is the only thing saving this query.