1. Junior Member
Join Date
Feb 2002
Posts
2

## Dimension x Measure

Hi,
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.
Thanks,
Bob

Join Date
Nov 1999
Posts
1,618

## RE: Dimension x Measure

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

3. Junior Member
Join Date
Nov 2003
Posts
2

## RE: Dimension x Measure

Hi...
A question for the experienced people.
This case, can be solved with Virtual Cubes ????
thanks... and greetings for all...
SeB@

Join Date
Nov 1999
Posts
1,618

## RE: Dimension x Measure

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?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•