Cube vs DMR

[Vick]

Hello,
        Does anybody know what are the advantages of DMR over creating a  Cube.

Thanks,
Vick.

[blom0344]

No need to build a cube beforehand. A cube contents will usually be outdated to  a certain degree (depending on rebuild frequency) There is also a lot that does not need to be configured (like cube-swapping)
However, we have found that you really NEED to work with 8.4. Older versions have many drawbacks.
Performance may be an issue as well..

Really complex models are not DMR's forte, but making changes is much less extensive than reworking a cube model

[BI-forme]

Hi,

One big issue:

You don't get all (Framework DMR) attributes in your Cube.
It might be a big issue like we got  :-[

BI-fomre

[blom0344]

Hi,

One big issue:

You don't get all (Framework DMR) attributes in your Cube.
It might be a big issue like we got  :-[

BI-fomre

Can you explain what you mean with :

You don't get all (Framework DMR) attributes in your Cube.

[BI-forme]

Hi Blom0344,

When building a Cube with transfomer, you only get the Businesskey / MemberCaption / MemberDescription from a level defined at DMR FrameWork, but not the atrributes defined.

Example a customer dimension:

customer_ID (businesskey)
customer_number (membercaption)
customer_name (memberdescription)
customer_adres (norole)
customer_town (norole)
customer_phone (norole)
customer_zipcode (norole)
ect. ect. (norole)

When building a transfomer model, you default get only the businesskey, membercaption and memberdescription and not the other parts from the framework package.
It can be a problem if you need the attributes in your model.

(microsoft cubes will give all the attributes defined in the database.......)