We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-bw] Limit Number of NavAttrs

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Question from SimonCrowder on Dec 23 at 11:08 AM
I am aware of the performance impact of using NavAtts when running a query (additional joins etc), but someone mentioned to me that Best Practice is to restrict the number of Navigational Attributes within an Inforcube (or Query) to 4.

Now I can't see any documentation which states this, so I can't confirm this is the case, but has anyone else seen/heard this as a recommendation??? The guy who mentioned this to me is adamant but can't remember where he was told this.

We do use NavAtts within Queries so the users always have reports against the LATEST Master Data, and can actually run queries comparing Data against Latest Master Data and the Master Data as the data is loaded (stored as Characteristics).

I would easily maybe have 5-10 available NavAtts within a InfoCube/Query (e.g. 5 for Material, 5 for Customer) but probably not all used by users at the same time, but would be Free Characteristics.

Cheers
Simon
 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2013 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
SimonCrowder  

achievements
 
View this online
Ask a new question
 
In the Spotlight
Have a technical question? Need to find IT solutions? Ask your peers in the Toolbox for IT community.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language