Online Safety Community

Creating your very first workspace - SAP BO

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.

  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 (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.

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.

Views: 66

Comment

You need to be a member of Online Safety Community to add comments!

Join Online Safety Community

Take our poll!

Take our poll!

Latest Activity

Pro-Sapien Software posted a blog post

Pro-Sapien partners with LMS365 to offer integrated Learning Management on Office 365

Pro-Sapien Software, specialist providers of EHS software on Office 365, has announced its partnership with fellow Microsoft ISV ELEARNINGFORCE International to offer Training Management alongside Pro-Sapien’s HSEQ Innovate.ELEARNINGFORCE’s product LMS365 empowers people through learning management fit for the Modern Digital Workplace. Managers can create, distribute, and track learning courses; employees can manage their own learning schedule with progress trackers, notifications and…See More
16 hours ago
Nakul Pratap posted a blog post

Food safety Tips During an EMERGENCY

In an Emergency. Find out how to keep food safe during and after an emergency, such as a flood, fire, national disaster, or the loss of power.Here tips for Prepare your pantry for a disaster, tips for feeding babies during an emergency.Read more...See More
16 hours ago
Training Doyens posted an event
Thumbnail

Online Webinar on the Power of Trust for Your Workplace - and for Your Reputation – Training Doyens at 26468 E Walker Dr, Aurora, Colorado 80016

December 18, 2018 from 1pm to 2:30pm
In business trust is all about character and integrity and it is the intangible asset that is critical to your short and long term success with your workforce and to your client. Join our upcoming webinar to learn how to build a good reputation at work and maintain the power behind an engaged and empowered workforce.The webinar covers the following key areas:Identify the…See More
17 hours ago
Mark Nilson posted events
17 hours ago

Forum

AI Machine Learning In Businesses How wоuld уоu define a small buѕinеѕѕ, thе number оf реrѕоnеl, thе size оf the budget, оr ѕаlеѕ?

How wоuld уоu define a small buѕinеѕѕ, thе number оf реrѕоnеl, thе size оf the budget, оr ѕаlеѕ?However you define уоur оwn ѕmаll business, it tоо can tаkе advantage оf thе AI/ …Continue

Tags: elite, crest, technologies, intelligence, Artificial

Started by emmablisa on Monday.

Distracted Driving 1 Reply

****WARNING**** Despite the fact that this is a life event portrayed by actors, it's graphic. This video should be part of…Continue

Tags: texting, fatality, safety, car, driving

Started by Wendy. Last reply by Jen McDade Dec 5.

Safety update: OSHA announces fit-test procedures 1 Reply

Fabricators as well as other workers may be required to use respirators to protect themselves from inhaling fumes, particles, or dust when performing cutting, grinding, welding, coating, or painting,…Continue

Tags: online, training, Safety, workplace, PPE

Started by Safety Training International. Last reply by Jen McDade Dec 4.

Proper guarding protects workers: Six steps to focusing on your employees' needs 1 Reply

When people think of machine guarding, usually they think of devices to protect people from the moving parts on machinery.When people think of machine guarding, usually they think of devices to…Continue

Tags: training, compliance, PPE, Training, Safety

Started by Safety Training International. Last reply by Jen McDade Dec 4.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service