SAP Knowledge Base Article - Public

2200026 - Able to view BEx Queries in Lumira that does not have the option "Allow External Access to this query" checked

Symptom

  • All queries are visible.
  • All the BEx Queries are listed in Lumira.
  • When connecting to an SAP BW System in Lumira, it display all the BEx Queries regardless the option "Allow External Access" is checked or not.
  • Why does the SAP BW BEx Queries that does not have the option "Allow External Access - By OLE DB for OLAP" checked, are available to select as a data source in Lumira, when there are not visible in other application like Crystal Reports for Enterprise or Webi.

Environment

  • SAP Lumira 1.27 and above

Reproducing the Issue

  1. In BEx Query Designer, create a BEx Query off an SAP BW Cube.
  2. In the BEx Query Properties, under the tab "Extended" ensure the following option is uncheck:
    "Allow External Access to this Query - By OLE DB for OLAP"
        
     BEx Query - Allow External Access - 02.png  
      
  3. Save the BEx Query.
  4. In Lumira, when creating a new document using the connection "Download from SAP BW"
  5. Notice it displays all the BEx Queries regardless the option: "Allow External Access to this Query" is checked or not for the BEx Queries.
      
    ( In this example, the BEx Query: QUERY_NO_EXTERNAL_ACCESS, have the option "Allow External Access" uncheck, 
      and it still displays as an available BEx Query to select in Lumira )
      
    SAP Lumira - External Access.png

Cause

  • SAP Lumira does not connect to SAP BW using an OLAP connection, and the BEx Query option: "Allow External Access to this Query by OLE DB for OLAP" is an option to allow external application to access the BEx Query using an OLAP connection. Since Lumira does not use an OLAP connection, it can display all the BEx Queries.
       
  • Note: In SAP Lumira 1.27 and above, you can connect to an SAP BW using one of the following connection:
    - Local connection; or
    - A connection stored on the SAP BI Platform.
       
    When accessing a local connection, SAP Lumira connects to the SAP BW System directly. Since it is not using an OLAP connection to connect to SAP BW, it can display all the BEx Queries that are listed under the roles the user that login has authorization.
       
    When using the connection stored on the SAP BI Platform, it is actually defined on the SAP BI Server as an OLAP connection, but Lumira does not use that connection directly, it actually reads the SAP BW information from the OLAP connection, and then connect directly to the SAP BW System. Therefore, Lumira connect to SAP BW exactly the same way as when using a local connection. Since it is does not use the OLAP connection to connect to the SAP BW System, Lumira can list all the BEx Queries, including the BEx Queries that does not have the  BEx Query option checked "Allow External Access -  By OLE DB for OLAP".
     
    As for Crystal Reports for Enterprise, Webi, Dashboard, it does not list the BEx Queries that does not have the BEx Query option to allow external access by OLE DB for OLAP, because it is using an OLAP connection to connect to the SAP BW System and access the BEx Queries.

Keywords

SAP Lumira, External access, query visible , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0