In SAP BUSINESSOBJECTS ANALYSIS, EDITION FOR OLAP you have the ability to save the navigation state of a particular cross tab or chart as an Analysis View and this Analysis View can then be used by Crystal Reports for Enterprise, Web Intelligence, or Analysis, edition for Microsoft Office. In the next few steps, we will save our analysis in the form of an Analysis View and use the view in the other BI clients.
1.Open the BI Launchpad via Start > All Programs > SAP BUSINESSOBJECTS BI Platform 4.0 > SAP BusinessObjects BI Platform > SAP BusinessObjects BI Platform Java BI Launchpad.
2.Logon with your SAP credentials and the SAP authentication for your SAP NetWeaver BW system.
3.Select the menu Applications.
4.Select Analysis, Edition for OLAP. In the next step, you are presented with the list of available OLAP Connections.
5.Select the connection we created previously pointing to your SAP NETWEAVER BW system.
6.Click Next. You are now receiving the list of available BEx queries.
7.Select the BEx Query from section BEX QUERIES.
8.Remove all items from the Rows.
9.Add characteristic Product to the Rows.
10.Select the element Key Figures in the Columns.
11.Drag the element Key Figures to the Background
12.Select the Key Figure Net Value.
14.Add characteristic Calendar Year / Month to the Columns.
15.Use a right-click on characteristic Calendar Year / Month in the columns.
16.Select the menu Filter > by Member.
17.Select the twelve month for the current year.
19.Select the cross tab in the workspace.
20.Navigate to the toolbar and click on the button Export .
21. Select the option Analysis View.
22. Enter a Name and select a folder
23. Click Save.
Saving Analysis Views
Analysis Views are created to give users access to a subset of data derived from an Analysis workspace and a multidimensional dataset. This new capability provides a means of accessing a specific arrangement of cube data within the Web Intelligence application and outside of the Analysis workspace.
An Analysis View is a saved navigation state of an analysis that is stored in the SAP BusinessObjects BI platform. Analysis Views can be used to communicate findings and share analyses with other SAP BusinessObjects applications, such as Crystal Reports for Enterprise.
It is saved based on a single component of your workspace, so ensure you are selecting the right component before saving the Analysis View.
We saved our Analysis View using SAP BusinessObjects Analysis, edition for OLAP and we will now use it with the other BI clients. We will start with SAP BusinessObjects Analysis, edition for Microsoft Office.
1.Start SAP BusinessObjects Analysis, edition for Microsoft Office with Microsoft Excel via the menu path: Start > All Programs > SAP BusinessObjects > Analysis for Microsoft Excel.
Select the Insert > Analysis View from the Analysis Ribbon (see Figure 5.90).
Figure 5.90 Insert Analysis View
3. You will be asked to logon to your SAP BusinessObjects BI server. Logon with your SAP credentials using the SAP authentication.
5. You are presented with the folder structure from your SAP BusinessObjects BI4 server and you can select the Analysis View we saved previously (see Figure 5.91).
Figure 5.91 Selecting Analysis View
6. Select the Analysis View.
7. Click OK (see Figure 5.92).
Figure 5.92 Cross tab in Analysis, edition for Microsoft Office
SAP BusinessObjects Analysis, edition for Microsoft Office is opening the Analysis View and uses the information about items such as Rows, Columns, and Filters. As you will notice, SAP BusinessObjects Analysis, edition for Microsoft Office created a cross tab in Microsoft Excel with the characteristic Product in the Rows, Calendar Year / Month in the Columns and the data is showing the key figure Net Value for the twelve month of the current year – like the Analysis View was defined in the SAP BusinessObjects Analysis, edition for OLAP.
You can also use the Analysis View with Crystal Reports for Enterprise and Web Intelligence, but Crystal Reports for Enterprise and Web Intelligence will not leverage the layout information of the cross tab to generate a report. Instead, Crystal Reports for Enterprise and Web Intelligence will only use the information about the Rows and Columns from the Analysis View to make a proposal for the elements that will be included into the Result Objects for the query panel when building a new report.
In this section, we reviewed the ability to share an Analysis View with the other BI clients. In the next section, we will learn more about some important deployment and configuration topics.
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.