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

Data Access Profiles Configuration

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)
Add comment
10|10000 characters needed 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)

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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???

    Add comment
    10|10000 characters needed characters exceeded