Skip to Content
avatar image
Former Member

SAP Lumira usage for Data representation layer with data caching option

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 18, 2017 at 01:57 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2017 at 06:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2017 at 06:27 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Sep 19, 2017 at 10:25 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded