Using SAP Lumira Desktop in Combination with SAP BW Queries

  • by Ingo Hilgefort, Vice President of Product Management, Visual BI Solutions
  • July 29, 2014
With the latest release of SAP Lumira Desktop, you can now connect directly from SAP Lumira Desktop to your SAP BW system using BEx Query connectivity. Learn the steps required to connect to SAP BW using this new option and see how your existing metadata is supported by SAP Lumira.
Learning Objectives

Reading this article, you will:

  • Learn how you can use SAP Lumira to establish a connectivity towards your BEx Queries in SAP BW
  • Understand which of your existing metadata in SAP BW is going to be leveraged by SAP Lumira Desktop
  • Learn what some of the limitations are using this new data connectivity option
Key Concept

Until recently, SAP Lumira Desktop was able to leverage a Universe-based connectivity towards SAP BW InfoProviders and a connectivity towards SAP HANA analytical models when using SAP BW on SAP HANA. With the latest release, SAP Lumira Desktop also offers connectivity towards BEx Queries, allowing users to leverage more of their existing metadata in SAP BW.

SAP Lumira is SAP’s newest product for the discovery and analysis area of the overall business intelligence suite. In the latest release for SAP Lumira Desktop, the option to connect directly from SAP Lumira Desktop to the BEx Queries in the SAP BW system was added, allowing you to leverage a lot more from your existing metadata.

I first review the general workflow for how you can connect to your BEx Queries. Then I look into specific metadata from your SAP BW systems, such as restricted and calculated key figures and hierarchies. Finally I take a look at what some of the known limitations are for this new data connectivity option and how this impacts your BEx Query design.

Ingo Hilgefort

Ingo Hilgefort started his career in 1999 with Seagate Software/Crystal Decisions as a trainer and consultant. He moved to Walldorf for Crystal Decisions at the end of 2000, and worked with the SAP NetWeaver BW development team integrating Crystal Reports with SAP NetWeaver BW. He then relocated to Vancouver in 2004, and worked as a product manager/program manager (in engineering) on the integration of BusinessObjects products with SAP products. Ingo's focus is now on the integration of the SAP BusinessObjects BI suite with  SAP landscapes, such as SAP BW and SAP BW on SAP HANA, focusing on end-to-end integration scenarios. In addition to his experience as a product manager and in his engineering roles, Ingo has been involved in architecting and delivering deployments of SAP BusinessObjects software in combination with SAP software for a number of global customers, and has been recognized by the SAP Community as an SAP Mentor for SAP BusinessObjects- and SAP integration-related topics. Currently, Ingo is the Vice President of Product Management and Product Strategy at Visual BI Solutions, working on extensions to SAP’s product offering such as SAP BusinessObjects Design Studio and SAP Lumira. You may follow him on Twitter at @ihilgefort.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.