Authorization variable different between cube and multiprovider
We have an authorization variable to limit the Sales Orgs the users see. We have Sales Orgs 3000, 4000, 5000. We only want the users to see 3000.
We have a query against a cube for which this authorization works fine. We then created a multiprovider off this cube and a query. The query for the multiprovider uses the same authorization variable and infoobject as the query against the cube, but it does not limit the sales orgs. The users are able to see all sales orgs when using the query against the multiprovider.
How do we get the auth variable to work the same way between the cube and multiprovider?
If you are on version 3.x , did you switch on the multiprovider for the authorization object in transaction RSSM?