Multiple Schemas in a Single Universe..

building semantic layer
1

Hello Folks,

I need some advise on whether having multiple schemas in a single universe would be a good idea.
I have a normalized structure in my universe, and we have created a standalone star schema for our metric calculation.
Please dont ask me why we did that :slight_smile:

basically these two schemas are indepedent of each other, our drill down reports come from the star schema and then the detail report will be fetched from the normalized one.
Would it be okay to have them in the same universe rather than going for a sperate universe for the star schema.

Please let me know your thoughts.

Thanks for your help.
Thanks,

reachmenow (BOB member since 2009-10-26)

2

Separate.

There is no advantage to having them together, and if you ever want users to be able to write adhoc queries without learning all sorts of rules about what can be used with what, separate is the way to go. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Another seperate here too :).

Why add potential problems / queries from users, as to why their data is “wrong”…;).

Mak 1 :uk: (BOB member since 2005-01-06)

4

Thanks a lot Dave and Mak 1,

also in this case both universe will be independent, which means i dont need to define universe linking, please correct me if my understanding is wrong. Users will need to select universe while writing adhoc queries depending on what results they want to see, this can be a training aspect.

Please let me know your thoughts.

Regards,

reachmenow (BOB member since 2009-10-26)

5

Nope, no universe linking required. As stated earlier it makes sense to keep these seperate…:).

Mak 1 :uk: (BOB member since 2005-01-06)

6

Thanks Mak1.

Regards,

reachmenow (BOB member since 2009-10-26)