grand-totals instead of sub-totals

  • magictrickpony

    magictrickpony - 2004-10-13

    Sincere greetings and things,

    First and foremost, thank you so much for offering and working on an open-source OLAP implementation. Jolly well done.

    Now to my actual bidding:

    I am trying to generate a simple cross-tab with the dimension time on one axis and the measures cost and revenue on the other. The thing is it works, but by drilling down time from year->quarter->month  instead of sub-totals of cost & revenue, all i get are
    grand-totals for each position.
    Time          Cost         Revenue
    - 2004   3.148,227.47

    MDX-query looks like this:

      {[Measures].[Cost], [Measures].[Revenue]} ON COLUMNS,
      {[Time]} ON ROWS
        FROM sql-view WHERE ([Time].[2004])

    • magictrickpony

      magictrickpony - 2004-10-13

      darn it. space-bar == submit you win again.

      Time           Cost                      Revenue
      - 2004          3.148,227.47          3,558,233.33
      - Q1             3.148,227.47          3,558,233.33
      - Q2             3.148,227.47          3,558,233.33
      - Q3             3.148,227.47          3,558,233.33
      - Q4             3.148,227.47          3,558,233.33

      Is my MDX query screwed, or the Query.xml definitions?  The dimensions are joined from the same column in the fact table, in this case a database view, actually.

      <Schema name="MySchema">
      <!-- Test a cube based upon a single table. -->
      <Cube name="sql-view">
          <Table name="sql-view-name"/>
              <Dimension name="Time">
            <Hierarchy hasAll="false">
              <Level name="Year" column="p_name_year" type="Numeric" uniqueMembers="true"/>
                <Level name="Quarter" column="p_quarter" type="String" uniqueMembers="false"/>  
          <Level name="Month" column="p_name_month" type="String" uniqueMembers="false"/>
          <Measure name="Cost" column="cost" aggregator="sum" formatString="#,###.##"/>
          <Measure name="Revenue" column="revenue" aggregator="sum" formatString="#,###.##"/>

      Thank you for your help.


    • Andreas Voss

      Andreas Voss - 2004-10-13

      You can not have the time dimension on two axes, rows and slicer.

    • magictrickpony

      magictrickpony - 2004-10-14

      oh my it is rather that simple, isn't it??


      thanks for your time!


Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks