SAP Lumira usage for Data representation layer with data caching option

[Former Member]

Hi SAP team,

We are developing a data warehouse solution on top of the warehouse we need to build a Data representation tool which should be able to provide us the mechanism to create a report on the fly and generate dashboards

Currently we are planning to use SAP BO 4.0 but it does not provide a caching mechanism (unlike Qlikview which provides cahching)

Can you please help us understand if SAP lumira provides caching so that our queries for daily information will not hit DB once the data is extracted

Also for any adhoc reporting whenever needed like SAP BO we want to have a way by which the data will be fetched out of database server

Thanks,

Sonal Shinde

[TuncayKaraca]

Hi Sonal,

Once you create your Lumira analytics document it acquires data from the data source (universe, database, file, etc.) then the document is created with the data. So once you use the document you will have all data that you acquired and you can create charts, stories, pages, etc without again accessing the data source. Only time you will again access the data source when you refresh your Lumira document.

If we think about a multiple user scenario as you described - in this case your Lumira document will be on Business Objects BI Server- users can open the document with already / last acquired data and meaning they are not accessing the data source. Some users -not all of them- will have refresh right, and only these user can refresh the document that meaning accessing the data source. Users who have refresh right can refresh the document with new data on demand any time or the document can be scheduled to be refreshed for example every day in the morning. Then all other users will have the document with newly refresh data.

If I understand your points correctly hopefully my explanation would be helpful.

[TammyPowlas]

I looked at the SAP Help and here is what it says - see this link: https://help.sap.com/viewer/4f58d91f03e441b68d3187e94be27df2/2.0.2.0/en-US/62b1739725f94203b5799dfdd...

[Former Member]

What does caching feature on the desktop means?

We want that when data is retrieved start of day for the universe that should be fetched from database and stored on server like qlikview and loaded into memory for the first user

but any subsequent query doesn't hit database for any other user

[TammyPowlas]

Lumira 1.31 has a caching feature on the desktop - see https://archive.sap.com/discussions/thread/3650789 - which version of Lumira are you evaluating?