Skip to Content
author's profile photo Former Member
Former Member

Analysis authorization Union problem

Hello Experts,

We have very bad problem in our project and I hope that you can advise me how can be solved.

We want User "A" to be authorized to see certain values for Query 1 and other values in Query 2 for GL Account characteristics. We made two analysis authorizations with the restrictions for the queries, but the system makes an union between them and the User A has access to all of the combinations.

Can you give me some hints how to solve this problem.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 10:21 PM

    Hi Marin,

    Have you tried, creating two different roles with two different queries and respective values. it may solve your problem.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vijay,

      Thanks for replay,

      I tried with two roles, but no success.

      I think that in the new concept, the union is created even there are different roles.

      The only way when there was a success in splitting the union was when the one query I created over one multi provider and the second over another. Then in both analysis objects i restrict the multi providers that they are relevant to. But I am still wondering if there any possibility to split the union when the queries are made over one multi provider.

      I am not sure if the characteristics in 0bi_all can help me for restriction. For example i saw that there is a special object for restricting a queries, but it won't work when i tried.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.