Reg structures in query designer

[Former Member]

Hi Experts.

we can define one structure in columns and one in rows.

Why cant we define two structures in key figures (columns)?

what may be the reason and what happens if we do so??

i've searched the sdn but i coudnt find the correct reason for it?

I kindly request you to suggest few solutions for this..

Thanks in advance!!!

[Former Member · Accepted solution]

Hi,

You can create 2 structures in Columns. But only one of them can have key figures in it. The other one can have only selections and restrictions.

The reason for this is that, it is mandatory to have a unique key figure value in each cell of the output. If you put keyfigures in both structures there will be some cells (columns) where there are 2 keyfigures involved in it.

When you put 2 structures in the cols, there will be M x N number of columns where M is the number of cols in the first structure and the N is the no of cols in the second one.

Hope this is clear...

Regards,

BIJESH

[hai_murali_here]

Hi Anil,

Hope the following link answer your queries.....

http://help.sap.com/saphelp_nw70/helpdata/en/4d/e2bebb41da1d42917100471b364efa/content.htm

Rgds,

Murali

[Former Member]

hi Murali,

thanks for ur immediate response. I've already seen the document and the document says...that Within a query definition you can use either no structures or a maximum of two structures. Of these, only one can be a key figure structure.

But why cant we have two structures in keyfigures?? what happens if we have two keyfig structures in one query?? how the result will be affected??

[hai_murali_here]

Hi Anil,

I think the above comments clarify your doubt.

Rgds,

Murali