Inserting a data source


After completing this lesson, you will be able to:

  • Insert a specific data source

Data Source for Analysis

In Analysis for Excel, data is displayed and analyzed in crosstab. To create a crosstab, first choose Insert Data Source from the Analysis ribbon. You then have three options:

  • Select Data Source for Analysis . . .
  • Select Data Source for Defining Formulas . . .
  • Insert Anlaysis View . . .
The Insert Data Source button of the Analysis Ribbon and its options

When choosing Select Data Source for Analysis . . ., you select the appropriate connection to your source system and then browse in that system for the specific data source you want to analyze.

The Connections choices of the Select Data Source dialog
The data source options of the Select Data Source dialog

The result is a crosstab, usually with measures in the Columns and dimensions in the Rows.

Screen shot of the crosstab representing an inserted data source in the Analysis worksheet

Data Source for Defining Formulas

When inserting a data source for defining formulas, you can use all data sources available to Analysis. But rather than the data appearing in a crosstab format, no crosstab is displayed. Instead, you can use formulas to design workbooks that do not adhere to the classic result set/crosstab based layout.

Referencing and designing the layout of data using only formulas will most likely slow the performance of the workbook than the regular mode.

We will explore Analysis-specific formulas later in the course.

Analysis View

An Analysis view is the saved analysis state of what you see in a single crosstab, including any filtered data. You can save this state and use it as a data source for Analysis for Office as well as other SAP Analytics tools such as SAP Web Intelligence and SAP Crystal Reports for Enterprise.

Analysis views are saved only on the SAP BusinessObjects BI Platform.

Insert a Data Source into a Workbook

As the company analyst, you have been asked to create a new analysis workbook on your BW/4HANA system, which you can access from your SAP BusinessObjects BI Platform. You need to insert the Sales Order Composite Provider (P_SO_CP1) data source to analyze.

Task 1:

Log in to track your progress & complete quizzes