[Mondrian] Reg .Aggregate Tables

Julian Hyde jhyde at pentaho.org
Thu Dec 13 13:24:49 EST 2007


Turn on tracing: mondrian.trace.level=1 in mondrian.properties.
 
Julian
 


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Smruti Naik
Sent: Wednesday, December 12, 2007 10:38 PM
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

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


More information about the Mondrian mailing list