View Full Version : Dimension x Measure

08-26-2003, 10:59 AM
I am new to Mondrian, and I was wondering, how do I write a schema in order to achieve the result showed in Mondrian's help (What is Mondrian?).
In that table, they have rows to total, books, fiction, etc... And also they have two columns: dollar sales and unit sales.
No problem with that. I am able to do this.
My problem is that they have used years (2000, 2001) on the top of columns, grouping measures by year... How do I do this?
I don't know if I could make myself understood. Sorry my english.

08-26-2003, 04:44 PM
The important concept with MDX is that everything you can put on an axis is a member. '2000', 'January 2000', and 'Books' are all members. 'Dollar sales' and 'Unit sales' are members too -- of a special type, namely measures.
So the solution to your problem is to place time members such as 2000 on the columns axis.
An example on the FoodMart schema:
select {[Time].[1997], [Time].[1997].[Q1]} on columns,
{[Store].[USA].children} on rows
from Sales
If you want to have 2 sets of members on the same axis, use the Crossjoin operator:
select Crossjoin(
{[Time].[1997], [Time].[1997].[Q1]},
{[Measures].[Unit Sales], [Measures].[Store Sales]}) on columns,
{[Store].[USA].children} on rows
from Sales

11-06-2003, 01:45 AM
A question for the experienced people.
This case, can be solved with Virtual Cubes ????
thanks... and greetings for all...

11-06-2003, 05:26 AM
I showed how this case could be solved with a regular cube and the CrossJoin function. Why do you think you would want use a virtual cube?