Skip navigation

Excerpt from the book SAP Lumira, Discovery Edition: The Comprehensive Guide by Xavier Hacking and Martijn van Foeken. Used with permission of SAP PRESS. All rights reserved.


Learn how to get raw Microsoft Excel data into SAP Lumira documents.


Microsoft Excel spreadsheets are wildly popular, and this won’t change for a long time. These spreadsheets are a simple, convenient way to store, present, and analyze data, as there is no need to set up a complicated database infrastructure to create and use them. Of course, problems arise as soon as spreadsheets need to be up-scaled, to include more and more data, and to be used by more than a single user.


SAP Lumira, discovery edition can acquire data from one or multiple Microsoft Excel files. Supported versions are Microsoft Excel 2007 (.xls file extension), 2010, 2013, and 2016 (.xslx file extension). SAP Lumira, discovery edition can retrieve data from one sheet or all sheets of a spreadsheet. Also, the range of rows and columns that need to be imported can be defined.


If you want to acquire data from multiple files, then the rows from all files are appended in the same dataset. A new column named Source file is added to the dataset, which states the title of the source file for each record. The first file that you add is used as a reference template for the column definitions. This means that the header is taken from this file if you use the Set first row as column names option.


It is important that the other files have the same setup as the initial file. If another file has fewer columns, or the data types of its columns do not match the ones from the initial file, SAP Lumira, discovery edition will not allow the file to be imported. In case another file has more columns, the extra columns are not added to the dataset.


To create a new dataset from one or multiple Microsoft Excel files, follow these steps:

  1. Select Microsoft Excel from the Data Source menu on the home page of SAP Lumira, discovery edition. If you want to add a data source to an SAP Lumira document, use the New Dataset option in the Data menu.
  2. Select your Microsoft Excel file or files in the Open dialog.
  3. Click Open to close the dialog window. A new popup window is shown. Here we see a preview of the dataset and further information and settings for this acquisition (see the figure below). If you added multiple files, the additional Source file column is added at the end. The Sheet dropdown menu contains only sheets from the initial Microsoft Excel file.




  1. Change the Dataset Name.
  2. To add more files, use the Add Files button to open the Open dialog window again and browse for additional files. To remove files, you can delete the file location in the Files box or click the Clear Data button to remove all files.
  3. If your Microsoft Excel file contains multiple sheets, select the correct sheet in the Sheet dropdown menu.
  4. Select the Append all sheets option to include all the data from all the sheets. An additional column Source sheet is added to the dataset.
  5. Select Set first row as column names to use the values that are in the first row as the labels for each column in SAP Lumira, discovery edition. If you disable this option, the column names are displayed as Column_<n>, where <n> is the number of the column.
  6. Depending on the setup of the data in the spreadsheet, select the correct Table Header Type. In most cases, a Standard Table (No Transformations) is used. In such a table, all the values are organized in rows, as shown in the left table of the figure below. The right table of the figure below demonstrates how a cross table uses headers in both the columns and rows to organize the values.




  1. Click Show Record Count to display the total number of columns and records in the dataset.
  2. Deselect the columns that you don’t want to import. You can check Use Select All to include all the columns again.
  3. Below the preview table, click Advanced Options. Here you can enable or disable the retrieval of data from hidden columns and rows (Show Hidden Columns or Show Hidden Rows).
  4. Select Detect Merged Cells. With this option, all cells of a merged cell are filled with the value of the merged cell. If you don’t check this option, only the first cell is filled with the value.
  5. In case you selected Standard Table (No Transformations) as the Table Header Type, you can alter the Range Selection to a Custom Range. Enter the coordinates of the top-left and bottom-right cells that contain the data that needs to be acquired (for example, B2:K76) and click Apply. In addition, you can change the number of rows that need to be used as the header.
  6. If you choose Cross Table as the Table Header Type, you can change the number of Columns and Rows that must be used as headers (see the figure below).




  1. Click Visualize to finish the data acquisition and import the data into your SAP Lumira document.


Data acquisition is the first step to creating an SAP Lumira, discovery edition story, but Microsoft Excel spreadsheets are only one of the supported data sources. How do you begin your stories?


Excerpt from the book SAP Lumira, Discovery Edition: The Comprehensive Guide by Xavier Hacking and Martijn van Foeken. Used with permission of SAP PRESS. All rights reserved.

Follow SAP PRESS on LinkedIn for info on new releases, news, and more!


ASUG BI Community Newsflash

