Thursday, April 9, 2015

Cub VS DMR


Sl No.
Cube
DMR
1
Cognos 7 technology on words
Cognos 8 technology on words
2
Performance high
Performance Low
3
offline data
online - life data
4
Attributes nested within dimensional values
not possible with cubes
5
Cube does require a separate model/IQD
DMR does not require a separate model/IQD
6
Calculated categories creation - YTD, MTD
No Calculated categories creation
7
supported multiple environments/formats
Not supported multiple environments/formats
8
Not supported HUGE volume data
Supports HUGE volume data sets
9
Security in custom view and access manager
Security in Cognos server or FM
10
Custom view
No custom view
11
MDX
SQL
12
Support up to 2 GB
No Size limit
13
Manually maintain data in categories for data correction
Data correction only possible in database level not model / package level

No comments:

Post a Comment