In the first part you learned how you can leverage the SAP NetWeaver BW on SAP HANA trial to start your very own SAP BW and BI4 system – that was yesterday. Today we will focus on getting the system updated with SAP Lumira SP12 and we will setup our Universe on top of the SAP NetWeaver Demo model in the SAP BW system.

  1. Navigate to the SAP Cloud Appliance Library
  2. Navigate to the tab Instances.
  3. Activate your Instances. The instances should be ready in a few minutes.
  4. Log on to the BI4 environment using Remote Desktop.

Today we want to update our BI4 system to Lumira SP12. Right now the BI4 system has Predictive Analysis SP11 installed, so for us to install SAP Lumira SP12 means we first need to remove SAP Predictive Analysis, download SAP Lumira SP12 and install it.

So let’s start with removing SAP Predictive Analysis from the system:

  1. Log on to the BI4 instance using Remote Desktop.
  2. Navigate to Start Control Panel.
  3. Select Programs.
  4. Select Programs and Features.
  5. Scroll down to SAP Predictive Analysis.
  6. Click Uninstall.

After we uninstalled SAP Predictive Analysis, we now need to download SAP Lumira SP12.

  1. Navigate to Service Marketplace – http://service.sap.com/swdc
  2. On the left hand side select Installations and Upgrades
  3. Select Browse our Download Catalog
  4. Click on Analytics Solutions
  5. Click on Lumira (Visual Intelligence)
  6. Select Lumira 1.0
  7. Select Lumira 1.0 64 Bit
  8. Select Windows on X64 64 bit
  9. Select SAP Lumira 1.0 SP12 and add it to the Download basket.

The SAP Download Manager is installed on the SAP BusinessObjects BI 4 Instance so you can directly download the Software to the BI4 instance.

  1. Log on to the BI4 instance using Remote Desktop.
  2. Navigate to Start ProgramsSAP Download Manager SAP Download Manager
  3. In the SAP Download Manager select the menu View Download Manager configuration
  4. Enter your user and password for SAP Service Marketplace.
  5. Click OK.
  6. Start the download. The software will be downloaded to C:\download.

When the download is finished you can start the installation of SAP Lumira SP12. First you set the destination folder.

LUMIRA_BLOG_08.jpg

In the next step you accept the License Agreement. On Step 3  …

LUMIRA_BLOG_09.jpg

… you can use “Register later” for now.

When the installation is finished…

LUMIRA_BLOG_10.jpg

.. make sure the “Launch SAP Lumira 1.12 after installation completes” checkbox is activated and click Finish.

SAP Lumira is being started but you need to enter a keycode. Navigate to the menu Help Enter KeyCode.

You can receive temporary keycode from SAP Service marketplace: http://service.sap.com/licensekeys.

At this point we have a running SAP BW on SAP HANA system and we installed SAP Lumira SP12 on our BI4 server. Lets now create the Universe (UNX) on top of the MultiProvider for the SAP NetWeaver Demo model.

…but before we can leverage a Universe (which uses the SAP Java Connector) in combination with our SAP NetWeaver BW system we need to configure the Gateway security. The default in a BW 7.3 is “locked” so the Information Design Tool would not be able to communicate to SAP NetWeaver BW.

You can do this in two ways:

Option 1:

You configure the profile parameter gw/acl_mode to the value 0 as part of the Default profile and restart the BW server.

Option 2:

You ensure that in the files secinfo and reginfo on the operating system (on the BW on HANA server) include the following entry:

P TP=* USER=* USER-HOST=* HOST=*

Both of the configurations are for sure not something you would do in a production environment but should be ok in our environment as we are using this for our education purposes.

After we configured that, we can now start creating the Universe:

  1. Start the Information Design tool by following the menu Start • All Programs • SAP Business Intelligence • SAP BusinessObjects BI Platform 4 Client Tools • Information Design Tool.
  2. Select the menu File • New • Project to create a new project for your Universe.
  3. Enter BW_UNIVERSE as name for the new project and click Finish.
  4. Select your new project in the list of Local Projects.
  5. Select the menu Window and make sure the window Repository Resources is shown.
  6. Select the menu Insert Session in the Repository Resources to establish a session to your SAP BusinessObjects system.

