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.
- 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.
- Logon with your SAP credentials and the SAP authentication for your SAP NetWeaver BW system.
- Select the menu Applications.
- Select Analysis, Edition for OLAP. In the next step you are presented with the list of available OLAP Connections (see Figure 4.7).
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
- The DATA panel provides you with the access to the connections and the available elements of your underlying data source as well as the properties for the used elements.
- The LAYOUT panel allows you to define the layout of your cross tab by using simple drag and drop navigations and defining the elements in the Rows, Columns, and Background area.
- The Cross tab area in your worksheet presents the actual data in the form of a cross tab or a chart to the end-user.
- You can have multiple sheets in a single workspace and you can navigate between the sheets by using the navigation below the cross tab.
- The menu tabs Analyze, Insert, and Display give you access to all the features and functions of SAP BusinessObjects Analysis, edition for OLAP.
- The menus on the far left give you access to the save and export capabilities.
Sheets and Components
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:
- All Key Figures are listed together in a folder called Key Figures.
- All characteristics are visible in the data panel and each characteristic has a set of elements. For example characteristic Country is shown here with the element Country for the characteristic itself, but also the available hierarchies – here Country Hierarchy 1 – are available.
- Display Attributes for the characteristics are shown below the characteristic itself – here shown for Sales Organization.
Subscribe to our youtube channel to get new updates..!
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):
- Characteristic Calendar Year and Region in the Rows.
- All Measures in the Columns.
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.