When you click the New button, you will be prompted to select a data source. You can select from the dropdown list to view all the connections or the connections pointing to Cube/InfoProvider or to Query/Query View to connect to BW OLAP source.

2 8

When you select “All” from the dropdown list, you can see −

OLAP Connections
Cube/InfoProvider
Query/QueryView

Click the Next button and you will see a list of all the Modeling Views/InfoCubes in the source system that are pointed using this OLAP connection.

3 8

Navigate to Folders tab at the top. You can also perform a search with the name of InfoCube/Modeling View in the source system.

Select InfoCube from the source system and click the OK button.

4 8

When you click the OK button, all the measures and dimension values will be added to metadata explorer under the new workspace. You can see the name of InfoCube/Modeling View under Data tab in the Task panel.

You can drag different measures and dimension values to the Layout panel to create a Crosstab and Chart in the Analysis pane.

5 8

Adding Chart to WS

To add a chart to workspace, you have to navigate to the Insert tab at the top. You have different chart options under Insert. When you have multiple analysis on the sheet, each chart points to a specific analysis in the workspace.

Adding Chart

In the analysis window, you have to select the component that you want the chart to be linked to → Navigate to Insert tab and select the Chart from the available charts.

This will add the chart as a sub-analysis, linked to the component that you selected. The added chart is placed below or to the right of the existing components on the sheet.

6 6

Following chart types are available under the Insert tab in the tool −

Column Chart Family
Multiline Chart
Multi Pie Chart
Bar Chart
Other Chart

7 4

Adding Crosstab to WS

In Analysis Edition for OLAP, you can add a crosstab as Analysis or Sub-analysis. To add a crosstab as sub-analysis, navigate to the “Insert” tab at the top of the screen.

8 3

This adds a crosstab as a sub-analysis, linked to the component that you selected. The crosstab is added to the right or below an existing component.

When you add it as sub-analysis, it is based on the existing object in the workspace. When you add it as a new analysis, it adds a blank crosstab below or right of an existing object.

9 2

How to Copy an Existing Crosstab or Chart?

It is also possible to copy an existing crosstab or chart. To copy an object, you have to select the object by clicking the Analysis panel. Later, click the Copy button at the top.

10 1

When the object is copied, you can paste this to a new sheet. To paste the object, you can use the paste button at the top of the screen. You can also copy the object on the right or below an existing object.

11 1

If you want to delete the component, you can click the cross button on the top right corner of the object.

12 1

Saving a Workspace

You can also save the workspace to BI platform repository. You can choose to save your changes to the existing workspace, or to save the modified workspace as a new workspace in the repository.

13 1

In the next window, you have to select the folder where you want to save the Workspace. Enter the name of the Workspace and click the Save button.

14 1

Note − In Analysis Edition for OLAP, if a workspace is idle for several minutes, a copy of the workspace is automatically saved to your Favorites folder before the session is terminated.

When the session is returned before it is terminated, the auto-save cycle is reset, and the workspace is auto-saved again the next time your workspace becomes idle for several minutes.

So, this brings us to the end of blog. This Tecklearn ‘How to create a Workspace in SAP Business Objects’ blog helps you with commonly asked questions if you are looking out for a job in SAP Business Object and SAP Domain. If you wish to learn SAP Business Object and build a career in SAP domain, then check out our interactive, SAP Business Objects Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-business-objects-certification-training/

SAP Business Objects Certification Training

About the Course

Business intelligence tools and features are used by multiple companies and firm for the effective results their large flow of data. The completion of this SAP Business Objects training will be helpful in landing yourself a good paying job. With this Business Objects online training, you will gain considerable proficiency in SAP BO architecture, data warehousing, use of Information design tool, create multiple reports and the implementation of Web intelligence and Efficiency in solving the issues of data sources and Crystal dashboard design.

Why Should you take SAP Business Objects Training?

The Average salary of SAP Business Objects Business Intelligence Analyst is $94,000 per annum – PayScale.com
Business Objects is an enterprise reporting tool and Scalability is one of the primary reasons large corporations choose Business Objects for their BI needs.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Introduction to Business Objects

History and Version of Business Object
How Business Objects works in SAP family
SAP BO-Business Intelligence package and tool list
Data warehousing concept from SAP perspective

SAP Business Object Architecture

SAP BO Architecture
Various tiers in architecture: Client, Processing, Intelligence

SAP Web Intelligence

Web Intelligence Overview
Variable in Web Intelligence environment

Using Universe Designer Tools (UDT)

Overview of the Universe Designer Tool
Working with shared, secured and personal connections
Understanding of the Semantic layer

SAP BO Reports

SAP BO Reports
Chart Reports, Table Reports, Sorting and aggregating of Reports
Various elements of Reports, graphs, text elements
Reports and Filters
Section Report
Break Report
Alerts Report
Scope of Analysis Panel
Conditional Reporting
Ranked Report
Drill Report

Advanced Formatting

Advanced methods of formatting in SAP BO
Identifying Chasm trap and resolving Chasm traps with various methodologies
Detection and resolving of loop

Information Design Tool (IDT) Integration

Introduction to SAP BO information design tool
Extracting data from various sources using OLAP methodologies
Creating of Universe with IDT
IDT Vs UDT
Working with IDT as an Integration tool

Getting started with Crystal Dashboard

Data visualization tool for creating interactive dashboards
Point-and-click Features
Various dashboard features and interface

Live Office

Live office
Detailed design of Crystal Dashboard

SAP BO 4.2 Features

Got a question for us? Please mention it in the comments section and we will get back to you.

527