LUMIRA_02_01.jpg

  1. Use the following details to log on
    • System:                              localhost
    • User                                   BWH~001/DEMO
    • Password                           Welcome!
    • Authentication                     SAP
  1. Click OK.
  2. Open the context menu of your established server connection in the area Connections.

LUMIRA_02_02.jpg

  1. Select the menu item Insert Relational Connection

SAP NetWeaver BW Connection

To establish a relational connection towards the SAP NetWeaver BW connection you need to first establish a session towards the SAP BusinessObjects system, and then create a connection starting with the repository of your SAP BusinessObjects system, which is slightly different to the usual workflow

  1. Enter a name for the connection – BW_CONNECTION
  2. Click Next.

LUMIRA_02_03.jpg

  1. Select the connection type SAP Java Connector in the category SAP NETWEAVER BW.
  2. Click Next.

LUMIRA_02_04.jpg

  1. Enter the necessary details of your SAP NetWeaver BW system:

    • Authentication Mode:                 Use Single Sign On
    • Client Number :                         001
    • Language :                                EN
    • System ID :                               BWH
    • Application Server :                   imdbhdb.sapcoe.sap.com
    • System Number                         01

(Yes – when you are using the BW on HANA Trial you can use the values written here!)

  1. You can use the Save Language option to save your settings as configured in the relational connection. In case you leave the checkbox open, the user can influence the language by setting the user preferences in the BI Launchpad.
  2. Use the button next to the box InfoProvider to receive a list of possible InfoProvider.

LUMIRA_02_05.jpg

  1. You can use the filter as part of the screen to limit the list of InfoProvider based on the type of InfoProvider:
    • IOBJ = InfoObject
    • CUBE = InfoCube
    • ODSO = Operational Data Store
    • MRPO = MultiProvider
    • VIRT = Virtual InfoProvider
  1. In our example we are using the MultiProvider 0D_NW_M01 from the NetWeaver Demo Model. The entry will have a “I” in front of the technical name.
  2. Click OK.
  3. Click Finish.
  4. You will be asked if you would like to create a shortcut for your connection. Click Yes.
  5. Select your local project.
  6. Click OK
  7. Click Close.
  8. Select your local project.
  9. Select the menu File • New • Data Foundation.
  10. Enter BW_DATA_FOUNDATION as name for the Data Foundation.
  11. Click Next.

LUMIRA_02_07.jpg

  1. Select the option Multi-Source-Enabled. The connection towards SAP NetWeaver BW is not available when using the Single Source option.
  2. Click Next.
  3. You will be asked to logon to your SAP BusinessObjects Enterprise system. Your credentials should already be entered.
  4. Click Next.
  5. Select the shortcut which was created for the connection we established previously.
  6. Click Next.

LUMIRA_02_08.jpg

  1. Click Advanced.
  2. Ensure the option AUTOMATICALLY CREATES TABLES AND JOINS is activated.
  3. Click Finish.

You are presented with a default generated star schema for the selected InfoProvider.

  1. Select the menu File • New • Business Layer
  2. Select the entry Relational Data Foundation
  3. Click Next.
  4. Enter BW_BUSINESS_LAYER as name for the Business Layer.
  5. Click Next.
  6. Use the   button and select the newly created Data Foundation – BW_DATA_FOUNDATION.
  7. Click OK

LUMIRA_02_09.jpg

  1. Ensure the option Automatically create folders and objects for SAP NetWeaver BW connections (recommended) is activated.
  2. Click Finish. 

 

You are being presented with a list of classes, dimensions, and measures that have been generated based on the information retrieved from SAP NetWeaver BW.


  1. Select the menu File > Save All.
  2. Right-Click the newly generated Business Layer entry as part of your local project.
  3. Select the menu Publish > To a Repository
  4. Select the integrity checks you would like to perform.
  5. Click Next
  6. Select a folder for the Universe.
  7. Click Finish.
  8. Click Close.
  9. Close the Information Design Tool

