Lumira based on universes with contexts

[arne_vanhoof2]

Dear,

I'm trying to load data from a universe with contexts in SAP Lumira.

Now I noticed that he will only load one of both datasets.

For example my context makes a distinct for the measures of the header table and the line item table. (Fan trap)

If I do select the following data:

header info, header measures, line info, line measures

Than I will only get the header info & header measures in SAP Lumira, he just ignores the other dimensions and measures.

So is SAP Lumira not able to use universes based on contexts?

Is there a solution for this problem?

Otherwise Lumira becomes almost unusable with universes...

My version of lumira is the latest available.

[TammyPowlas]

Hi - can you share more details - are you using the newer universes and if so are you using the Universe Query panel extension with Lumira?  Are you using BI4.1 spx?  .UNV or .UNX?  If you are using the newer one try using the Universe Query panel extension

[arne_vanhoof2]

Hi Tammy,

I'm using .unx

Just tried the Universe Query Panel and I received the following message:

So lumira is not able to use universes based on contexts 😕

[former_member183750]

Hi Arne

Please see if the following KBA will help:

2172746 - SAP Lumira - Connecting to a universe data source

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter (#SAPLumira)

Got Enhancement ideas? Use the SAP Idea Place 

[arne_vanhoof2]

It seems like the link and note is not working?

I get the error:

  Document is not released

[TammyPowlas]

Hi Arne - I asked SAP Support to release it - hopefully it gets released soon.

[former_member183750]

I could release it, but I am not sure if the author would want me to - it may be he is still working on polishing it a bit or adding more info to it. In the meantime, here is a copy / paste of the KBA:

Symptom
How to connect a universe data source in Lumira?


Resolution
1. On the Home page, select Acquire Data.
2. In the Add new dataset dialog, select Universe, and select Next.
3. In the Universe credentials pane:

Enter the name or IP address of the server that hosts your Central Management Server (CMS).  
If you are connecting to a CMS that belongs to a different network domain, make sure the hosts file located at C:\Windows\System32\drivers\etc has the corresponding host name entry (for example, x.x.x.x<NameOfMachineHostingCMS>). 
Enter the CMS user name, password, and authentication type. 
To use Windows AD authentication to connect to the CMS, append the following entries in theSAPLumira.ini file, located at <LumiraInstallDir>\SAPLumira\Desktop:
-Djava.security.auth.login.config=<Path_to_bscLogin>\bscLogin.conf
-Djava.security.krb5.conf=<Path_to_kbr5>\krb5.ini
-Djava.security.auth.login.config=C:\Windows\bscLogin.conf
-Djava.security.krb5.conf=C:\Windows\krb5.ini  
Select Connect.
A list of universes available in the CMS appears. 

 4. Choose a universe, and select Select. 
5.Choose the required objects in the universe tree, and select Acquire.

Before acquiring data, you can preview the data and apply filters by selecting the Preview and Select Data option. If a query contains contexts or prompts, you must respond to them before data can be acquired. When creating a query, you can set the following query properties:

Max Rows Retrieved: The maximum number of rows to be retrieved by the query.  
Max Retrieval Time: The maximum amount of time a query can run (in seconds).  
Retrieve Duplicate Rows: Select to retrieve duplicate rows. 

Please do consider the above KBA to be a Beta until it is released / published.

- Ludek

[Former Member]

Dear,

Thanks for the information. But this note is not related to my issue.

I think we can conclude that Lumira is not supporting multiple flow queries, which means that universes with contexts can not be used when including objects of more than one context.

Hopefully this will be supported in the future.

Regards,

Arne

[former_member185603]

Is there any update on this feature, Lumira supporting Universe contexts? We verified with 1.29.3, still same issue.

Any plan to support in future releases?

I looked at SAP note# 2201458 which was released in 8/2015. But there is  mention of Lumira 1.0 version to that not which is old.