Skip to main content

SAP OLAP Connector user configuration

A user profile transport is supplied for Business Warehouse systems.

Installing the SAP transports - Windows

Authorizations are required to use the OLAP Connector. Qlik provides a role that contains the necessary authorizations.

The QTQVCBWACCESS role is to be used by OLAP, DSO/ODS, BEx, and InfoProvider connectors back-end users for doing extraction jobs on an SAP BI/BW system. This role is intended only for use in a Development environment. As part of the development process, you should create a more restricted role for the Production environment.

After the transports have been installed in the system, create one or more users as needed.

If you import the role into SAP BW versions prior to 7.00, errors or warnings regarding missing objects will be displayed, but these can be ignored.

Alternatively, go to transaction PFCG and manually create a role with the following access rights. In the SAP system, add the following authorization objects:

    Authorization objects
    Authorization object Access rights
    S_RFC

    ACTVT: 16

    RFC_NAME: RFC1, RRT0, RSAB, RSOB, SDIFRUNTIME, SYST,OCSB, SYSU, SRTT

    RFC_TYPE: FUGR

    S_TABU_LIN

    ACTVT: Restrict according to customer (* to access all)

    ORG_CRIT: Restrict according to customer (* to access all)

    ORG_FIELD1: Restrict according to customer (* to access all)

    ORG_FIELD2: Restrict according to customer (* to access all)

    ORG_FIELD3: Restrict according to customer (* to access all)

    ORG_FIELD4: Restrict according to customer (* to access all)

    ORG_FIELD5: Restrict according to customer (* to access all)

    ORG_FIELD6: Restrict according to customer (* to access all)

    ORG_FIELD7: Restrict according to customer (* to access all)

    ORG_FIELD8: Restrict according to customer (* to access all)

    S_RS_AUTH

    BIAUTH: 0BI_ALL

    S_RS_COMP

    ACTVT: 03,16, 22

    RSINFOAREA: Restrict according to customer (* to access all)

    RSINFOCUBE: Restrict according to customer (* to access all)

    RSZCOMPID: Restrict according to customer (* to access all)

    RSZCOMPTYPE: Restrict according to customer (* to access all)

    S_RS_COMP1

    ACTVT: 03, 16, 22

    RSINFOAREA: Restrict according to customer (* to access all)

    RSZCOMPID: Restrict according to customer (* to access all)

    RSZCOMPTYPE: Restrict according to customer (* to access all)

    RSZOWNER: Restrict according to customer (* to access all)

    S_RS_ERPT

    ACTVT: 03, 16, 22

    RSERPTID: Restrict according to customer (* to access all)

    RSZOWNER: Restrict according to customer (* to access all)

    S_RS_HIER

    ACTVT: 71

    RSHIENM: Restrict according to customer (* to access all)

    RSIOBJNM: Restrict according to customer (* to access all)

    RSVERSION: Restrict according to customer (* to access all)

    S_RS_ICUBE

    ACTVT: 03

    RSCUBEOBJ: DATA, DEFINITION

    RSINFOAREA: Restrict according to customer (* to access all)

    RSINFOCUBE: Restrict according to customer (* to access all)

    S_RS_MPRO

    ACTVT: 03

    RSINFOAREA: Restrict according to customer (* to access all)

    RSMPRO: Restrict according to customer (* to access all)

    RSMPROBJ: DATA, DEFINITION

Create one or more download users with the above role. Do not use the same download user as the SQL Connector.

Do the following:

  1. If download users with different access rights to cubes or queries are needed, copy the role created above and change the copy according to the requirements. Create a new user with the newly created role assigned. You can also assign the roles to existing users.
  2. Go to transaction SU01.
  3. Click Create (F8).
  4. Give the new user a name and a password.
  5. For an existing user, enter the User ID and click Change (Shift + F6).
  6. On the Logon data tab, assign new users to User Type: Service or Communications.
  7. On the Roles tab, add the role just created.

If the installation is an upgrade from a previous version and the role QTQVCBWACCESS has been updated, update all users assigned to the role.

Do the following:

  1. Go to transaction PFCG.
  2. Enter the role name QTQVCBWACCESS.
  3. Click Change Role.
  4. On the User tab, enter the name of the user(s) created above.
  5. Click User comparison.
  6. Click Complete comparison.
  7. Click Save.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!