Navigational Attribute

[Former Member]

Hi All,

Why Navigational Attribute Decrease the Query Performance

Thanks in ADV

[Former Member · Accepted solution]

Hi,

1.When you create a Naviagational attribute apart from SID Table one more Table is created i.e

X if the attribute is time independant and

Y if the attribute is time dependant .

Each time whenever you use the navigational attribute in Query's BW has to scan both SID Table as well as the X and Y Table which leads to performance degradation.

2. The navigational attributes are stored in the Aggregate and Realignment must happen when the master data changes or for newly loaded master dta. So, Its takes more time for the Attribute Change Run .

[sachin_kulshrestha2]

Hi,

Navigational attribute creates additional table

X and Y ie. time independent and time dependent.

When the query is executed database has to fetch the values from these additional table means it has to perform joins between master table and either one of the table. (what joins means is search for the related values in x or y for the current SID) this is the reason for performance degradation.

It is essential that you create navigaational attribute only when required.

You feel the pinch more when the data volume is very high.

Hope this helps!!!

[former_member184494]

S S,

Navigational attributes mean there are joins that need to be created for the query, especially with a large number of records , the time taken for processing the joins is greater and hence the DB time for the quuery willl increase.

Also when some of the master data changes and if you are using any calculation routines in the loading routines etc , the time taken for the same also changes.

Hope this helps...

Arun

Assign points if useful

[former_member188325]

Hi,

have a look at this

http://help.sap.com/saphelp_sem40bw/helpdata/en/2e/caceae8dd08e48a63c2da60c8ffa5e/content.htm

Thanks