At this point we installed SAP Lumira SP12 on the BI4 Server environment, we configured our BW system to allow the RFC communication and we created a relational Universe (UNX) on top of the MultiProvider from the SAP NetWeaver BW Demo model.

So we are ready to use SAP Lumira with the relational Universe…..tomorrow ! =:)

Here are some additional resources:


To report this post you need to login first.

24 Comments

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

  1. Jonathan Haun

    Great Posting as always. I was curious to know your thoughts on connecting Lumira to BW DSO’s and Cubes that have been imported into SAP HANA and converted to SAP HANA information views? IE. Connecting Lumira to SAP HANA (Online). I have been doing this for some time to get around the fact that Lumira was unable to use the JCo Universe properly. (Until SP12 that is). However, I have to recreate the BW security in SAP HANA when needed or in some cases.

    In addition to your thoughts on using SAP HANA information views, does the JCo Universe with SAP Authentication fully support SSO to BW. Also, if I log on with an AD account will the STS (Security Token Service) pass my associated SAP alias to BW?

    Thanks.

    (0) 
    1. Ingo Hilgefort Post author

      Hi,

      when you generate the model using the wizard in SAP HANA Studio you can also use the option to generate HANA Security based on your existing BI Authorizations.

      and the Universe does fully support SSO for a long time already, In case you want to combine it with AD credentials you will need things user mapping and STS Token Service in place.

      regards

      Ingo Hilgefort

      (0) 
      1. Jonathan Haun

        Ingo,

        That option in HANA Studio simply creates roles and analytic privileges in SAP HANA. I then have to provision the users in HANA, provision the users in AD, assign them to roles in HANA and setup SAML or Kerberos for BOBJ SSO to HANA. That is the manual part I was mentioning.

        Concerning the JCo Universe option, assuming that SAP Lumira properly honors the standard BOBJ / SAP authentication and SSO to BW, it seams like the JCo option is better when security matters.

        (0) 
        1. Ingo Hilgefort Post author

          Hi,

          obviously if you want to combine your users with AD you have to provision the users in AD.

          HANA Studio is giving you the roles and the privileges based on your BI authorizations.

          and yes you will have to create the users.

          and for sure the Universe is NOT the better option simply because the Universe is a relational View on BW and it will always have major limitations.

          Ingo

          (0) 
  2. Rama Shankar

    Thanks Ingo – Any plans to make Lumira independant to a Universe / Data Foundation and use BICS instead for BW data access? Please advice.

    Rama

    (0) 
  3. Cyrus Minab

    Hi,

    I encountered the following problems going through the directions:

    1. I can’t uninstall Predictive Analysis on the Remote Desktop. I tried using the password Welcome! for Administrator and it failed. I also tried log on to the Remote Desktop using Administrator as id instead of Demo…..and it didn’t work.

    2. Maybe this requires some clarification. In order to download Lumira from SAP market place we need to have a S user id which is authorized to download software…in other word there is no trial version for Lumira….is this the case?

    Thank you.

    (0) 
    1. Ingo Hilgefort Post author

      Hello Cyrus,

      on the first item : For the user administrator you define the password when you configure the instance, so the password depends on what you configured as part of the process for setting up the instances.

      on items #2 : Correct – as described in the blog – you download SAP Lumira from Service Marketplace and that requires a user to logon to Service marketplace.

      regards

      Ingo Hilgefort. SAP

      (0) 
      1. Cyrus Minab

        Thank you Ingo your hint in regard to Admin password worked and I was able to uninstall Predictive Analysis on the remote desktop.

        In regard to the 2nd item, in my experience as developer the S user ID is obtained either through certification or through a SAP customer (I don’t have any experience working with SAP partner). In both these situations the ability to download software from Market place is not granted to the S user because of legal and license fees.

        I will follow Tammy’s suggestion and use sap.com/trylumira and will install Lumira on the remote desktop.

        (0) 
        1. Ingo Hilgefort Post author

          Hello Cyrus,

          the version of Lumira that is offered for download there is the personal edition and does not allow you to report on Universes.

          To obtain the software and keycode you will need a user for Service Marketplace. In case you don’t have a user yet you can simply request a user on the main page of service marketplace – service.sap.com.

          regards

          Ingo Hilgefort, SAP

          (0) 
      2. Cyrus Minab

        Hi Ingo,

        Thanks for reply and clarification in regard to trial Lumira.

        As I alluded previously the issue is not with having a S userid…I’ve few of them actually but none have authorization to download software and as mentioned due to legal and licensing issues SAP customers that I work with are unwilling to allow developers to download software from market place.

        (0) 
    1. Ingo Hilgefort Post author

      Hello Mikhail,

      I would suggest that – in case you want to provide feedback – that you actually provide constructive feedback.

      And to give you a feedback on your blunt statement :

      The performance of a relational Universe (UNX) compared to a BEx query (as you did not compare it to anything) – on top of a DSO object will be better than using a BEx query on top of a DSO object.

      Also assuming you would compared and size the Data Federator portion or the DSL portions in your BI4 system properly and not just using a default deployment with default configurations.

      regards

      Ingo Hilgefort, SAP

      (0) 
      1. Mikhail Budilov

        No, of course not default.

        Technologies based (or used) DataFederator is not recommended for use on millions rows and more.

        Maybe something changed in 4.1.  I must check first.

        (0) 
        1. Ingo Hilgefort Post author

          Hi Mikhail,

          as also mentioned on the other entry:

          first of all the question if millions or rows are possible is not a question of the BI tool in the first place, you first of all need to make sure your underlying system – in your case BW – is able to show those millions of rows for your users and is sized / configured to do so.

          In case we are talking about comparing data access to a DSO object using the Universe (UNX) or the BEx query, then the Universe access will be quicker (assuming DSO) because it goes directly to the DSO object instead of going through the OLAP engine.

          but the question what access to use or which tool to use is not something that you should decide based on the data volume – its a question of actual requirements.

          and on the data volume part you need to first of all ensure that those millions of rows you would like to see are possible in your BW system without any BI tool on top – just plain BW.

          regards

          Ingo Hilgefort, SAP

          (0) 
    2. Jonathan Haun

      Mikhail,

      Concerning the performance of the JCo Universe on BW: With Lumira you only see this performance hit when updating the Lumira dataset. Lumira uses an embedded Sybase IQ DB to store the data after downloading if from the BW system via the JCo UNX Universe. While you “might” have a slow experience downloading the data, once it’s in Lumira’s IQ DB, it should respond well.

      Concerning your “one million rows comment”: If you download more than about 50,000,000 +/- cells into Lumira, you will likely see some performance drops on standard hardware.

      (0) 
  4. Tony Tony

    Ingo,

    useful as usual -thanks.

    One issue – step10 – i do not see the SAP Netweaver BW Connection option – i can see all the

    rest -max db  HANA Etc.

    Tony

    (0) 
    1. Ingo Hilgefort Post author

      Hello Tony,

      you need to start the process of creating the connection from the Bi4 Server repository – not in a local project

      regards

      Ingo Hilgefort

      (0) 
      1. Tony Tony

        Thanks Ingo -it worked fine then.

        Is there any plan to allow a BICS Connector to Luminara ,without the need for the Data foundation and Business Layers ?

        Tony

        (0) 
  5. Yoav Yahav

    Getting a multiple data source UNX to run properly and to achieve great performance is more than doable but you have to ensure several steps before just running queries:

    1.    You have to configure your DFA properly

    2.    You have to create a dedicated APS which runs the data federation service and to adjust it’s Xmxg variable

    3.    You have to configure your SAP BI4 server properly as multi source universe uses the SAP BI4 server to run the combined SQL from all the seperate data bases

    4.Configure properly the UNX parameters

    See here for further details :

    (http://wiki.scn.sap.com/wiki/display/BOBJ/Sizing+the+Multi-source+Universe+and+the+Data+Federation+Administration+Tool)

    http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+BW+With+RFC+JCO+Connections+In+Information+Design+Tool

    http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+RFC+Connections+Mapping+Scalability+and+Load+Balancing

    https://websmp230.sap-ag.de/sap(bD1oZSZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3138353338393126

    https://websmp130.sap-ag.de/sap(bD1oZSZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3138393730333626

    (0) 

Leave a Reply