In this section, we will now explore SAP BusinessObjects Analysis, edition for OLAP and create our very first workspace. After we learned about the different areas of SAP BUSINESS OBJECTS ANALYSIS, EDITION FOR OLAP, we will also review how the different elements from a BEx query are being mapped to SAP BusinessObjects Analysis, edition for OLAP.
Figure 4.7 OLAP Connections
5. Select the connection that we have created previously pointing to your SAP NetWeaver BW system.
6. Click Next. You are now receiving the list of available BEx queries. You can also use tab Find to search for specific queries (see Figure 4.8)
Figure 4.8 List of BEx Queries
7.Select the BEx Query you created and click OK
SAP BusinessObjects Analysis, edition for OLAP allows you to have multiple sheets in a single workspace, but you can only have four components (charts, cross tabs) on a single sheet.
Before, starting to use SAP BusinessObjects Analysis, edition for OLAP, let’s explore where the information defined in our BEx query, appears in our workspace.
Figure 4.9 Data Panel
The Data Panel (see Figure 4.9) provides you access to the underlying meta-data from the used BEx query. In the example shown above, you can see that:
One of the not so obvious items is the different display options such as the key, short text, medium text, or long text. The option to switch between these display settings is part of the context menu (right mouse click) of the characteristic when displayed in the crosstab (see Figure 4.10).
Figure 4.10 Menu – Display as
After we identified all the necessary meta-data from our BEx query, we are now ready for our first step in SAP BusinessObjects Analysis, edition for OLAP.
In the next couple of steps, we use some of the basic functionality of SAP BusinessObjects Analysis, edition for OLAP. We created a new workspace based on the BEx query which was created previously, so our workbook shows (see Figure 4.11):
Figure 4.11 Analysis Workspace
1. Select characteristic Calendar Year in the Rows.
2. Drag and drop Calendar Year to an empty area to remove it from the Rows. You can also use a right-click and select the menu Remove (see Figure 4.12)
Figure 4.12 Analysis Workspace Navigation
3. Now select Country in the Data Panel and open the list of available objects (see Figure 4.13)
Figure 4.13 Characteristic Country
4. Now drag Country on top of Region in the Rows, so that it replaces Region (see Figure 4.14)
Figure 4.14 Exchanging characteristics
6. Select Country in the Rows and use a right-click.
7. Select the menu Display as to switch between the different options of showing the key or text for characteristic Country.
8. Select the option Text (see Figure 4.15).
Figure 4.15 Analysis Workspace
8. Select the characteristic Region in the Data Panel.
9. Drag and drop Region to the Rows, so that your cross tab displays first the Countries, and then the Regions.
In addition to the simple drag and drop navigations you also have the menu options Move to, Move Before, Move After, and Swap with, which allows you to select a characteristic in the Layout Panel and move to the Rows, or Columns, or move before or after another characteristic, or swap it with another characteristic.
In this section, we have learned the basic navigation steps in SAP Business Objects Analysis, edition for OLAP and where the meta-data from our existing BEx queries appears. In the next section we will learn about different options to filter the data.
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.