Need help with aggregator attribute in OLAP schema

[suppachartt]

Hi everyone,

I have a view table that has already been aggregated (AGG_CUBEVIEW).
Is there is a way that I can tread this table as a fact table and bypassing that aggregator attribute in <Measure>?

Regards,
Suppachart

Code:

<Schema name="ABC">  <Cube name="Cubes">     <Table name="AGG_CUBEVIEW" />     ...     ...     ...     <Measure name="Agg Sum" column="AGG_SUM" aggregator="sum" />  </Cube></Schema>

[swood]

Hi Suppachart,

 

Look into using aggregate "tables", which in your case is your materialized views.

 

In your schema, there are aggregate sub elements under the main fact table of a cube that can be set to define a series of aggregate tables, their attributes etc.

 

Sherman

Jaspersoft

[suppachartt]

But in my case the Aggregate table is fact table.

[swood]

The OLAP engine will not care that it is a view in Oracle.

 

If you can "select * from view", you can use it as the "table" in this case.

 

Sherman

Jaspersoft