hello,
I need to restrict a query to run for 15 Sales Orgs. Dependeing on the user profile the report should display the data.
If I have the restriction done on at the characteristic level, when a user who has no authorization to any of these Sales Org executes this report, It gives ' No Authorization error'. So I am adding these restrictions at the Key Figure level.
Is it possible to create a Variable / Fixed value field with these 15 Sales org's embedded in it ? If I can have one like this , I can use just this one field while doing a restriction instead of pulling in 15 values.
The reason I want this is , I will be using this for over 40 queries.
Any Idea's appreciated
Thanks
Raj