We are planning for ASUG at SAP TechEd Las Vegas.  We also just finished 50 webcasts this year with almost 10K registered and more are planned.   Please let us know what else you’d like to see our group do for you.

SAP TechEd Las Vegas: October 1-5

Learn from other SAP Users just like you at SAP TechEd Las Vegas.

As ASUG Design Team members, we used member feedback to drive and shape the educational content for the sessions at SAP TechEd, October 2-5 in Las Vegas. Please join your ASUG BI Volunteers at SAP TechEd to see how member-driven content, hands-on education, and networking with others in the Technology community can help you make the most of your SAP investment.

The full agenda of the conference can be found here.  Don’t forget to register for the popular hands on sessions.  Expect the best as SAP TechEd delivers instructor-led hands-on workshops and in-depth lectures presented by SAP's own top technical gurus – developers, solution and product managers, and implementation consultants – sharing their insider expertise and vision. And once again, ASUG is pleased to participate, and provide practical and technical content presented by customers and community members.

Did you know ASUG provides over 80 hours of education content at TechEd? Come see customer innovations in person at SAP’s premier technical event of the year!

SAP has a convince your boss letter to download today.  Explain that you will be a more valuable asset to your organization by attending SAP’s largest user conference.

ASUG SAP TechEd Preconference Sessions are open for Registration!

Jumpstart your conference experience by attending an ASUG pre-conference seminar.  Join the best minds in the industry, in a unique configuration to foster face-to-face networking and knowledge sharing.

Register Today

Data Visualization and Dashboards with SAP Analytics Cloud and App Design with SAP Analytics Cloud

Date: October 1, 2018

Hands-On | Full Day, 8:00 a.m.–5:00 p.m.
Fee: $745 ASUG Member | $845 ASUG Nonmember

This full day, hands-on workshop provides an overview of SAP Analytics Cloud and of its app-building capabilities. Attendees will learn what role SAP Analytics Cloud and its app-building capabilities can play as part of the overall SAP landscape and how these can integrate with existing on-premise and cloud-based data sources. You will have the opportunity to work directly with SAP Analytics Cloud and app-building features, in combination with SAP Business Warehouse and SAP HANA, to create a variety of dashboards.

Agenda Overview:

  • Introduction to SAP Analytics Cloud and app building with SAP Analytics Cloud
  • Data connectivity to on-premise and cloud-based data sources
  • Detailed hands-on exercises with SAP Analytics Cloud
  • Detailed hands-on exercises on app building with SAP Analytics Cloud
  • Learn how to leverage on-premise and cloud-based data sources.
  • Learn how to use SAP Analytics Cloud and its app-building capabilities to create compelling visual stories both on premise and in the cloud.
  • Learn how to use advanced options in SAP Analytics Cloud.

Opportunities to Influence

If you are interested in joining the ASUG Analysis Office Influence Council please register for our September BI: ASUG Analysis Influence Council Relaunch webcast.  This is a unique value offering that only ASUG has.

ASUG Annual Conference 2019

Save the date for ASUG Annual Conference 2019, May 7-9th. Call for proposals is tentatively planned for November 1.

Upcoming Webinars

  August 9 BI: Effective Data Visualization Dos and Don’ts

  Sept 17  BI: ASUG Analysis Influence Council Relaunch


More are being planned

For a list of our 2018 webinar recordings/replays please see this link.

BI+A Analytics Conference

Save the Date – March 11-13, Dallas Texas, for the 2019 BI+Analytics Conference, co-located with SAP Centric Financials.


Continue the conversation and follow @ASUG_BI on Twitter, participate in ongoing discussions here.

Register now for a replay of Application Building Capability within SAP Analytics Cloud Webcast


Application Building Capability within SAP Analytics Cloud.

Speaker: Jie Deng, SAP

1. What is the difference between 'Widgets' in SAC versus 'Components' in SAP Lumira Designer?

They are indeed the same. The terminology for SAC is Widgets, and in Lumira designer it calls “components”.


2. Is there a separate rich client planned for SAC Application Design?

No, that’s not planned. We want to exactly leverage the advantage of SAC to use browser to directly create analytical applications instead of installing the client first.


3. Can simple widgets like dropdown menus also be data driven in SAC?

What do you mean with data-driven for dropdown box? Do you mean the data-binding capability for drop-down box? If yes, the data-binding capability like we have for Design Studio is planned for future releases.


4. Are there planned abilities to cross-link or drilldown from one SAC Application to another? Is passing parameters while doing so a planned feature?

Yes, this feature is planned. We are planning to deliver the navigation between different applications and also passing parameters.


