Lumira Desktop 1.17 – A First Look at BEx Query
When I launched Lumira Desktop this morning it prompted me for an update, which I applied:
Next, you will notice some new connections:
I select Connect to SAP Business Warehouse, as I want to connect to a BEx Query. Previously Lumira only supported connections to BW Universes.
You can select either by role or InfoArea. In this case I am searching for Solution Manager BEx queries.
The above shows Lumira 1.17 connects to the BEx Query,but you only have access to the Visualize room, not compose, preparation, etc. I believe this is just the first step towards future functionality.
I can do a line chart an see we had a spike in SolMan tickets October 31st (Halloween)!
I can also look at a pie chart of tickets closed (green) and open (blue)
More to come…
Thank you Tammy! You are right. This release will expose basic capability of allowing users to connect to BEx Query, see hierarchical data in the cross tab or visualize information using charts. This is our first step. A lot more to come in upcoming releases!
Thank you for your time and perspective as usual!
Lumira is going to get a major product in SAP-family Thank you for reminding me to get the update.
Why is always the Rum gone?
Dear Tammy - my BW System does not display any ressources when I am connected within Lumira? - Are there any additional BW rights necessary - I have a lot of bics connections from my BOBI System - works fine. So what could be the cause that I can't see any bw ressources in Lumira?
The connections are read from the SAP logon. Do you have a SAP Logon installed and configured in the client machine where you are trying to connect SAP Lumira to SAP BW?
Thanks to Tammy Powlas hint: the problem was solved by setting the SAPINI environment Variable.
Lumira 1.17 BW connectivity - No data sources found InfoAreas/Roles view empty
You need to switch to InfoAreas.
With kind regards,
I am having the same issue. I am able to connect to my BW system but do not see anything under InfoAreas or Roles......
Can I ask what particular BW version & SPS Version you have?
Do they see anything when they alter to ‘View:’ type ‘InfoAreas’
What occurs when you attempt to ‘Find’ / search when either in
view type roles/infoareas?
As you should see applicable roles/infoareas
as per Tammy’s 3rd screen shot
My contact details are on my Bio.
Many Thanks in advance,
I just sent an email. We are on 7.30 SP 9. Nothing comes up when I alter to 'View:' type 'InfoAreas'.
When I attempt to 'Find' in either roles/infoareas no results come back.
Even InfoAreas appear empty for me, any hints ?
Is there a minimun BW version required ?
I would suggest these SAP BW online specific questions are asked and tracked in separate posts. This will make their handling easier.
For SAP BW versions, please refer to the SAP Lumira 1.17 PAM. See https://service.sap.com/sap/support/pam?hash=pvnr%3D67837800100900006823%26pt%3Dg%257Cd
OK, thanks I have a supported BW version then. In that PDF there's a reference to this NOTE: "SAP Business Warehouse release restrictions are documented in the SAP note: http://service.sap.com/sap/support/notes/2020352"
Note not released yet.
The note is released for customers. Thanks for raising this.
Here is the SAP BW specific information:
Connect to SAP Business Warehouse
i) When acquiring data from a SAP Business Warehouse system, only Visualize tab is available. Prepare, Compose, Predict and Share tab features are not available.
ii) SSO Support in 64bit is restricted to SAP Secure Login Client SSO
Release restrictions are also available from our help page SAP Lumira – SAP Help Portal Page:
Got to get with our basis guys and figure out why I get UNKNOWN ERROR when trying to connect to our BW system. I believe we are on the good patch level. Could be 64 bit related restriction. Not sure yet.
Hi Tammy, great post as always !
We are experiencing some issues when accesing BEx Queries that are build on top a Virtual Provider based on a HANA View.
Anyone experienced something like this ?
After opening the query, the filter screen pops up ok, you select whatever is needed then clic OK and it starts aquiring but then all of a sudden it terminates and goes straight into a white canvas that says: /dsvizroom.do
Can I ask you to raise a customer incident (Lumira Desktop component) for
your issue, so as to best support you.
Many thanks in advance,
Thanks for sharing the info. Please Let me know if Lumira is free with Bobj Enterprise Edition or How is it possible to get the Keycode.
I Am not familiar with the license models
Generally to get the key code you have to buy the product
just a suggestion, but I think it would be useful to see a hierarchy in the table component, and maybe the variable input screen too?
Hi Henry -
Thank you for the feedback (as always)
I show the hierarchy input screen here in the last screen shot:
Second Look at BEx/BW with Lumira 1.17
I will try to show more as time allows...looking forward to seeing others' contributions.
Are your BW system entries in the saplogon.ini file on your machine?
Please look at this thread Lumira 1.17 BW connectivity - No data sources found InfoAreas/Roles view empty
Update installed, and Environment variable set, now it works !
Screenshot of the selection screen for hierarchy node: (good enough for me)
You can select the nodes in the highlighted area:
Can somebody let me know whether 'Prepare, Compose, Predict and Share' tab features of Lumira are available in the latest version of Lumira using "connect to SAP Business Warehouse " option?
Yes, sure it does - for quite some months now this is possible. save also Save to to Biplatform, then view, edit and refresh from BIlaunchpad.
Note that we re-implemented it as 'download from bw' . ( this particular blog dates back to June '14 ). to add also : the predict tab is part of Predictive Analytics 2,x not Lumira .
Thanks for information Henry.