Skip to Content
Former Member
May 25, 2010 at 09:09 AM

Understanding a query


Hello Experts,

I am unable to understand one existing query's functionality.

In infoprovider panel of Query Designer,we have some characteristics and keyfigures.

In columns panel in QD,

we have one selection VER(I checked its definition.In definition,its based on one keyfigure with selection on one characteristic variable that picks latest version of master data)(the icon of this selection is dark)

we have one formula on one keyfigure KF1

We have one selection on this key figure KF1 but the icon is in dark color.

In rows panel

we have some characteristics

In default value panel

we have some characteristics...on some of the characteristics present here...they have variables..

In characteristic restrictions panel

we have request ID with variable in it....

Now my questions are:

1.whats the logic behind the query.I know that no one can tell clearly as you have not seen the screen but any information about any components will help me understand the query logic better.

2.When they have put Request ID in characteristic restrictions panel,and they have one variable on this,does that mean only data from request IDs allowed by this variable will be shown?

3.they have some characteristics in default values panel...they have variables on some of them..Does that mean the characteristic data choosen in variables will only be shown....??

Thanks alot for your patience.