Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Dimension x Measure

  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Default 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

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default 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. #3
    Join Date
    Nov 2003
    Posts
    2

    Default 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@

  4. #4
    Join Date
    Nov 1999
    Posts
    1,618

    Default 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
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.