5. Are the applications designed on SAC inherently responsive? Or is there a container that allows designers to make the application responsive?

Currently with the first version of application design (wave13) the application is not responsive like the story. We do plan to deliver features like dynamic layout in Q4 this year.



6. Will the application design be included into the existing licensesor will there be  spcal type of license to buil applications?

To be able to create analytical application, the developer/designer need one of the planning license

To be able to consume the analytical application, the standard BI license is sufficient


7. Is there a way to profile applications built to identify the bottlenecks, if any?

Its not possible with the current version (wave 13). Of course, this feature is on our backlog


8. Does it share the inablities or limitations of SAC Analytics cloud. ?? R visualization for HANA Live models, blending between different models like HANA LIve  and static files? 2. Is it user responsive for mobile phones????

Application Design is integrated into the whole SAC landscape, it reuses the data modeling, data connectivity, lifecycle management etc. So it also shares the limitation of data connectivity in SAC.

With the current version (wave 13), the application is not responsive. But this feature is also on our backlog


9. Will this scripting capability / application design capability also apply to SAC Planning?  Can SAC applications also enable user to save Planning data?

Application Design is going to integrate the planning functionality that are available in SAC. So what’s possible with the planning sheet, it can be integrated into application design.

Integrating Planning functionalities are planned for Q3/Q4 this year.


10. Can 'Filter line' component work like a cascading filter? Ex: Based on Region filter, Country is filtered.

In case this cascading behavior is already modeled in the backend (e.g. in BW, region is the attribute for country), then you will see the behavior also in filter line.

Otherwise you can use scripting capability to implement the cascading behavior and then use widget (e.g. like dropdown box) to represent it.



11. Is SAC Application is successor of SAP ANALYTICS CLOUD Stories! what is best to recommend to client ???sorry for questions

No. They are different artifacts in SAC and serve for different purpose. For self-service scenario, business user should create stories. For IT-professional authored dashboards (including planning function, complex logic, and re-use aspects), then analytical applications can be created by developers/designers.



12. Also i see you have two Dates?? Currently SAC support one Date in a model!!! is it offered multiple in SAC Applications???

App Design is using the same data model as story. In my demo I have shown that you can make different date selection on data sources.



13. Currently we have a limitation in SAC till now. creating a calculated with dimension 2 3 forces the existence of dimension 2 and dimension 3 if not dimension23 dosent work! if it works it shows wierd chart and  is that still persistent in SAC Application?

The use case is not very clear to me. I need more detailed description



14. What if i have my own db hosted in cloud as Tenant a(client1),Tenant b(client2) but now i am building a SAC

visualization for tenant A and deployed.Now i want to reuse it for my client 2 by transporting existing hana models to client 2 teant from client 1 without data.?

and can i replicate SAC Stories to use them too on the same SAC dev environment or is the Analytics hub help me to manage my stories for different tenants on deployment for each tenant?

The scenario description is not 100% clear to me. Basically you can import the stories/applications etc. into SAC without Data.


15. for end of July App design applications can we use them on mobile?.

With the first version of application design (wave 13), its not possible to show applications on the SAC Mobile app. It’s on the roadmap to show analytical applications within SAC Mobile app.

Register now for  SAP BusinessObjects Universes Connectivity to SAP Analytics Cloud


Hosted by Reporting SIG

SAP BusinessObjects Universes makes it easy to access data using business terms regardless of the underlying data source schemas or vendor. Thousands of SAP customers leveraged Universes to run their BI solutions. SAP Analytics Cloud users can now access on-premise relational Universes without moving data to the cloud thanks to the new Live Universe Connector (LUC). Attend this session to understand the LUC architecture, key workflows and how to leverage this new live connectivity for your hybrid deployments.


Gregory Botticchio, SAP

Date:  Tuesday, July 24,  2018

Time:  8:00 a.m. PT | 11:00 AM  Eastern

Duration: 60 minutes

Register now for  BI: Extend your planning with SAP Analytics Cloud and SAP Business Planning and Consolidation Standard


Hosted by Analytics SIG

Learn how to introduce SAP Analytics Cloud into your SAP Business Planning and Consolidation landscape to reach new audiences, and make your financial planning and analysis operations more modern and flexible


Scott Godfree, SAP

Date:  Wednesday, July 18,  2018

Time:  8:00 a.m. PT | 11:00 AM  Eastern

Duration: 60 minutes

You can watch the replay at BI: Advanced Planning with SAP Analytics Cloud

Thanks to SAP's Scott Godfree for answering the open questions


