Skip to Content
avatar image
Former Member

BI Folder Roles

hi to all,

I would require some input from the BI security experts the issue i am facing with the BI. I have created the few folder roles and assigned necessary authorization like s_user_agr and provided the folder in role check field. Now the issue is the BI team is not able to view the folder role. they have to save some workbooks in the folder role.

I am able to create the folder role and i can view them through Bex Analyzer one at a time. i am not able view all the folders through the Bex Analyzer even though they have been assigned. i have tried different means to solve this issue.

Can anyone please advice where i am missing in analyzing the defect.

your inputs are highly appreciated

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    May 26, 2010 at 10:47 AM

    Hi Madhu

    Seems all authorizations are perfectly in place. Can you request your users to click on "Open workbooks" in place of "Open Queriy..." in BEX and advise if the users can view the folders in the roles tab and corresponding workbooks published in the role.

    Thanks.

    Anjan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Sid, your solution was very helpful. Earlier solution provided by other community members was also helpful, however the current solution seems to be a permanent one.

      Regards

      Madhu

  • avatar image
    Former Member
    May 22, 2010 at 08:07 PM

    Hi,

    In BI Security, you need to have an empty role ( menu role ) with no TCODES or no authorizations in it . It will just have queries or workbooks assigned to it. This role name needs to be provided in another role through authorization object S_USER_AGR .

    Both these roles have to be assigned to the user to make him view the folder in BeX and assign queries to it.

    You can also assign queries to the menu role using " Add Report " button in the Menu . Select BW report and give the UID of the workbook/query that needs to be assigned. You can see the queries assigned in the menu then.

    Regards,

    Manisha

    Add comment
    10|10000 characters needed characters exceeded

  • May 23, 2010 at 01:14 PM

    Hi Madhu,

    In addition to above I would like to add that you also need to provide access to S_RS_FOLD object. This will will enble Role folder in Bex Analyzer

    Cheers,

    Arpan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 24, 2010 at 09:59 AM

    Hi Madhu,

    If the roles do not have any Queries or Web Reports saved in them, they will not be visible.

    First the Developers need to save/assign/publish Queries into the folder roles & then they appear in the Roles button

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2010 at 12:36 PM

    I am still not able to view all the folder roles, eventhough the queries are published

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Please check the actvities you have provided in S_USER_AGR Auth Object and also check if queries are correctly published by seeing if the menu buttone is " green" in pfcg for all these roles.

      Regards,

      Manisha