Dear All,
I have 2 queries on the same Cube and I am using Profit center in the queries. I have made Profit center auth relevant.
For one query I have created an Authorization variable and restricted in the query and it works well.
I dont want profit center authorization for the other query. I have not used the profit center at all in the query though its in the cube.
But I still get an error saying 'No Authorization'.
How do I create authorizations so that the Profit center has authorizations for one query and It wouldnt consider profit center authorization for the other query.
Any help would be highly appreciated and rewarded.
Thanks,
KK