Hi Sachin Aggarwal 

When a lookup table is stored as snapshot, all columns in that table will be 
taken as derived dimension by default during cube design.

Compare to normal dimension, derived dimension does not participate in cube 
calculation directly. Instead, it is represented by its FK (Foreign Key) in 
cube. That is why using derived dimensions can greatly reduce cube complexity. 
During query, derived dimensions have to be converted to their FKs first, 
causing a small panalty to performance.

Aron Tao

On [DATE], "[NAME]" <[ADDRESS]> wrote:

    Hi Team,
    while creating cube what are recommendations across join column between
    fact and dimension.
    should we mark it as derived or normal while selecting it from dimension
    what factors play a role in making this decision.
    Thanks & Regards
    Sachin Aggarwal

Reply via email to