Skip to Content

Second Look at BEx/BW with Lumira 1.17

June 20, 2014 | 47 Views |
 Business Intelligencesap lumirasaplumirasapmentorsapmentors
Follow

First, SAP’s Antoine Chabert posted this in a blog comment:

“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


Second, I am seeing a lot of comments about not being able to see the BW system when connecting to Lumira Desktop 1.17.  This is a “guess” on my part but perhaps the BW system is not listed in the SAPLOGON.INI which is usually on the users’ local drive.  My SAPLOGON.INI file is populated because that is required if you are connecting to ERP/BW systems using Crystal Reports 2013.


Lumira 1.17 connects to the BW InfoProvider:

INFOPROVIDER.png


But you see of course that the InfoProvider only brings back aggregates.  Your first choice should be connecting to the BEx query.  Where would connecting to the BW InfoProvider be useful?  Maybe with the new numbers only visualization?  See below:

/wp-content/uploads/2014/06/numbers_480453.png


You can see Lumira will support the date ranges from the BEx query below:

date range support.png


Why connect to the BEX Query?

connect to BEx query.png

You want to connect to the BEx Query because it provides support for your BEx query’s calculated key figures as shown above (Balance is a calculation of budget minus actuals)


Also see how Lumira supports hierarchical prompts from the BEx query:

/wp-content/uploads/2014/06/hierarchy_480466.png


The latest download can be obtained from SAP Lumira (64 bit)


Related:

Lumira Desktop 1.17 – A First Look at BEx Query

To report this post you need to login first.

17 Comments

You must be Logged on to comment or reply to a post.

  1. James Batchelor

    Thanks Tammy!

    I am hoping to figure out why I cannot get it to connect.  Can see our BW landscape, but get an error when trying to connect.  So far as I can tell we meet the backend requirements..maybe a 64bit Lumira to 32 bit 7.30GUI.. will have to open a ticket.

    thanks again!

    jim

    (0) 
        1. Former Member

          Ok I am not an expert and the experts are out of office. If you have time, can you please try following SSO logon a try (this is 64-bit).

           

          1. From SAPnote 352295(https://css.wdf.sap.corp/sap/support/notes/352295), download the attached file
            win64sso.zip.
          2. Unzip win64sso.zip to some
            location, note the full path to the extracted file gx64krb5.dll
          3. Set the User Environment Variable SNC_LIB_64
            to the full path of the extracted gx64krb5.dll

               

          (eg. SNC_LIB_64=c:\ssolibs\win64sso\ gx64krb5.dll). Set
          it by going to Run -> SystemPropertiesAdvanced.exe, then click “Environment
          Variables”.

          If all goes as planned, SSO from 64-bit Lumira should then work.

          (0) 
            1. Former Member

              Hi James

              No need to find 64 bit SAP GUI.  32 bit 7.30 SAP GUI should work with both 32 bit and 64 bit Lumira Desktop.  If you are not using SSO, saplogon.ini is probably the only thing Lumira Desktop needs to know from SAP GUI.  If you can see the BW landscape entries from Lumira Desktop, most likely you have already had a good SAP GUI installed (but this doesn’t mean it properly configured).  BTW, I believe 64 bit SAP GUI is still in planning phase and not released yet.

              The ‘unknow error’ could be caused by different reasons as far as I have experienced.  For now, customers have to trouble shootting by collecting trace logs where it usually reveals some hints for the root cause.  I would like to post a seperate blog about this when I could have my hands free, but here are some quick things you can try:

              1. Read the Lumira trace logs (located at %temp%\sapvi\logs)

              2. If that’s not enough, you can also enable and read the jco trace (here is an instruction how to enable jco trace: https://support.wdf.sap.corp/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F736&hellip😉

              Reading the tracelogs requires some developer skill and product knowledge, but sometimes it could quite easily be lucky if spotting to the correct place of the logs.

              Hope this could help a little bit,

              ~xing

              (0) 
                1. Former Member

                  Hi James,

                  Did you make it work to connect your BW from Lumira Desktop?  I am curious what your finding is.  Want to share your fix?

                  Thanks,

                  ~xing

                  (0) 
  3. Former Member

    Hierarchies are supported now. I have Desktop v1.22 and can connect to BW. But I fail to see how this is any more useful than creating nice charts and graphs through Excel with BEx or AFO. I would like to be able to storyboard with BW data in Lumira using Connect to SAP BW. Otherwise I need to crerate a universe connection to BW, which I can’t w/o java stack. And even with that you can’t use queries. Perhaps Lumira Server/Edge will allow you do do that in future versions.

    (0) 
    1. Tammy Powlas Post author

      Hi Lance – today you can’t use a BEx query on a storyboard; things are planned to change in the future on this

      (0) 

Leave a Reply