Skip to Content

Disable Analysis on InfoProviders in Design Studio

Hello,

When we add a datasource in Design Studio, it is also possible to add InfoProviders for analysis. We want to avoid this scenario and only want the users to access BW reports and build on them.

We are using Design Studio 1.6 based on BIP . OLAP connection with predefined user is used . Any inputs will be much appreciated :)

Regards,

Shwetha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 27, 2017 at 02:19 PM

    Hi Shwetha,

    I have had the same requirement when using a single, predefined BW User ID for an OLAP connection. The following BW Role settings achieved the desired result of allowing access to only the BEx Queries but not the underlying InfoCubes:

    Under the above approach, even though the underlying InfoProviders are referenced (in order to expose the related queries), only the specified queries are displayed to the user when selecting from the OLAP connection. The underlying InfoProviders are not displayed.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 01:55 PM

    I also recommend what Ingo says in this thread for best practices on OLAP connections: https://archive.sap.com/discussions/thread/3398468

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 01:50 PM

    Hi Shwetha,

    if your OLAP connection is CMC is at query level, then this connection will provide both query and infoprovider as source, I have done a quick test in my sanbox by creating OLAP connection to a specific query, this will display only data specific to a particular query not any other queries or info providers, this can be achieved by clicking connect to server by choosing a cube where you can search and select query on which you are going to make design studio report. However i do not recoomend this until you have a very strong requirement not to display cube data and its better you use some authorization concept at BW level instead of controlling in design studio.

    BR,

    Lakshmikanth Adharapurapu

    olap.png

    Add comment
    10|10000 characters needed characters exceeded