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.