Navigationnal attributes in Cube as datasource

[Former Member]

Hi,

I have a question in performance.

I saw that in BI 7 dataflow between BW infocube's that in the datasource i can create a mapping based on navigationnal attributes

So i would like to kown what is the best if i want to add a navigationnal attributes in my cube

For the moment i have a code in final routine

Thanks

CYril

[Former Member]

Hi,

If the usage frequency of Navigational attributes is high in reports via drill down or in case used them in variable selection, or if u have any charactaristic value restriction (filters) in reports on Nav attributes then better to use them as part of the Cube. Otherwise u can simply use them as nav attribute only by checking the same in Infocube.

regarding the mapping in transformation if the data volumes are high and if the load on Master data table is high by doing a master data lookup then best way is to write a simple routine and pouplate the values in a internal table to reduce the master data table read during the load.

Regards

[Former Member]

Hi CYril,

It is always good to read the master data than to write a routine if performance is primary concern.

But the best way to add a navigational attribute is to just activate it as a navigational attribute in Navigational attribute tab without adding the actual characteristic to the Cube.

Please let me know if this helps.

Regards,

Pankaj

[former_member184494]

Are you referring to the "Read Master Data" option ? if you have to choose between "Read Master Data " and routine - I would recommend the latter - because when you use the read... option - whenever you change anything to the characteristic - the transformation will get deactivated....