Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

grand-totals instead of sub-totals

Help
2004-10-13
2013-04-29
  • 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:

    SELECT
      {[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"/>
            </Hierarchy>
          </Dimension>
          <Measure name="Cost" column="cost" aggregator="sum" formatString="#,###.##"/>
          <Measure name="Revenue" column="revenue" aggregator="sum" formatString="#,###.##"/>
      </Cube>
      </Schema>

      Thank you for your help.

      --magictrickpony

       
    • 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??

      d'uh!

      thanks for your time!