The post will provide very detailed step-by-step instructions and you should easily be able to follow those. This post is very practical oriented and the functionality and capabilities of the SAP Business Objects Analysis edition for OLAP are being explained by using practice examples. I would recommend that you do set up your own environment for the SAP Business Objects Analysis edition for OLAP so that you can follow all steps right in your own installation of the software.
Here is the list of components that you would need:
This post is based on SAP BusinessObjects BI 4.0 Service Pack 04.
All of the SAP BusinessObjects software can be downloaded from the SAP Service Marketplace and you can receive temporary license keys from HTTP://SERVICE.SAP.COM/LICENSEKEYS.
In this post, we will introduce you to SAP BusinessObjects Analysis, edition for OLAP, and provide you with a quick overview of the product. In addition, we will review how SAP BusinessObjects Analysis, edition for OLAP fits into your overall Business Intelligence (BI) landscape and which type of user audience you want to target as users of SAP BusinessObjects Analysis, edition for OLAP, and for which type of users you might have to look for an alternative.
As you can see here the SAP Business Objects BI portfolio consists of three main categories:
Fig: SAP BusinessObjects BI Portfolio
The category Discovery and Analysis is about providing your business users the tools which they need to leverage the information, analyze the data, finding outliers and trends, and use simple to advanced data visualizations.
The following are the products that are in the category Discovery and Analysis
Fig: Discovery and Analysis
You can also recognize, based on the actual products in this category that this category provides you with products that allow your business users to use the corporate data and build their own analytical content, as all of the products in this category are designed for a business user without always having to rely on the IT department.
In the second category – Dashboards and Apps- the SAP BusinessObjects BI portfolio provides you with products that allow your IT department to create from simple dashboards to complex BI-driven applications.
In the category Dashboards and Apps you have two products:
Fig: Dashboards and Applications
in this category, it is about creating interactive data visualization and sharing the information from your corporate data warehouse by using interactive controls and compelling data visualizations. The products in this category – SAP Business Objects Design Studio and SAP Business Objects Dashboards – are targeted towards an IT audience, but the content created by your IT department will be consumed by a far larger audience.
In the last category – Reporting – You will find crystal Reports and Web Intelligence.
In this category it is about the classic reporting tools, allowing you, on the one hand, to create operational, layout focused reports using Crystal Reports and on the other hand to provide your business users with a reporting environment that allows them to edit and create reports based on a common set of well-defined meta-data. With Crystal Reports, you have a BI client used by your IT department and the content is – like with products in the category Dashboards and Apps – consumed by a larger audience. In the category Reporting, you also have Web Intelligence, which allows you to provide your business users a self-service driven reporting environment, so that your users are able to create and change their own reports.
In this section, we reviewed the different categories of the SAP BusinessObjects BI portfolio. In the next section, we will take a closer look at which role SAP BusinessObjects Analysis, edition for OLAP plays in our overall SAP landscape.
In previous sections we looked at the SAP Business Objects BI portfolio, so now we will look at SAP Business Objects Analysis, edition for OLAP in more detail. How SAP Business Objects Analysis, edition for OLAP is being positioned as part of the overall SAP Business Objects Analysis Suite.
[ Related Article: Advanced Features with SAP BO Analysis ]
Fig: SAP BusinessObjects Analysis Suite
In the SAP BusinessObjects Analysis Suite you have:
SAP BusinessObjects Analysis, edition for OLAP is being positioned as an ad-hoc OLAP client for a business analyst. In this context ad-hoc means that the business user does not have to rely on the IT department to create the workspaces or to prepare the content, but instead, the business user can use SAP BusinessObjects Analysis, edition for OLAP to create new content or change existing content and share the findings with other users.
Fig: SAP BusinessObjects Analysis
In the figure above we can see further details about SAP Business Objects Analysis, edition for OLAP. SAP Business Objects Analysis, edition for OLAP is the premium alternative for your current Business Explorer (BEx) Web Analyzer and allows you to provide your business analyst with a web-based environment for analyzing your corporate data.
When it comes to SAP NetWeaver BW, SAP Business Objects Analysis, edition for OLAP is able to leverage your existing investment in Business Explorer (BEx) queries and InfoProvider. We will discuss the details on how SAP Business Objects Analysis, edition for OLAP integrates with SAP NetWeaver BW
[ Related Article: SAP Analysis for OLAP ]
Fig: SAP Business Objects Design Studio
SAP Business Objects Design Studio is the premium alternative for the SAP Web application designer and allows your IT department centrally to create BI dashboards and BI applications. SAP Business Objects Design Studio is part of the SAP SAP Business Objects Analysis Suite and completes the offering giving you three products for your different sets of requirements and user audience.
As we now better understand which role SAP Business Objects Analysis, edition for OLAP plays in the BI portfolio, we will learn more about the target user audience for the product in the next section.
So far we have looked at SAP BusinessObjects Analysis, edition for OLAP is one BI client in the overall BI portfolio, but who is the main audience for this product? you can see that some of the BI clients in the SAP BusinessObjects BI portfolio are designed for a business user audience and some of them are designed for IT to create the initial content. This distinction between the business user and the IT department being the main target group for creating the content is very important to understand.
Fig: Who creates the content?
The image above shows that SAP BusinessObjects Analysis – which includes SAP BusinessObjects Analysis, edition for Microsoft Office, and SAP BusinessObjects Analysis, edition for OLAP – is designed for the business user without having to rely on your IT department to be part of the process to create content. This does not mean that you cannot use the IT department as part of the content creation process, in fact we have seen several customers creating workspaces with SAP BusinessObjects Analysis, edition for OLAP in a central IT team, and here the team is creating corporate standard workspaces for a larger audience, but your users do not always have to rely on the IT department.
SAP BusinessObjects Analysis, edition for OLAP is designed as an ad-hoc, self-service multi-dimensional client allowing your business users to access the corporate data, analyze the information, and share their findings.
Fig: Who consumes the content?
Here you can see that SAP Business Objects Analysis is targeting three out of four user groups: Senior Management (sometimes also referred to as Line of Business), Business Analyst, and Individual Contributor.
For the individual Contributor, the recommendation is to use SAP Business Objects Analysis, edition for Microsoft Office and not SAP Business Objects Analysis, edition for OLAP as the workflows inside the Microsoft Office Environment are better suited for the Individual Contributor. SAP Business Objects Analysis, edition for OLAP has been designed as a self-service multi-dimensional analytical client for your business analyst (sometimes also referred to as Power User) and your senior Management/Line of business management.
Fig: Business Analyst
In Figure, you can see details on how a Business Analyst would be able to leverage SAP BusinessObjects Analysis, edition for OLAP. SAP BusinessObjects Analysis, edition for OLAP and SAP BusinessObjects Analysis, edition for Microsoft Office would allow the Business Analyst to use existing workbooks and customize them to his / her needs, but it also provides the capability to create new workbooks without having to rely on IT personal. The Business Analyst can also use SAP BusinessObjects Analysis, edition for Microsoft Office and SAP BusinessObjects Analysis, edition for OLAP to share their findings by either creating workbooks for the Senior Management or by using the functionality of Analysis Views and in that way share the findings with a much larger audience and products like Web Intelligence and Crystal Reports for Enterprise.
Fig: Senior Management
The figure shows how the Senior Management can use SAP BusinessObjects Analysis, edition for Microsoft Office, or SAP BusinessObjects Analysis, edition for OLAP. In the same way as the Business Analyst, the Senior Management is able to analyze the information and share their findings without having to wait for the IT department to create a new workbook using the self-service aspect of SAP BusinessObjects Analysis. In addition aspects such as the ability to create presentations with live data using SAP BusinessObjects Analysis, edition for Microsoft Office and the integration with the planning functionality of SAP NetWeaver BW are now very relevant for this audience.
Fig: Where is the content consumed?
So far we looked at the different persona creating the content and we looked at the persona consuming the content but sometimes it is also an important requirement that a typical content type has to be consumed either on a desktop, or in a web-based client, or on a mobile device.
The figure shows exactly this distinction and you can see that SAP BusinessObjects Analysis, edition for OLAP is a web-based client without the option for desktop or mobile-based consumption. In case desktop-based consumption becomes an important requirement then you should look at using SAP BusinessObjects Analysis, edition for Microsoft Office for those scenarios in combination with SAP BusinessObjects Analysis, edition for OLAP. For mobile consumption, the recommendation is to use SAP BusinessObjects Design Studio and create for your users the mobile experience.
In addition to understanding who the main target audience is for SAP BusinessObjects Analysis, edition for OLAP, it is also important to understand the strength and weaknesses of the product.
This matrix shows a comparison of the products of the SAP BusinessObjects BI portfolio compared along with several capabilities. Focusing on SAP BusinessObjects Analysis, edition for OLAP, you can see the strengths are clearly in the hierarchical reporting and self-service aspects and the weaknesses are in the area of highly formatted reporting and more layout-driven reporting. The strength and
weaknesses of SAP BusinessObjects Analysis, edition for OLAP should not surprise us, as SAP BusinessObjects Analysis, edition for OLAP is a multi-dimensional analytical BI client focusing on the self-service aspect and on the strong support of hierarchical capabilities and less on layout and print.
Fig: Comparison Matrix
Explore SAP BO Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!
I am Ruchitha, working as a content writer for MindMajix technologies. My writings focus on the latest technical software, tutorials, and innovations. I am also into research about AI and Neuromarketing. I am a media post-graduate from BCU – Birmingham, UK. Before, my writings focused on business articles on digital marketing and social media. You can connect with me on LinkedIn.