Discover SAP BusinessObjects Analysis — the New BEx Analyzer

  • by Ingo Hilgefort, Vice President of Product Management, Visual BI Solutions
  • November 1, 2010
Find out how you can use the newly released SAP BusinessObjects Analysis, edition for Microsoft Office — formerly known as project Pioneer — as part of your overall SAP BusinessObjects BI landscape. Uncover which BEx applications SAP BusinessObjects Analysis replaces and discover what functionality will be available with its initial release as part of SAP BusinessObjects BI 4.0.
Key Concept
SAP BusinessObjects Analysis, edition for Microsoft Office is the successor to SAP BEx Analyzer. It allows you to provide your power users with a new user experience for analyzing your corporate data from SAP NetWeaver BW. Furthermore, the Web edition of SAP BusinessObjects Analysis is planned to replace the current BEx Web Reporting option.

When the teams from SAP and Business Objects came together, they had one important goal in mind (especially for the Microsoft Office edition) — to reach more users than just the business analyst. With SAP BusinessObjects Analysis, edition for Microsoft Office the teams are trying to design the product for the information consumer as well.

I will first clarify the technical prerequisites for the use of SAP BusinessObjects Analysis, edition for Microsoft Office. Then I will take a look at the type of user for which the application fits well.

I will then review how SAP BusinessObjects Analysis, edition for Microsoft Office uses your existing BEx queries and supports the existing metadata from your SAP NetWeaver BW system. In addition, I will provide you with a list of functionality for which I compare SAP BusinessObjects Analysis, edition for Microsoft Office with BEx Analyzer.

Ingo Hilgefort

Ingo Hilgefort started his career in 1999 with Seagate Software/Crystal Decisions as a trainer and consultant. He moved to Walldorf for Crystal Decisions at the end of 2000, and worked with the SAP NetWeaver BW development team integrating Crystal Reports with SAP NetWeaver BW. He then relocated to Vancouver in 2004, and worked as a product manager/program manager (in engineering) on the integration of BusinessObjects products with SAP products. Ingo's focus is now on the integration of the SAP BusinessObjects BI suite with  SAP landscapes, such as SAP BW and SAP BW on SAP HANA, focusing on end-to-end integration scenarios. In addition to his experience as a product manager and in his engineering roles, Ingo has been involved in architecting and delivering deployments of SAP BusinessObjects software in combination with SAP software for a number of global customers, and has been recognized by the SAP Community as an SAP Mentor for SAP BusinessObjects- and SAP integration-related topics. Currently, Ingo is the Vice President of Product Management and Product Strategy at Visual BI Solutions, working on extensions to SAP’s product offering such as SAP BusinessObjects Design Studio and SAP Lumira. You may follow him on Twitter at @ihilgefort.

See more by this author


Comments

1/14/2016 10:19:46 AM
Abhi Singh

Ned - Thanks for clarifying. The youtube video is helpful in understanding how to connect HANA CDS views to BW. It seems with embedded BW we can now directly create BEx queries on top of CDS views.

My understanding by attending TechEd session BA214 – Reporting with SAP S/4HANA:
From Operational Reporting to Insight-to-
Action is that S4 HANA 1511 and beyond will use ABAP based CDS views for Operational reporting. I think it's now known as S/4 HANA Analytics (formerly HANA Live)
1/14/2016 8:26:43 AM
Author, Ned Falk

Thanks for your nice comments. To answer your questions:

1. How hard is developing Virtual and Transient InfoProviders on top of HANA live CDS views in S4 HANA system from an effort standpoint?

To answer question #1, I think you are mixing up terms. I don’t think HANA Live uses CDS views, I think they are Calculation views. CDS views is a new thing, but creating BW objects (better to use the newest Open ODS view for virtual access) on HANA calculation views is easy. You can access the new CDS views directly from the reporting tools (like a query) I think. Go here: https://www.youtube.com/watch?v=5L62xku7BbQ.


2. Are they a must have or can Bex query designer also directly access CDS-based HANA Live views?

NO (but I have not used CDS views live yet).


3. Can embedded BW address data warehousing scenarios such as Slowly Changing Dimensions [be used] for history preservation?

If you use these features you may need to persist the data--then you are making the embedded BW a real BW, not a fake pass thru. But it may be OK to do this for limited uses.


4. With S4 HANA, would it be possible to bypass the embedded BW layer and access the SQL run-time HANA views directly from BOBJ tools? As you know, in the past there have been challenges with WebI and Lumira integration with BW. I am trying to see if we can still bypass the BW layer in S4.

Yes, SAP HANA Live normally is used direct, but the main big premise of this article was to get access to the Query Designer so that the business people can use the tool they know and not mess with the views!

Ned
1/13/2016 10:38:43 PM
Abhi Singh

Ned - Thanks for sharing this insightful article. Very helpful.

I have a few follow-up questions:
1) How hard is developing Virtual and Transient InfoProviders on top of HANA live CDS views in S4 HANA system from an effort standpoint? Are they a must have or can Bex query designer also directly access CDS based HANA Live views?
2) Can embedded BW address data warehousing scenarios such as Slowly Changing Dimensions for history preservation?
3) With S4 HANA, would it be possible to bypass the embedded BW layer and access the SQL run-time HANA views directly from BOBJ tools. As you know, in the past there have been challenges with WebI and Lumira integration with BW. I am trying to see if we can still bypass the BW layer in S4.

Thanks again.

Abhi

Please log in to post a comment.

To learn more about subscription access to premium content, click here.