Multiprovider with authorization relevant infoobjects

[Former Member]

Hi all,

Here is our situation. We have new cubes which contain authorization relevant infoobjects to secure the data. We would like add the cubes to existing multiproviders, but the existing infocubes do not contain the authorization relevant infoobject. The objective would be to have our existing queries not be impacted by the new cubes, but new queries containing the new key figures should work for those who have the authorization relevant objects in the security roles.

If we use an authorization variable at the filter level of the query, the existing infoproviders get filtered out because they do not have that infoobject.

If we try to use the authorization variable in restricted key figures, this only works if all of the key figures in teh query contain such a restriction - so this can not inlcuded the key figures from the existing cubes.

We would like to avoid adding the infoobject to the existing cubes because of the impact to update rules, transformations and other multiproviders. Also, this would require changes to all of our security roles.

P.S. We are on BW 7.01.05 and we are using the 7.x authorization logic.

Thanks ahead of time.

MItchell

[Former Member]

We determine that we will simply add the authorization object to all infoproviders in the multiprovider. Unfortunately, this will mean adding that authorization to every reporting relevant security role in our system.

If there is any better answer, I am still willing to hear it.

[Former Member]

Did you ever figure this out?