Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Lumira Server for BIP Question

Hi all,

I have a question regarding Lumira Server for BI Platform and more specifically, around how its velocity engine operates. Here is a scenario that I'd like more clarification into:

Let's say I'm a retail company and I have a SQL Server database with a big volume of data. One of the ways I can slice this data is by product and let's assume that in my company each product is governed by an individual who only has access to his/her own product and is only interested in the performance of that product. I build a universe on top of my SQL database and in IDT I create a prompt on product name. When I launch Lumira, I get prompted for the product and if I'm the manager responsible for Wines, I will choose wines and continue. At this point, Lumira will proceed to load that data in memory.

Here are my questions:

1) If I have two users who want to use that Wines data and they hit refresh in Lumira, what does Lumira Server do? Does it load the same Wines data twice or does it know user A has already loaded it and just refreshes it?

2) My understanding is that when a user clicks on the Refresh button in Lumira, Lumira Server drops all data that was loaded before and re-acquires all over again. Is this correct?

3) Going back to 1), suppose I now have two managers, one of whom wants to see Wines data and the other one - data for Household products. When they launch Lumira and select their respective products in the prompts, I'm assuming Lumira loads two separate datasets in memory. Correct?

Thank you very much in advance!

Regards,

Antonio

Tags:
Former Member
Former Member replied

Hello,

#1, Lumira delegates security to underlying Data source. hence the dataset resulting from the query is loaded twice for each user.

#2, When user hits on refresh Lumira server creates a new instance for the refreshed data in-memory. dropping of existing instance from memory depends on usage by any other users only for view actions

#3, thats right, two data sets would be loaded into memory associated for each user.

Regards,

Ramu.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question