Scribd Logo
Upload

Welcome to Scribd!

  • 255 views

    Reporting Authorizations in SAP BW

    Uploaded by

    satyamkala
    This document provides steps for creating authorizations in SAP BW, including: 1. Creating an authorization object using transaction RSECADMIN and assigning characteristics like activity type and validity. 2. Creating roles using transaction PFCG and assigning authorizations and transactions. 3. Assigning users to roles and testing authorizations by executing queries as different users.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Reporting Authorizations in SAP BW

    Uploaded by

    satyamkala
    255 views13 pages
    This document provides steps for creating authorizations in SAP BW, including: 1. Creating an authorization object using transaction RSECADMIN and assigning characteristics like activity type and validity. 2. Creating roles using transaction PFCG and assigning authorizations and transactions. 3. Assigning users to roles and testing authorizations by executing queries as different users.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides steps for creating authorizations in SAP BW, including: 1. Creating an authorization object using transaction RSECADMIN and assigning characteristics like activity type and validity. 2. Creating roles using transaction PFCG and assigning authorizations and transactions. 3. Assigning users to roles and testing authorizations by executing queries as different users.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    255 views13 pages

    Reporting Authorizations in SAP BW

    Uploaded by

    satyamkala
    This document provides steps for creating authorizations in SAP BW, including: 1. Creating an authorization object using transaction RSECADMIN and assigning characteristics like activity type and validity. 2. Creating roles using transaction PFCG and assigning authorizations and transactions. 3. Assigning users to roles and testing authorizations by executing queries as different users.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 13

    Reporting Authorizations in SAP BW

    23 Likes 34,396 Views 14 Comments

    Creating Authorization in BW System

    Steps for creating authorization

    RSD1-To maintain info object authorization relevant.

    PFCG – To maintain roles

    RSECADMIN – To maintain analysis authorization and role assignment to user

    1. Make a variable authorization relevant.

    2. Create roles.

    3. Create BI Analysis Authorization.

    1. Make a variable authorization relevant

    Go to RSA1 select info object target and go to business Explorer and check the box
    for authorization relevant 

    2. Create BI Analysis Authorization

    Use transaction RSECADMIN
    Select AUTHORIZATION Tab

    Select MAINTENANCE

      

    Give the name for the authorization and click create


    Give the short text

    Below characteristics are mandatory while creating authorization object.

    1. 0TCAACTVT: This characteristic handles the general activity like create, change, display etc.

    2. 0TCAVALID: This characteristic handles the authorization for Info Provider by default it gives
    access to all the Info Providers i.e. full access. We can restrict authorizations for particular Info
    Providers using this characteristic.

    3. 0TCAVALID:  This characteristic handles the validity of an authorization. Always valid (*) is
    set as the default for validity. You can restrict this validity. You can also specify a single value or
    an interval.
    Insert new row and add the dimension and give a value

    A. For giving values double click the intervals cell

      

    Add a row and give the value depending upon the requirement


    Save the authorization

    3. Creating the role

    Select user tab

    Select Role maintenance
    Give the role name and select either single role or composite role (in my case I selected
    single role)

    Select menu tab


    Select transaction
    Give the transaction to be allowed

    Ex- RSRT – Query monitor

    Select Authorization Tab
    Add the authorization created to S_RS_AUTH

    Generate then Save

    Select the user tab

    Add the users which has the role

    Then do user comparison


    Creating Authorization variable

    Open query designer

    Creating authorizing variable


    In Query Designer Put the authorization variable under filter panel.

    Checking the authorization

    Go to the analysis tab -> select execute as -> give the user (EX – RETUSER1) -> select with
    log

    Select start transaction -> select the authorization query -> execute
    Then run as the user to which role was assign then run the query

    Query display as HTML

    Now check the below out only for the RUKSHAYA

    You might also like