cancel
Showing results for 
Search instead for 
Did you mean: 

structure creation in query designer

Former Member
0 Kudos

How to create structure for restrict KF or calculated KF in BEx query designer?

Accepted Solutions (0)

Answers (2)

Answers (2)

ravikanth_indurthi
Active Contributor
0 Kudos

Hi,

Structures are freely definable building blocks that consist of combinations of characteristics and basic key figures (for example, as calculated or restricted

key figures) .

Basically there are 2 Types:

Global structures

A global structure is a component of a query associated with a specific

InfoCube.You can use a global structure to define new queries. A global structure can be used to create several queries.

Local structures

A local structure is a component of a query associated with a specific query.

steps to create a global structure query

In the BEx Analyzer, from the SAP Business Explorer toolbar, choose query box.

On the SAP BEx Open dialog box:

Choose Queries.

Select the desired InfoCube (for example, SAP Demo Sales and Distribution

Overview).

Choose New.

On the Define the query: New Query screen:

In the left frame, expand the Structure node.

Drag and drop the desired structure into either the Rows or Columns frame.

In the left frame, expand the nodes from which you plan to use the characteristics or key figures.

Drag and drop the desired characteristics or key figures from the left

frame into the Rows, Free characteristics, or Filter frames as needed.and save.

On Save query dialog box:

In Technical name, enter a technical name for your query.

In Description, enter a description.

Choose OK.

On the Define the query: New Query screen, to transfer the query into a

workbook, choose ok.

Assign points if this is helpful.

Rgs,

I.R.K

chemicala_srimallikarjuna
Active Contributor
0 Kudos

Hi,

Right Click on Rows or Columns - Create Structure .

add ur CKF/RKF, to that structure .

Regards

CSM Reddy