We're planning to bring in HR data for planning . We need to be able to store the data in an encrypted manner so that only few people have access to the data. is this possible in Planning on Cloud?


Yes you have the ability to secure the model and/or specific dimension/elements within it.


What all programming languages SAC can support?


The Advanced Formulas presented in the webinar is an SAP Analytics Cloud specific type of (scripting) language for reading and writing data within an SAC model. Throughout the platform other languages are supported for specific use-cases (e.g. R for statistical calculations and to create certain types of charts), and JavaScript support will be forthcoming in the context of our planned Application Design paradigm.   Additionally, we have external APIs which can be leveraged to push data, create models and embed SAC in other components.


One questions: Can you say that all functions that are possible with BPC embedded (ith BW-IP) are covered by SAC?


SAP Analytics Cloud does not aim to have feature parity with BPC (any of the variants), but with the release of Data Actions and Advanced Formula’s we have moving well along in terms of functional parity.   Please note that BPC includes financial consolidations related capabilities and SAP Analytics Cloud does not plan to incorporate this capability. For financial consolidations we are suggesting SAP S/4HANA Cloud for Group Reporting (which can be used with or without the broader S/4HANA suite).


What are the key benefits of SAC? Why I should choose SAC Planning and not the BPC Embedded Planning?


SAP Analytics Cloud is aimed at customers who want a cloud first planning solution.  It incorporates BI, Planning and Predictive capabilities all in a single platform and helps customers move towards more continuous forecasting by breaking down the barriers associated with having distinct planning and analysis solutions. In includes rich capabilities around: data entry and spreading, private versioning, what-if simulations, allocations, collaboration, comments, workflow, predictive forecasting and driver based planning.


Can transaction objects (DSO of Cubes) from BW/4HANA or BW7.5 save planning data from SAC Planning?


There is currently no automated way to push SAC planning data into BW/4HANA or BW except via hybrid scenarios where BPC is running on one of those platforms


We can’t edit the model once created from a flat file. Will in future we plan to edit the models. Like adding columns


Yes currently we are targeting end of Q3 to support re-wrangling of your data sources

Register now for  What's new in BW/4HANA SP08



Hosted by Enterprise Data Warehouse SIG

The recent release of SP08 for SAP BW/4HANA delivers a host of new features and innovations. In this webinar we’ll cover the improvements in the area of Data Tiering Optimization (DTO), which helps lowering the TCO of your data lifecycle management. We’ll demonstrate the closer integration with Big Data scenarios, which open the door to new analysis opportunities, and optimized business processes.

As well, we’ll discuss the conversion options and provide an overview of the innovations on the SAP BW/4HANA roadmap


Ulrich Christ, SAP

Date:  Tuesday, July 17,  2018

Time:  8:00 a.m. PT | 11:00 AM  Eastern

Duration: 60 minutes

Register now for  BI: Advanced Planning with SAP Analytics Cloud



Hosted by Analytics SIG

Supercharge your plans.  This session will cover the newest capabilities within SAP Analytics Cloud for Planning, and discuss how to best leverage these features to help you maximum your planning deployments.   Learn how to better control access to plans with our new data locking, cover more advanced modelling concepts including the use of inversion formulas, learn how to give selective users the ability to create new master-data in-plan, and much more.


Scott Godfree, SAP

Date:  Thursday, July 12,  2018

Time:  10:00 a.m. PT | 1:00 PM  Eastern

Duration: 60 minutes

Register now for BI: Smart Features and Conversational AI in SAP Analytics Cloud



Hosted by Analytics SIG


Make better decisions, faster. Discover the next generation of smart discovery capabilities supported by the SAP Analytics Cloud solution. Ask your question in natural language and get insights instantly with Search to Insight, our newest Conversational AI feature.


Flavia Moser, SAP


Date:  Tuesday, July 10,  2018

Time:  9:00 a.m. PT | Noon  Eastern

Duration: 60 minutes

Register now for BI: Overview of Latest BI Features in SAP Analytics Cloud



Hosted by Analytics SIG

Learn about the most innovative BI features recently introduced in BI. In this webinar, we will explain how you can use the new Story & Visualisation features and showcase our latest releases in a real- life demo.

Take- Away:

  • Comprehensive understanding of the latest BI features and their use – cases
  • A demo showcasing the most exciting BI features - Q&A session after the demo


Christina Obry, SAP

Date:  Thursday, July 5,  2018

Time:  10:30 a.m. PT | 1:30 PM  Eastern

Duration: 60 minutes