Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Extremely poor performance in BI 7.0 due to analysis authorizations

We have experiencing big performance problems with analysis authorizations, though with only one infoprovider. Queries with this provider take 85 minutes to merge the authorizations and load the buffer. We have gone back and forth with SAP over this, and have applied every known note/ patch to the system. Still with this provider, performance is very poor. SAP tells us we have too many (is 18 too many??) analysis authorizations. We should remove some. If we did this, then we would be exposing data to people that shouldn’t see it, so the alternate solution from SAP is to remove the data!! This doesn’t work very well for me since there are already many queries developed for the infoprovider under the old security model. And they work fine. Has anyone else had problems with performance? What can we do to fix these problems? Any advice or suggestions is appreciated.

Regards,

Steve McMahan

Former Member
Not what you were looking for? View more on this topic or Ask a question