When to use a structure in Query design?

[Former Member]

We open a query design by previous consultants who has left and found there is a structure element to be built up for some key figures. What's the purpose to use structure in query design?

Thanks

[Former Member · Accepted solution]

hi kevin:

when we want to effect other keyfigure by other kf then we use structures,

if we create structures then these two kf have some relation on one another.

and there are two types of structures

global( we can use these structures again)

local

using global structures again means for global structures one folder created at infoprovider level

[former_member188325]

in addition to that:

here is one more scenario where we use structures:

If you want to see aggragated values for any characteristics in Query,you can go for a structure.

for example: if you take customer in rows and sales Kf is columns...report shows sales for individual customer..

now create a structure in Rows and inlcude Customer char in the structure....only one result row i.e. aggragated values of sales for all customers will be displayed (not individual customer sales)....

2.To do some runtime calculations by using cell definition,we will have to have two structures in Query.

Hope this helps!

[Former Member]

Kevin,

Structural components of key figure structures are always based on the key figure selections (basic key figures, restricted key figures, and calculated key figures). Characteristic structural components cannot contain key figure selections.

If you want to use a structure in the query with several characteristic values, you first have to create a structure and then insert the required characteristic values

You can use structures in several different queries. You have to save them in the InfoProvider to reuse them. These structures are then called reusable structures

Check foe more details

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a5632e09411d2acb90000e829fbfe/frameset.htm

-Doodle

[Former Member]

- Structures can be re-used by other queries. If you will reuse the same structure time and again it is beneficial to create a structure to save time during development.(Structures can be changed and not affect other queries if you right click and "remove reference")

Structures in general:

- You can create restricted chars and calculated KF, formulas within structures

- Structures allow for showing a set layout of chars/kf regardless of data actually present in the query (using restricted chars).

Hope this helps.

Petter