Skip to Content
0
Former Member
May 27, 2008 at 07:08 PM

Qn on navigational attributes

37 Views

Hello

I have a scenario where I need to include a new field ZTAGID as a navigational attribute of 0PROFIT_CTR.

However, 0PROFIT_CTR itself is a navigational attribute of 0COSTCENTER in my cube.

(ZTAGID is a field in the same table (CEPC), which 0PROFIT_CTR is based on).

I know I can probably create ZTAGID as a transitive attribute, but we want to avoid it for performance reasons.

Is there an alternative to transitive attributes? Can I append the 0COSTCENTER datasource with the ZTAGID field and populate it from the CEPC table? In BW, I can then make ZTAGID a navigational attribute of 0COSTCENTER instead of 0PROFIT_CTR.

Is this a viable solution?

Thank you

Alex.