-
SQL server MDX ROWS, COLUMNS, cellset
Given the MDX query below:
SELECT
Time.Fiscal.FiscalYear.[2002/03] :
Time.Fiscal.FiscalYear.[2007/08] ON ROWS,
Crossjoin({Region.London, Region.SouthEast, Region.RestOfUK},
{Sector.Retail, Sector.Office, Sector.Other}) ON COLUMNS
FROM
FinancialCube
WHERE
(Measures.Turnover,
Residential,
Actual)
What is the answer to the questions below, explaining any assumptions you’ve made:
a) What is the dimensionality of the ROWS axis?
b) What is the dimensionality of the COLUMNS axis?
c) How many rows and columns would you expect to find in the resulting cellset?
Thank you for your advice in advance.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|