Skip to Content
Former Member
Sep 19, 2006 at 02:51 PM

Analysis Authorizations - What exactly does 0TCAIPROV do?



I am implementing security for BI 7.0 and I got these questions. Based on what I understood about the new concept I am framing the questions below.

1. Is specifying values (Infoprovider names) in 0TCAIPROV equivalent to putting the 'check for info providers' in the old security concept?

2. What is the difference between 0TCAIPROV and 0INFOPROV?

When I executed a query I gave the infoprovider name that the query is accessing in the auths, in 0TCAIPROV field and gave the same name in 0INFOPROV. It failed. So, I ran a trace and found that the system is checking for aggreagated auths i.e, it is looking for : to be filled in 0INFOPROV. I am a little bit confused here. Why exactly do I need to include 0INFOPROV in the authorizations in the first place when I already have 0TCAIPROV included. And why did it fail when I entered the name of infoprovider in 0INFOPROV, and why is it looking for a "non-inforprovider name" (which is ':' ), and why is it asking for : to be filled in.

Any help on this is greatly appreciated.