BI 7.0 Analysis Authorization by specific query
We have been setting up Analysis Authorization in BI 7.0 and have most of it working correctly.
We have a particular requirement where we want a restriction by region, but only for a specific query. So this "restriction/authorization" should only occur for this 1 query. All other queries on this multiprovider should not bother with any "restriction".
We put 0TCTQUERY = to our query name, but this didn't work.
Has anyone else gotten analysis authorization to work at a query level like this?