Hello,
Does anybody know what are the advantages of DMR over creating a Cube.
Thanks,
Vick.
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
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
Quote from: BI-forme on 20 Feb 2009 01:38:06 PM
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 :
Quote
You don't get all (Framework DMR) attributes in your Cube.
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.......)