What is the difference between Analysis Studio and PowerPlay Studio?

Analysis Studio is the component of Cognos 8 that you can use for multidimensional analysis.

PowerPlay Studio lets you create and view reports that are based on multidimensional data sources.

PowerPlay Studio is a series 7 multi -dimensional tool that was re-instated in IBM Cognos8.4. PowerPlay studio is not available with Cognos 8 through Cognos8.3

What is the difference between DMR and PowerCubes?

DMR stands for Dimensionally Modeled Relational Data


DMR’ s are hierarchical metadata trees. They represent relational tables and columns as dimensions and hierarchies.

Reports that run against DMR packages execute against the relational tables at run time.

Powercubes also model relational data as dimensions and hierarchies. Powercubes are pre-built with summarized data.
So reports executed against Powercubes fetch data from Cube and not the database.

Reports generated against Powercubes are only as live as they were last generated.


DMR’ s and Powercubes both allow drill up and drill down functionality.