BusinessObjects Board

Context and Alias

building semantic layer
#1

hi

in general, we have the context and alias to resolve the loops. But can any one can tell me clearly at which time we’ll use context and alias. and wts the pros and cons of using these to resolve loops?

looksmee :uk: (BOB member since 2006-02-08)

#2

Hi,

Before post message, first search in the forum. I think that would be the best way to find the solution. If you could not find the topics related to your topic then post message.

Rule of thumb:

  • Use alias tables if your dimension tables play multiple roles, for example Address table playing the roles of Ship From/Ship To.

  • Use contexts for fact tables, one context per fact table.

Aliases and contexts are used to resolve fan/chasm traps and loops.

check this link

https://bobj-board.org/t/42567/4

Adi :us: (BOB member since 2006-03-03)