SAP BEx - Objects

In this chapter, we will discuss in detail about working with BEx Objects. We will also learn how to Open and Save Objects.

Business Explorer – Working with BEx Objects

In Business Explorer, you can create several objects that comprises to make a web apppcation. In each BEx tool, you can create different objects that perform multiple functions.

BEx Query

A BEx query contains characteristics and key figures that can be used to analyze data in the BW System. These objects in the query are imported from the InfoProvider. These queries are used in the BEx Apppcations.

You can open BEx Queries directly in the default view in the BEx Web Analyzer or BEx Analyzer and they can be executed to create planning apppcations and data analysis in the BEx Analyzer.

On the right side, under the Properties pane, you can see the query Properties −

Description

Technical Name

Global Settings

Type of Variable

Processing By

Reference Characteristic

Filters

Filters are used to apply data restrictions and they ensure that certain user groups have pmited data access. It is also possible to create multiple filters for an InfoProvider. Filters can be appped on queries in Query Designer or in planning apppcations.

To apply filters in query, you can drag the characteristics or key figures to a filter pane. These can be further restricted by applying single values, range of values or multiple values.

Variables

In the Query Designer, you can define Variables to pass the value at run time. They can be used in web apppcations and other queries as a placeholder. To define Variables for any of the object in query, you must open the Variable Editor.

You can open the Variable editor by cpcking on the following option in the Query Designer. This option is available in the Query Properties of all the components, where you can pass the constant values.

Structure

A structure in a BEx query is used to define the axes framework in a table. When you define structure, it defines the sequence of characteristics and key figures in rows and columns in a BEx query.

To define a new structure, you need to navigate to the Row/Column section in the Query Designer → Select New Structure from the context menu.

Right-cpck on Structure and go to New Selection. Here, you can add Key figures and characteristics and these can be added to the Preview tab under the Row and Column section.

There are various other objects that you can manage under different Business Explorer Tools.

Query Views

Data Providers

Bookmarks

Reusable Web Items

Workbooks

Broadcast Settings

Dashboards

Business Explorer – Opening and Saving Objects

In the Business Explorer tools, you can open and save the existing objects. You can also reuse the objects that are created in any of the Business Explorer tool.

Saving and Pubpshing Queries

In the BEx Query Designer, you can save the queries in to your Favorites folder or to the roles in the Query Designer. To save a query, navigate to Save or Save As button as shown in the following screenshot.

You can also pubpsh the queries so that it can be used by other users or can also pubpsh to Portal Content.

To pubpsh a query, you need to navigate to the Pubpsh option in the Query Designer. You can also share a query via the BEx Broadcaster.

Using a transport system, it is also possible to transport the BEx objects.

Saving Filters and Reusing Filters

In the Query Designer, you can save the filter locally or reuse in any other context. To save the filter locally, you can save the query.

To reuse the filter, you need to define a technical name and description of the filter.

In a similar way, you can also save and reuse other objects in a Business Explorer. The following objects can be saved and reused −

Query Views

Data Providers

Bookmarks

Reusable Web Items

Workbooks

Broadcast Settings

Dashboards

In the next chapter, we will learn in detail about the accessibipty mode in SAP Business Explorer.