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.