SAP Knowledge Base Article - Public

2182617 - SAP BW Connection to BEx Query and InfoCube missing in Lumira

Symptom

  • No option to connect to BEx Query in Lumira.
  • Where is the connection for SAP BW BEx Query in Lumira?
  • How to connect to a BEx Query or InfoCube in Lumira?
  • Used to be able to connect to a BEx Query in previous version of Lumira, but the connection is no longer available after applying an update.

Environment

  • SAP Lumira Desktop 1.27 and higher

Reproducing the Issue

  1. In SAP Lumira, create a new document by selecting "New" under the menu "File"
  2. In the "Add new dataset" window, there is no option to connect to an SAP BW BEx Query.
              
      SAP Lumira - BW Missing.png

Cause

  • In SAP Lumira 1.27 and above, there is no SAP BW Connection available by default.
  • The SAP BW Connection is a Data Extension that can be added to SAP Lumira. 

Resolution

  • To add the connectivity to SAP BW BEx Query or InfoCube, add the Data Extension "Download from SAP Business Warehouse":
      
    1. Open SAP Lumira 1.27 or higher.
         
    2. Under the menu "File", select "Extensions"
            
    3. In the "Extension Manager", click on the install button for the data extensions "Download data from SAP Business Warehouse"
        
      SAP Lumira - Install Extension.png   
          
        
    4. Once it is installed, it is required to close SAP Lumira, and restart it to start using the SAP BW Connectivity.
      Therefore, click on the "X" button in the upper right corner of the "Extension Manager" window to close it.
        
      SAP Lumira - Add Extension - 02.png

    5. Then to close Lumira Desktop, select "Exit" under the menu "File".
        
    6. Start SAP Lumira Desktop, and when creating a new document, select "Download from SAP Business Warehouse"
      to connect to an SAP BW BEx Query or an InfoCube.
       
      SAP Lumira - SAP BW Connection New.png

Keywords

Lumira, SAP BW, BEx Query , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0