Skip to Content

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 and in the second part you learned how you can create a relational Universe (UNX) based on your SAP NetWeaver BW InfoProvider.

Today we will focus on using SAP Lumira in combination with the previously created Universe and how we then can share the data with SAP BusinessObjects Explorer and SAP Lumira Cloud.

  1. Start SAP Lumira by following the menu Start Programs • SAP Business Intelligence • SAP Lumira • SAP Lumira.
  2. Select the menu File New.

    LUMIRA_BLOG_3_001.jpg

  3. Select the option Download from a Universe.
  4. Click Next.

    LUMIRA_BLOG_3_002.jpg

  5. Logon to the SAP BusinessObjects BI system with the following details:

    CMS Name : SBOP4
    Authentication Type: SAP
    User Name : BWH~001/DEMO
    Password : Welcome!

  6. Click Connect.

    LUMIRA_BLOG_3_003.jpg

  7. You can now select the Universe. In our example it’s the Universe with the name BW_BUSINESS_LAYER.
  8. Click Next.

    LUMIRA_BLOG_3_004.jpg

  9. You can now activate the checkboxes next to the objects that you would like to use. In our example we are going to use:

    Characteristics :

    • Country
    • GIS-Region
    • Sold-To-Party
    • Product Group
    • Product Category
    • Product


Measures:

    • Net Value
    • Costs

If you look at the screenshot above you will notice that the description values – such as the short, medium, and long text – are Details in the Universe (green symbol). The dimension objects (blue symbol) represent the key values. for our example I will use the detail objects (Heading) for the characteristics.

  1. Activate the option Preview and Select Data.

    LUMIRA_BLOG_3_005.jpg

  2. Click Create.

    LUMIRA_BLOG_3_006.jpg

  3. Before we continue, please ensure that all proxy settings have been removed from the menu File • Preferences Network
  4. Click Create.
  5. Add the measure Net Value to the Primary Value under Measures.
  6. Click on the Options for dimension Country.
  7. Select the menu Create a geographic hierarchy • by Names.

LUMIRA_BLOG_3_007.jpg

  1. Use dimension Country for the Country level and dimension GIS-Region for the Region level.

    LUMIRA_BLOG_3_008.jpg

  2. Click Confirm and click OK to confirm the assignments for now.
  3. Now set the chart type to a Geo Pie Chart.

    LUMIRA_BLOG_3_009.jpg

  4. Add your newly created geographic hierarchy to the Geo Features attribute.
  5. Add dimension Product Category to the Geo Feature Analysis attribute.

    LUMIRA_BLOG_3_010.jpg

  6. You can zoom into the map now to see the details.
  7. Navigate to the dimension Country on the left hand side and click on the options.

    LUMIRA_BLOG_3_011.jpg

  8. Select the menu option The filter is…
  9. Select the entry United States and click Add.
  10. Close the dialog screen.
  11. Now set the level of the map to Region on the Geo Features attribute.

    LUMIRA_BLOG_3_012.jpg

  12. Looks like we are selling a lot more Laptops in Kentucky than anywhere else. So we are looking to share the information now.
  13. Click Save (bottom right)
  14. Click on Share in the toolbar.

    LUMIRA_BLOG_3_013.jpg

  15. You can now publish the data set to HANA or Explorer, you can publish the data to Lumira Cloud, to Streamwork or send it via eMail.
  16. Click on Publish Dataset to Explorer.
    LUMIRA_BLOG_3_014.jpg

  17. Enter your credentials:

    CMS Name : SBOP4
    Authentication Type: SAP
    User Name : BWH~001/DEMO
    Password : Welcome!

  18. Select a folder for storage, for example the folder Demo Content.
  19. Click Publish.
  20. Now select the menu Start • Programs SAP Business Intelligence SAP BusinessObjects BI Platform 4 SAP BusinessObjects BI platform Java BI Launch Pad.
  21. Logon with your SAP credentials to the SAP System BWH with client 001.
  22. Click on Documents.
  23. Click on Folders.
  24. Navigate to the folder where you stored the data.
  25. In the folder you will find a Explorer Information Space and the name is based on the Universe that we used with SAP Lumira and a spreadsheet with the data that we exported.
  26. You can also go to the menu Applications Explorer and the Information Space will be listed.
  27. Navigate back to SAP Lumira.
  28. This time use the option Publish to Lumira Cloud.

    LUMIRA_BLOG_3_015.jpg

  29. You will be asked to logon to SAP Lumira Cloud. In case you don’t have credentials yet you can go to https://cloud.saplumira.com/ and sign up for free.
  30. Enter the user and password for SAP Lumira Cloud.
  31. Click Connect.

    LUMIRA_BLOG_3_016.jpg

  32. The default name of the data set is based on the underlying Universe.
  33. Click Publish.
  34. Now navigate to SAP Lumira Cloud – https://cloud.saplumira.com/ and logon with your account.

    LUMIRA_BLOG_3_017.jpg

  35. The data set has been published to Lumira Cloud and you can now explore the information with a click on the Options (right hand side) and selecting the menu Explore.

    LUMIRA_BLOG_3_018.jpg

At this point we used the data from SAP BW with SAP Lumira, published it to Explorer and SAP Lumira Cloud.

Why are Explorer and Lumira Cloud relevant ? – because by using Explorer and Lumira Cloud you can share the information via mobile devices.

In the next blog we will take a look at the new feature of story boards in SAP Lumira using the data from SAP BW and we will discuss the limitations of a relational Universe with SAP NetWeaver BW.

Here are some additional resources:

To report this post you need to login first.

4 Comments

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

    1. Mike Howles

      I have the same question.  Piping a cube thru a UNX seems unnecessary additional complexity and overhead.  BICS would be a nice and logical addition I’m hoping for.

      (0) 

Leave a Reply