Skip to Content
Author's profile photo Tammy Powlas

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:

/wp-content/uploads/2014/06/1install_475731.gif

Next, you will notice some new connections:

/wp-content/uploads/2014/06/2bw_475732.gif

I select Connect to SAP Business Warehouse, as I want to connect to a BEx Query.  Previously Lumira only supported connections to BW Universes.

/wp-content/uploads/2014/06/3bexquery_475781.gif

You can select either by role or InfoArea.  In this case I am searching for Solution Manager BEx queries.

/wp-content/uploads/2014/06/4onlyvisualize_475782.gif

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.

/wp-content/uploads/2014/06/5linechart_475783.gif

I can do a line chart an see we had a spike in SolMan tickets October 31st (Halloween)!

/wp-content/uploads/2014/06/6pie_475784.gif

I can also look at a pie chart of tickets closed (green) and open (blue)

More to come…

Assigned Tags

      29 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sharon Om
      Sharon Om

      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!

      Author's profile photo Florian Henninger
      Florian Henninger

      Hi Tammy,

      Lumira is going to get a major product in SAP-family Thank you for reminding me to get the update.

      ~Florian

      Author's profile photo Former Member
      Former Member

      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?

      - Wobi

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Hi Wolfgang,

      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

      Antoine

      Author's profile photo Former Member
      Former Member

      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

      ... Wobi

      Author's profile photo Former Member
      Former Member

      Hi Wolfgang,

      You need to switch to InfoAreas.

      With kind regards,

      Martijn

      Author's profile photo Former Member
      Former Member

      I am having the same issue.  I am able to connect to my BW system but do not see anything under InfoAreas or Roles......

      Chris

      Author's profile photo Former Member
      Former Member

      Hello All,

      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,

      David

      Author's profile photo Former Member
      Former Member

      David,

      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.

      Chris

      Author's profile photo Former Member
      Former Member

      Hi,

      Even InfoAreas appear empty for me, any hints ?

      Is there a minimun BW version required ?

      Br,

      Miguel

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      I would suggest these SAP BW online specific questions are asked and tracked in separate posts. This will make their handling easier.

      Best regards,

      Antoine

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      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

      Antoine

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Hi Miguel,

      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:

      http://help.sap.com/businessobject/product_guides/vi01/en/lum_117_restr_en.pdf

      Thanks

      Antoine

      Author's profile photo James Batchelor
      James Batchelor

      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.

      Author's profile photo Former Member
      Former Member

      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

      :S

      Author's profile photo Former Member
      Former Member

      Hello Santiago,

      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,

      David

      Author's profile photo Reshoi R
      Reshoi R

      Dear Tammy

      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.

      Regards

      Reshoi R

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I Am not familiar with the license models

      Generally to get the key code you have to buy the product

      Author's profile photo Henry Banks
      Henry Banks

      Hi Tammy,

      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?

      cheers,

      H

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      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.

      Tammy

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Are your BW system entries in the saplogon.ini file on your machine?

      Author's profile photo Former Member
      Former Member

      saplogon.ini

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author
      Author's profile photo Former Member
      Former Member

      Update installed, and Environment variable set, now it works !

      Thanks!

      Author's profile photo Former Member
      Former Member

      Screenshot of the selection screen for hierarchy node: (good enough for me)

      You can select the nodes in the highlighted area:

      /wp-content/uploads/2014/06/hier1_487129.jpg

      Author's profile photo samson r
      samson r

      Hi All,


      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?


      thanks

      Author's profile photo Henry Banks
      Henry Banks

      Hi,

      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 .

      Regards,

      H

      Author's profile photo samson r
      samson r

      Thanks for information Henry.