Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn how to use SAP Lumira SP12 with SAP NetWeaver BW - Part 2

IngoH
Active Contributor
‎10-10-2013 12:35 AM

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 • Programs • SAP 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.

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

… you can use “Register later” for now.

When the installation is finished…

.. 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.

  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.

  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.

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

  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.

  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.

  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.

  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

  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:


24 Comments
Labels in this area
Popular Blog Posts