Hello Friends,
I am new to Mondrian, I was trying to use aggregate table , I have created a base table,aggregate table and the schema as specified in the document, but mondiran is not looking into aggregate .I am stuck with this please help.

My Mondrian.proprties file as follows
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.native.topcount.enable=false
mondrian.native.filter.enable=false
mondrian.trace.level=1
mondrian.rolap.aggregates.rules=/DefaultRules.xml
mondrian.rolap.aggregates.generateSql=true

My schema file as follows....

<?xml version="1.0" encoding="UTF-8"?>
<Schema name="Report">
<Cube name="Report">
<Table name="FactTable">
<AggName name="agg_Fault_FactTable">
<AggFactCount column="fact_count"/>
<AggMeasure name="[Measures].{Down Time Sum]" column="down_time"/>
<AggLevel name="[FactTable].[Product]" column="productname "/>
<AggLevel name="[FactTable].[Customerclass]" column="customerclass"/>
<AggLevel name="[GRANULARITY].[Year]" column="year"/>
<AggLevel name="[GRANULARITY].[Month]" column="month"/>
</AggName>
</Table>
<Dimension name="WEEK" foreignKey="granid">
<Hierarchy name="WEEK" hasAll="true" allMemberName="All year" primaryKey="ID">
<Table name="GRANULARITY"/>
<Level name="WEEK" table="GRANULARITY" column="WEEK" uniqueMembers="false"/>
<Level name="DATE" table="GRANULARITY" column="DATE" uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<Measure name="count_docket_id" column="docket_id" aggregator="count" datatype="String" formatString="Standard"/>
<Measure name="count_circuit_id" column="circuit_id" aggregator="count" datatype="String" formatString="Standard"/>
<Measure name="sum_down_time" column="down_time" aggregator="sum" datatype="String" formatString="Standard"/>
<CalculatedMember name="mttr" dimension="Measures" formula="[Measures].[sum_down_time]/[Measures].[count_docket_id]">
<CalculatedMemberProperty name="FORMAT_STRING" value="###"/>
</CalculatedMember>
</Cube>
</Schema>

My aggregate Table schema...
agg_Fault_FactTable
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| productname | varchar(50) | NO | MUL | | |
| customerclass | varchar(10) | NO | MUL | | |
| location | varchar(20) | NO | MUL | | |
| segmentid | varchar(20) | NO | | | |
| month | varchar(10) | NO | | | |
| quarter | varchar(10) | NO | | | |
| halfyear | varchar(10) | NO | | | |
| year | varchar(10) | NO | | | |
| down_time | int(20) | NO | | | |
| fault_count | int(20) | NO | | | |
| total_ckts | int(20) | NO | | | |
| fact_count | int(20) | NO | | | |
+---------------+-------------+------+-----+---------+-------+

My Fact TAble schema....

FactTable;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| groupid | int(10) | YES | | NULL | |
| granid | int(10) | YES | | NULL | |
| docket_id | varchar(50) | YES | | NULL | |
| circuit_id | varchar(50) | YES | | NULL | |
| severity | varchar(50) | YES | | NULL | |
| criticalckts | int(3) | YES | | NULL | |
| breachedckts | int(3) | YES | | NULL | |
| down_time | int(30) | YES | | NULL | |
| reason | varchar(50) | YES | | NULL | |
| segmentid | varchar(30) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+

Thanks In Advance,
Sarath.