Multiple resultsets from the same query?

[Former Member]

Hi all,

Can I define a query that will show more than one resultset (of similar structure), based on the different values of a particular characteristic?

Say, characteristic C1 has 3 different values x1, x2 and x3. Is it possible to output 3 different resulsets based on x1, x2 and x3?

Thanks,

Satyajit.

[Former Member · Accepted solution]

Hi,

Do you want to report the char C1 with values x1,x2,x3 in three results/rows? if yes you can create structures with char C1 with restrictions x1/x2/x3...

regs,

mahantesh

[Former Member · Accepted solution]

Hi Mahantesh,

Can you please explain a little more? Or else you can lead me to some documentation.

Hi Eugene,

My output will not be based on user input, but different values of C1 in my infocube.

Thanks,

Satyajit.

[Former Member · Accepted solution]

Hi Satyajit,

Create a structure and take new selections based on the number of rows and move the required characterstics into that and restrict it by the values x1/x2/x3/y1/y2/z1. If you want summation/result use new formula by summing the selections. Am i correct as per your requirement....if not correct then let me know the output of the query.

regs, mahantesh