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 shouldnt see it, so the alternate solution from SAP is to remove the data!! This doesnt 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.