cancel
Showing results for 
Search instead for 
Did you mean: 

Lumira Discovery loading data source from CMS?

Former Member
0 Kudos

Hi,

so we have an issue where we want users to update their data from the excel sheet without having to reload the data source each time or give them 'Edit' access,

so we believe this can be solved by loading a remote Excel file as a data source, is that possible, can we load an Excel file that is on a CMS or a shared drive as a data source?

Thanks,

Accepted Solutions (0)

Answers (2)

Answers (2)

james_batchelor2
Active Participant
0 Kudos

I keep hoping for this feature as well. Similar to the way Webi can handle BI Platform stored Excel data sources. We use this often in Webi.

I do not think any Excel data source can be refreshed if the LUMX file is accessed via the BI Platform using the web viewer. Only way around that would be to ODBC/Relational Connection/Universe to the Excel file on a shared drive. Or HANA view. More work than is needed for a simple flat file of Excel data that gets updated every now and then.

Currently I do this manually and push the new LUMX file to the repository for user consumption.

james

TammyPowlas
Active Contributor
0 Kudos

Hello Jack - one option is to schedule the Excel data source in Lumira Discovery using the BI Platform - this is covered in the free Open SAP Course at https://open.sap.com/courses/lum1 - it is very comprehensive