[Mondrian] Reg .Aggregate Tables

Peter Tran ptran at prospricing.com
Thu Dec 13 11:58:50 EST 2007


Enable the olap trace and look at the SQLs.
 
 
http://mondrian.pentaho.org/documentation/configuration.php
 
mondrian.trace.level
<http://mondrian.pentaho.org/api/mondrian/olap/MondrianProperties.html#T
raceLevel> 
 
-Peter

________________________________

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Smruti Naik
Sent: Thursday, December 13, 2007 12:38 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Reg .Aggregate Tables


Hi ,
I am using Aggregate tables in my schema .how can i confirm that whether
its using aggreagate tables or 
still getting data from fact tables .
 
This is my schema file.
 
<?xml version="1.0" encoding="UTF-8"?>
<Schema name="Session_Schema">
 <Dimension name="Time" type="TimeDimension">
    <Hierarchy hasAll="false" primaryKey="TIME_ID"> 
      <Table name="TIME_BY_DAY"/>
      <Level name="Year" column="THE_YEAR" type="Numeric"
uniqueMembers="true"
          levelType="TimeYears"/> 
      <Level name="Quarter" column="QUARTER" uniqueMembers="false"
          levelType="TimeQuarters"/>
      <Level name="Month" column="MONTH_OF_YEAR" nameColumn="THE_MONTH"
uniqueMembers="false" type="Numeric" 
          levelType="TimeMonths"/>
   <Level name="Day" column="DAY_OF_MONTH" uniqueMembers="false"
type="Numeric"
          levelType="TimeDays"/> 
    </Hierarchy>   
  <Hierarchy hasAll="true" name="Weekly" primaryKey="TIME_ID"
          defaultMember="[Time.Weekly].[All Time.Weeklys].[2007]">
      <Table name="TIME_BY_DAY"/> 
    
      <Level name="Year" column="THE_YEAR" uniqueMembers="true"
levelType="TimeYears"/>
   <Level name="Week" column="WEEK_OF_YEAR" uniqueMembers="false"
levelType="TimeWeeks"/> 
       <Level name="Day" column="DAY_OF_MONTH" uniqueMembers="false"
levelType="TimeDays"/>  
<!-- <Level name="Week1" column="WEEK_OF_YEAR" uniqueMembers="false"
levelType="TimeWeeks"/>
    <Property name="Week" column="WEEK_OF_YEAR" formatter="
com.acme.MyPropertyFormatter"/>
<Level name="Day1" column="DAY_OF_MONTH" uniqueMembers="false"
          levelType="TimeDays"/>
    <Property name="Day" column="DAY_OF_MONTH" formatter="
com.acme.MyPropertyFormatter"/> -->
   </Hierarchy>
  </Dimension>
  <Cube name="Session">
  <Table name="CAL_USERSESSION_FACT">         
  <AggName name="AGG_YQM_CAL_USERSESSION_FACT"> 
    <AggFactCount column="FACT_COUNT"/> 
    <AggMeasure name="[Measures].[Application Time]"
column="AVG_APPLICATION_TIME"/>
    <AggMeasure name="[Measures].[Productive Application Time]"
column="AVG_PROD_APP_TIME"/> 
    <AggMeasure name="[Measures].[Idle Time]" column="AVG_IDLE_TIME"/>
    <AggMeasure name="[Measures].[Break Time]" column="AVG_BREAK_TIME"/>
    <AggMeasure name="[Measures].[TOS]" column="AVG_TOTAL_SESSIONTIME"/>

    <AggMeasure name="[Measures].[Breaks]" column="AVG_NO_OF_BREAKS"/>
    <AggMeasure name="[Measures].[Average Touch Time]"
column="AVG_TOUCH_TIME"/>
    <AggMeasure name="[Measures].[No Of Trans]"
