[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