Skip to Content

Data Access Profiles Configuration

Feb 14, 2017 at 10:34 AM


avatar image
Former Member

Hi everyone,

I have asked a question here and it seems that my problem is related with the DAP configuration.

In the environment we have 3 cubes (Forecast, Rate and Validation) and 3 queries for each cube.

I am going to show what I am doing in order to configure them.

I go to RSECADMIN and Maintain Authorizations. I am going to create 6 analysis authorization (3 for the cubes and 3 for the queries).

For the Forecast Cube I have the following:

ZDATATYPE and ZENTITY are the relevant dimensions (I have already checked them as relevant dimensions).

I choose the InfoCube:

And I add the values 02 and 03 in 0TCAACTVT

And also select all the hierarchies for all the dimensions:

For the Forecast query, I have done the same:

The only difference is that I choose the Query instead of the InfoCube:

I repeat these steps for the other 4 authorization analysis and then I go to RSECENVI to add them to the environment:

If I go to the BPC Web I can see them:

Then I assign my user to a DAP:

and if I go to su01 and check the authorization objects for the user DELTEST2 I have the following:

Which is obviously wrong, so I change it manually.

I continue in the comments because I can't post more images.

capture01.png (81.0 kB)
capture02.png (29.4 kB)
capture03.png (29.7 kB)
capture04.png (36.9 kB)
capture05.png (81.2 kB)
capture06.png (34.8 kB)
capture09.png (67.9 kB)
capture07.png (42.9 kB)
capture08.png (20.7 kB)
capture14.png (24.6 kB)
10 |10000 characters needed characters left characters exceeded
Former Member

I continue here:

I change with these new values:

I also have this configuration in the BW analysis Authorizations:

But when I log into EPM I get this error:

NOTE: If I change the BI Analysis Authorizations to 0BI_ALL I can log but I want to have some restrictions.

NOTE2: In RSECPROT I get the following Error Log:

NOTE3: I think that the problem is the configuration of the Analysis Authorizations because I have added a new Authorization Analysis just with the basics (no dimensions):

And I CAN log into EPM, however I CANNOT see the members of the dimensions ENTITY and DATATYPE (that are the relevant dimensions):

I would appreciate any help, this is driving me crazy.

Thanks in advance.

capture15.png (27.9 kB)
capture3-2.png (62.7 kB)
capture4.png (8.7 kB)
capture11.png (114.7 kB)
capture13.png (86.0 kB)
capture14.png (55.1 kB)
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 14, 2017 at 11:44 AM


For 0TCAACTVT authorization add 02(change) as setting instead of 03(display), also for 0TCAIPROV authorization are you adding the infoprovider???

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Priyanka,

I have both added (02 and 03) to 0TAACTVT and I get the same error. If I also add 02 I get the error oo.

For 0TCAIPROV I have all InfoProviders added (*).

I have made an edit in the first post.

Former Member
Former Member

After creating the analysis authorisations objects are you assigning them to the individual users? using RSECADMIN?. I couldnt see that screenshot so asked...

Former Member
Former Member

I assign them using the BI Analysis authorization object (12th image) and automatically they appear in RSECADMIN, as you can see:

capture15.png (92.7 kB)