Unverse design input?

building semantic layer
1

XI31

I have a requirement to build 36 universe, fair enough, however, rather than making 36 independant universes, there are numerous table/objects overlap, meaning table 123 is used in 30 of the 36 universe and I don’t think I should have to build objects for this table “30” times.

Thats being said, I’d like to just confirm my options;

  1. Linked Universe, although appears not reccommended(?)
  2. “copy/paste” throughout each universe.
  3. File name (Save as) v univ name (Parameters)

Not sure if #3 is even valid?

Thoughts are appreciated!

MichaelB :us: (BOB member since 2008-11-19)

2

Option 3 is also good. But make sure you rename the file name.unv and the definition name by going to Parameters. Then you can export it.

paryaniafroze :us: (BOB member since 2006-09-29)

3

Thanks!

I’ve heard/experienced linking universe problems (performance) previously, not sure if there have been any enhancements with XI31 or not…

MichaelB :us: (BOB member since 2008-11-19)

4

Problem of Linking universe, you have to re-create the contexts again. I don’t know if you have complex joins/contexts or not.

paryaniafroze :us: (BOB member since 2006-09-29)

5

Thanks! couple context, joins all key related 1:N, no many too many or outjoins

MichaelB :us: (BOB member since 2008-11-19)