[Mondrian] Querying all composions of dimensions (lots of queries!)

mehdi b mehdi_xinu at yahoo.com
Thu May 12 07:37:40 EDT 2011


Hi,

My schema is

<Schema name="TypesMart">
  <Cube name="Types" cache="true" enabled="true">
    <Table name="MNTR_DATA_TYPE_SPCF"/>
        
    <Dimension name="TrxDate">
      <Hierarchy hasAll="true" allMemberName="All">
        <Level name="TrxDate" column="TRXS_DATE" uniqueMembers="true" type="Numeric"/>
      </Hierarchy>
    </Dimension>

    <Dimension name="TrnType">
      <Hierarchy hasAll="true" allMemberName="All">
        <Level name="TrnType" column="TRN_TYPE" uniqueMembers="true" type="Numeric"/>
      </Hierarchy>
    </Dimension>

    <Dimension name="TermType">
      <Hierarchy hasAll="true" allMemberName="All">
        <Level name="TermType" column="TERM_TYPE" uniqueMembers="true" type="Numeric"/>
      </Hierarchy>
    </Dimension>

    <Dimension name="AcqIss">
      <Hierarchy hasAll="true" allMemberName="All">
        <Level name="AcqIss" column="ACQ_ISS_TYPE" uniqueMembers="true" type="Numeric"/>
      </Hierarchy>
    </Dimension>

    <Measure name="Trx" column="COUNT_" datatype="Integer" aggregator="sum"/>

  </Cube>
</Schema>

and I executed the following MDX 
SELECT {[TrnType].members} ON COLUMNS,{CrossJoin([TermType].members, [AcqIss].members)} ON ROWS FROM [Types] WHERE [TrxDate].[2.0110403E7]

and I checked the executed sql queries. It seems that the TrxDate dimension is in all "group by" queries. But for other dimensions, the compositions of other dimensions are executed which in this case leads to C(3,1)+C(3,2)+C(3,3)=7 "group by" queries.
Is it possible for Mondrian to only executes C(3,3) "group by" query and calculate the others in memory based on the measure aggregate method?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110512/749e7735/attachment.html 


More information about the Mondrian mailing list