universe design question

building semantic layer
1

Hi,
I have attached universe structure diagram picture. Please advise me how to create context or alias? I have objects based on all tables and below are my requirements: (Please check diagram for naming convention)
(1) When I include objects from A, B and C then BO should include J1 and J2 joins.
(2) When I include objects from A, B, D and C then BO should include J1, J3 and J2 joins.
(3) When I include objects from A, B, C, D and E then BO should include J1, J2, J3 and J4 joins.
(4) When I include objects from A, B, C and E then BO should include J1, J2 and J5 joins.
Thanks,
data model.JPG

wack_jack (BOB member since 2005-12-28)

2

Based on your description J5 should be a shortcut, and no contexts are required.

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

3

Thanks Dave,
I did same thing which you suggested but when I open this post I was curious to know other option(s) to achieve these requirement.
Again Thanks for your time.

wack_jack (BOB member since 2005-12-28)

4

Depends on what E and D are - aliasing E could be an option, but more likely Dave’s already given the best solution.