column="AVG_TRANSACTION_COUNT"/> 
    <AggLevel name="[Time].[Year]" column="THE_YEAR" />
    <AggLevel name="[Time].[Quarter]" column="QUARTER" />
    <AggLevel name="[Time].[Month]" column="MONTH_OF_YEAR" /> 
   </AggName>   
   <AggName name="AGG_YW_CAL_USERSESSION_FACT"> 
    <AggFactCount column="FACT_COUNT"/>
    <AggMeasure name="[Measures].[Application Time]"
column="AVG_APPLICATION_TIME"/> 
    <AggMeasure name="[Measures].[Productive Application Time]"
column="AVG_PROD_APP_TIME"/>
    <AggMeasure name="[Measures].[Idle Time]" column="AVG_IDLE_TIME"/> 
    <AggMeasure name="[Measures].[Break Time]" column="AVG_BREAK_TIME"/>
    <AggMeasure name="[Measures].[TOS]" column="AVG_TOTAL_SESSIONTIME"/>
    <AggMeasure name="[Measures].[Breaks]" column="AVG_NO_OF_BREAKS"/> 
    <AggMeasure name="[Measures].[Average Touch Time]"
column="AVG_TOUCH_TIME"/>
    <AggMeasure name="[Measures].[No Of Trans]"
column="AVG_TRANSACTION_COUNT"/>
    <AggLevel name="[Time.Weekly].[Year]" column="THE_YEAR" />
    <AggLevel name="[Time.Weekly].[Week]" column="WEEK_OF_YEAR" />
   </AggName>
   </Table>  
 <DimensionUsage name="Time" source="Time" foreignKey="TIMEID"/>
 <Dimension name="Orgunit" foreignKey="TEAMID">
  <Hierarchy hasAll="true"  allMemberName="All Members"
primaryKey="TEAMID"> 
   <Table name="V_ORGUNIT"/>
   <Level name="COE" column="COE_ID" nameColumn="COE_NM"
uniqueMembers="false" type="Numeric"/>
   <Level name="SDU" column="SDU_ID" nameColumn="SDU_NM"
uniqueMembers="false" type="Numeric"/> 
   <Level name="PROCESS" column="PROCESS_ID" nameColumn="PROCESS_NM"
uniqueMembers="false" type="Numeric"/>
   <Level name="TEAM" column="TEAMID" nameColumn="TEAMNAME"
uniqueMembers="false" type="Numeric" /> 
  </Hierarchy>
 </Dimension>
 
  <Measure name="User" column="USERID" aggregator="count"
formatString="#,##0"/>
  <Measure name="Application Time" column="AVG_APPLICATION_TIME"
aggregator="avg" formatter=" com.ilogicon.HourMinuteFormatter">
  </Measure>
  <Measure name="Productive Application Time" column="AVG_PROD_APP_TIME"
aggregator="avg"  formatter="com.ilogicon.HourMinuteFormatter "/>
  <Measure name="Idle Time" column="AVG_IDLE_TIME" aggregator="avg"
formatter="com.ilogicon.HourMinuteFormatter"/>
  <Measure name="Break Time" column="AVG_BREAK_TIME" aggregator="avg"
formatter=" com.ilogicon.HourMinuteFormatter"/>
  <Measure name="TOS" column="AVG_TOTAL_SESSIONTIME" aggregator="avg"
formatter="com.ilogicon.HourMinuteFormatter"/>
  <Measure name="Breaks" column="NO_OF_BREAKS" aggregator="avg"
formatString="#,##0"/> 
  <Measure name="Average Touch Time" column="AVG_TOUCH_TIME"
aggregator="avg" formatter="com.ilogicon.HourMinuteFormatter"/>
  <Measure name="No Of Trans" column="TRANSACTION_COUNT"
aggregator="avg"  formatString="#,##0"/> 
 </Cube>
 </Schema>
 
Regards,
Smruti


The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20071213/e29b51e3/attachment.html 


More information about the Mondrian mailing list