on 04-11-2014 11:41 AM
Hi,
We have a large universe which has some common dimensions, product, calendar, customer etc.
If we create some new universes with different fact tables/functional areas, what is the best way of incorporating these common dimensions
in the new universe without having to manually create (unx universes)
Thanks
Philip,
I would strong recommend creating VIEWS within the IDT and then using assigning security related to the different business views from the MASTER structure.
Regards,
Ajay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Philip,
Structural views are created in Data Foundation layer. You have MASTER view that contains ALL the tables and then you can created different VIEWS based on your business needs and tables required. Then you create Object & Class structure based on the different Data Foundation Views.
Regards,
Ajay
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.