SAP BO Analysis Create a Workspace - SAP BO Analysis Edition For OLAP

How to create a Workspace in SAP BO?

You have to click the new button to create a new workspace - Create a new workspace.

create_new_workspace

You will be encouraged to select a data source when you click the new button. You can choose from the dropdown list to view all the networks or the network pointing to Cube/InfoProvider or to Query/Query View to connect to BW OLAP source.

open_data_source

When you choose “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.

olap_connection

At the top you can navigate to folders tab. You can also do a search with the name of InfoCube/Modeling View in the source system.
Select InfoCube from the source system and click the OK button.

folders

When you get on the OK button, all the actions 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 dissimilar actions and dimension values to the Layout panel to generate a Crosstab and Chart in the Analysis pane.


dimension

Adding Chart to WS

You have to navigate to the Insert tab at the top to add a chart to workspace. You have different chart choices under Insert. When you have various analyses on the sheet, each chart points to a precise analysis in the workspace.

Adding Chart

In the analysis window, you have to choose the module 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, related to the section that you selected. The added chart is located below or to the right of the current components on the sheet.

insert

Resulting chart types existing under the Insert tab in the tool −

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

charts

Adding Crosstab to WS

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

sub_analysis

This adds a crosstab as a sub-analysis, related to the module that you are certain. The crosstab is added to the right or below a current component.

When you add it as sub-analysis, it is created 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.

analysis

How to Copy an Existing Crosstab or Chart?

It is also likely to copy a present crosstab or chart. To copy an object, you need to select the object by clicking the Analysis panel. Later, click the Copy button at the top.

crosstab

You can paste this to a new sheet when the object is copied. 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.

existing_object

If you need to erase the component, you can click the cross button on the top right corner of the object.
delete_analysis

Saving a Workspace

You can also save the workspace to BI platform source. You can select to save your changes to the present workspace, or to save the altered workspace as a new workspace in the repository.

saving_workspace


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

favorites

Note − if a workspace is idle for numerous minutes in Analysis Edition for OLAP, a copy of the workspace is spontaneously saved to your Favorites folder in advance the session is ended.

When the session is resumed before it is terminated, the auto-save cycle is reset, and the workspace is auto-saved again the next time your workspace grow into idle for numerous minutes.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BO Analysis Edition For OLAP Topics