Skip to Content
0
Jun 18, 2018 at 08:21 AM

Universe Creation using Core

78 Views

Dear Experts,

I have a requirement wherein data model is highly normalised wherein all subject area information e.g.dealer , article or sales information is stored in different data mart e.g Dealer phone address is stored in one table, email address in another table. And for reporting we need to report more of a cross functional requirement for semantic layer using multiple subject areas and also reports needed by the business is more of operational in nature, and predominantly webi is used.

As every subject area has approx more than 75 tables and we need most of the tables in almost all the universe , to cater to the requirement in Universe (Semantic Layer) , we are considering the option of using Core and Link universe and to create reusability.

1. Not sure, if Core and Linked universe is the best practice with the given architecture

2. Please guide if there is any alternative approach to Universe building?

3. Is Core and Linked universe , a best practice if data model is highly normalised and for operational reporting ?

4. Do we have any limitations in terms of security and learning best practices.

Please recommend and guide with expert inputs.

Thanks in Advance