Using Materialized Views with Cognos BI

[mahi_lvs]

Hi

How can we use Materialized Views in DMR model FM in cognos 10.2 version.

Thanks in adavance,
Mahesh K

[blom0344]

Hi

How can we use Materialized Views in DMR model FM in cognos 10.2 version.

Thanks in adavance,
Mahesh K

Unlike BO there is no aggregate_aware methodology in FM.  Cognos relies on the database optimizer to switch to the aggregate AFAIK

[MFGF]

Aggregate awareness exists in Dynamic Cubes in 10.2, but not in FM modelled metadata. You will need to use Cube Designer to do create your aggregate-aware cubes.

Regards,

MF.

[cognostechie]

Aggregate awareness also exists in Transformer cubes. It's called 'External Rollup' cube. You can provide aggregates from the data source which can be a table in the DB or SQL.

[MMcBride]

How can we use Materialized Views in DMR model FM in cognos 10.2 version.

Technically speaking Materialized views are just regular tables to cognos, if you want to use them in DMR you just need to build your DMR model from them.

If you want to be able to swap from your normal table to a materialized view aggregate awareness comes into play but if you are just using a Materialized view to speed up Query times - just use it like a normal table.