Skip to Content

Similar to my previous blogs on Crystal Reports, Analysis Office, Web Intelligence and SAP BusinessObjects Dashboards (Xcelsius) I would like to provide an overview on SAP BusinessObjects Analysis, OLAP Edition.

 

 

 

SAP BusinessObjects Analysis, OLAP Edition is part of the SAP BusinessObjects set of analytical BI clients. In addition SAP BusinessObjects Analysis, OLAP Edition is also the premium successor for the BEx Web REporting and for Voyager.

 

Before looking at more details I would like to remove a rumor that somehow keeps coming up in our customer base. There are no plans to consolidate SAP BusinessObjects Analysis, OLAP Edition and Web Intelligence into a single tool.

 

 

As you can see in the figure above SAP BusinessObjects Analysis, OLAP Edition and Web Intelligence are staying separate products adressing also different needs.

 

SAP BusinessObjects Analysis, OLAP Edition is a full multi-dimensional reporting tools allowing the user to analyse the data, slice and dice the information and fully leverage hierarchies and structures from the underlying source, such as SAP NetWeaver BW.

 

Web Intelligence is a self-service reporting tool focusing on the more casual user also providing rich functionality and meta-data on top of SAP NetWeaver BW, but not the same multi-dimensional and hierarchical reporting capabilities as SAP BusinessObjects Analysis, OLAP Edition.

 

SAP BusinessObjects Analysis, OLAP Edition is leveraging the connections shared with the other BI client products on the SAP BusinessObjects Enterprise platform and we described the workflow on how to create a connectionSAP Integration Update Part 1 – Crystal Reports for Enterprise and SAP NetWeaver BW.

 

Now lets assume we created the connection towards the SAP NetWeaver BW system and we are ready to start SAP BusinessObjects Analysis, OLAP Edition.

 

 

We are starting SAP BusinessObjects Analysis, OLAP Edition in the BI Launchpad (former InfoView) by calling the Applications menu.

 

 

 

After we selected the connection we are presented with the default view of the BEx query. As you can see in the image above SAP BusinessObjects Analysis, OLAP Edition consists of three main areas. The Data are provides yo uaccess to all the established connections and the provided meta-data per connection. The Layout allows you to define which of the characteristics and keyfigures are shown in the rows, columns, or are used as Filters in the Background. The third part of the screen space is the actual data set shown here as Analysis 1.

 

 

Like all the BI clients in the SAP BusinessObjects 4.0 suite, SAP BusinessObjects Analysis, OLAP Edition is also using the multi-tab approach for the menus. In the menu Analyze the user has access to calculations, Conditional formatting (new wording for Exceptions) and items like Filtering and Sorting….

 

 

…. the Insert Tab allows the user to add charts to the workbook….

 

 

… and the Display Tab provides access to menus for formatting the numbers.

 

Our worskheet shows….

 

our keyfigures broken down by Country and Region.

 

We can now right-click on the Keyfigures ….

 

and use the option to Filter by Members, which will bring up the list of members for the keyfigures and we can decide which keyfigures we would like to show.

 

When we open the menu on the charactersitic Country we also have the option to Filter the list of Countries based on the members but we also can use the option to Filter the list of Countries based on a measure…

 

 

 

… which is the new way of creating Conditions…

 

 

And as I mentioned early in this blog the Conditional Formatting, here an example where I selected the keyfigure Net Value and defined a conditional formatting.

 

 

One of my favorite features in SAP BusinessObjects Analysis, OLAP Edition in this context is the capability to activate a preview of the conditional formatting as shown below.

 

 

 

I hope I was able to give you a good introduction in this great new addition to our BI client portfolio and the counterpart fo Analysis, edition for Microsoft Office for the web environment – Analysis, OLAP Edition. In the next set of blogs we will take a look at how we can create our own charts, calculations, ranking, how we can leverage hierarchies and how we can leverage multiple data sources in a single worksheet.

 

in case you are a more visual person I recommend you take a look at my eposiode on itunes or Android.

To report this post you need to login first.

12 Comments

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

  1. Daniel Souza
    Hi Ingo,

    First of all many thanks for your messages. Is the SAP BusinessObjects Analysis, OLAP Edtion, available for ramp up or general usage? BTW, I couldn’t find it on the ramp-up nomination form.

    Much appreciated.

    Regards
    Daniel

    (0) 
      1. Mike Price
        Hi Ingo,

        In order to leverage the full functionality of BOBJ 4 OLAP, is an OLAP model and/or modeling tool required for a non-SAP environment, such as a Teradata stand alone data warehouse? Or will BOBJ 4 retain all the features and functions without an OLAP semantic layer?

        (0) 
        1. Ingo Hilgefort Post author
          Hi Mike,

          to which product are you referring ? are you in particular referring to SAP BusinessObjects Analysis, OLAP Edition ?

          If so then there needs to be an OLAP source – SAP NetWeaver BW or MSFT Analysis Services – available.

          regards
          Ingo Hilgefort

          (0) 
          1. Mike Price
            Hi Ingo,

            Thanks tons – Yes, in particular, the OLAP Edition, sorry I wasn’t clear. I have a client running Teradata, but not yet BW. I’ve advised them that they need an OLAP tool such as MS Analysis Services or Teradata’s OLAP Connector and Schema Workbench, etc., to leverage the OLAP Edition. I presume materialized views could be used, but an OLAP source would make it much more efficient and easier to maintain. Make sense to you? They’ll eventually go BW but that could take quite some time. Thanks so much for the help!

            (0) 
  2. Reinhold Exner
    Hi Ingo,

    you distinguished “Web Intelligence …, but not the same multi-dimensional and hierarchical reporting capabilities as SAP BusinessObjects Analysis, OLAP Edition.”

    What exactly is the difference and what is the consequence (reporting impact)? Example?

    Thank you.

    Kind regards
    Reinhold

    (0) 
    1. Ingo Hilgefort Post author
      Hello Melody,

      supported platforms can always be verified on Service Marketplace. Analysis, edition for OLAP can supports SAP BW and MS Analysis services.

      regards
      Ingo Hilgefort

      (0) 
  3. Sujal Shah

    Hi Ingo,

    We are currently on SAP BO 4.0 SP04. Kindly let me know if ther is any setting in OLAP Analysis to enable display of repeated key values for members from SAP BW/BEx query.

    I have already updated the display property of the BEx query to uncheck ‘Hide repeated Key values’ setting.

    Related link – http://help.sap.com/saphelp_nw70ehp3/helpdata/en/1e/99ea3bd7896f58e10000000a11402f/content.htm

    Thanks in advance for any assistance.

    Thanks and Regards,

    Sujal

    (0) 

Leave a Reply