This has been a common question for Lumira – can it connect to BW?  In previous versions this was not supported unless you were using BW on HANA.

With SP12, SAP Lumira now supports connectivity against a BW Universe (BI4x .UNX).  First you need to create a BW Universe in the IDT.  You go to connections, log on to the BI4x platform, and select your BW Universe. 

I am using BW data from SAP Solution Manager Incident Management.

/wp-content/uploads/2013/10/1filter_292487.png

In the above shows how I am filtering on date created

/wp-content/uploads/2013/10/2timehierarchy_292488.png

In the above you see I am connecting using a .UNX file and I created a time hierarchy to separate the date by Year, Quarter, Month

/wp-content/uploads/2013/10/3storyboardincidents_292489.png

Then I create a storyboard of the various views of Incident Management – incidents by month, component, and message status.  I am using the Message Component as an input control to select the various incidents.

/wp-content/uploads/2013/10/4clonechangefiltertostatus_292493.png

I can “clone” the storyboard and change the input controls to check Message status.

/wp-content/uploads/2013/10/5sharecloud_292494.png

I publish the dataset to Lumira Cloud, where I can start interacting with the data there or using SAP BusinessObjects Mobile

/wp-content/uploads/2013/10/6cloudexplore_292496.png

Above shows SolMan BW Universe data in the Lumira Cloud, and I can start exploring/analyzing visualizations there.

What are some of the downsides of connecting to the BW Universe?  You lose the BW hierarchy data and you need to filter the data effectively before you start building the visualization.

There is a step-by-step video on how to connect to BW here provided by SAP Lumira University.

Related Links:

Ashish Morzaria – #SAPTechEd 2013 Speaker of the Week – Lumira will be covered at TechEd

Meet the ASUG TechEd Speaker Dennis Scoville – Empowered Self-Service BI with SAP HANA and SAP Lumira

#DataGeek Weekly Update – SAP Lumira SP12 and Breaking Bad
Try Lumira Site

Official Product Tutorials – SAP BusinessObjects Lumira – now updated for SP12

Also SAP released this video featuring Lumira SP12 features:

To report this post you need to login first.

9 Comments

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

  1. Billy Warring

    Lumira just moved up on my priority list of things to start working on, I assume you can obtain any BW cube info on a Solution Manager; not just the ITSM?

    (0) 
  2. Suseelan Hari

    Hi Tammy,

    Good Day!

    Nice analysis! I appreciate.

    Especially I like this blog because you have compared with “Incident Management” I like this very very much! Keep rocking 🙂

    Keep sharing new things. Have a nice day!

    Regards,

    Hari Suseelan

    (0) 
  3. MATTHEW BROWN

    Hi Tammy –

    I’m evaluating “tableau” against SAP Lumira.  Both products seem very similar, but I see that tableau can interpret our BW hierarchies very well.  It doesn’t look like Lumira can.

    I see Lumira can only access UNX, so is a 3rd party application making more sense of the SAP BW back end then products that SAP is producing???  say it ain’t so!

    Thanks,

    Matt

    (0) 
    1. Henry Banks

      Hi Matt,

      Yes, unfortunately, this is the current state of play. This feature has been much requested during the past year.

      If you take a look at our roadmap here: https://websmp108.sap-ag.de/~sapidb/011000358700000212382013E.pdf   .. You’ll see that MDX .unv are on the mid-term roadmap.  and that ‘direct access’ (i.e. BICS) is on the longer-term goals.

      I tested a preview of this internally recently, and yes, it handles hierarchies pretty well. That said, I don’t have any visibility of an expected timelines, nor is one being communicated internally at this time.

      regards,

      H

      (0) 
      1. MATTHEW BROWN

        Thanks for the update Henry.  There are some ambiguities around the future direction “greater visibility across organization”.  To me, this implies Launch Pad / Mobile integration (not just with cloud).  I could be reading that incorrectly, but we have a division evaluating Tableau.  I think feature for feature it’s probably ahead of Lumira at this point, but Launch Pad integration would level the playing field since our security model would stay in tact, and we wouldn’t be tied to desktops…

        (0) 

Leave a Reply