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

[Former Member]

Hi Satyajit,

Does that mean you are trying to get the complete set of result of your query for different values of Characteristics C1.

In that case if you keep the C1 in your rows part of your query designer and set the in the properties of

C1>Suppress Result Rows>Select "Never" or "With One Value".

I hope then u can have the complete resultset for the different values of C1.

Hope This Helps,

Regards,

Parth.

[Former Member]

If you provide an example of output it wouldn't be so confusing.

Best regards,

Eugene

[Former Member]

Let's say my query looks like this:

column: CALYEAR (3 values: 2003, 2004, 2005)

rows: PLANNEDCOST, ACTUALCOST

what I mean is, I should have 3 tabular views:

CALYEAR|PLANNEDCOST|ACTUALCOST

2003|1.900|2.100

CALYEAR|PLANNEDCOST|ACTUALCOST

2004|1.700|2.800

CALYEAR|PLANNEDCOST|ACTUALCOST

2005|5.900|2.400

Thanks,

Satyajit.

[Former Member]

Hi Satyajit,

Why don't you use calyear in rows and plannedcost/actual cost in columns. if you want to use in this way then create a structures and selections for calyear(2003,2004,2005) then use costs in columns...hope it helps.

regs,

mahantesh

[Former Member]

Thanks guys. I think I know what to do now.

[Former Member]

Hi Satyajit,

If you mean to show, for example, different key figures depending on user entry, you may look at this thread as an example:

Best regards,

Eugene

[Former Member]

Hi Satyajit,

I hope i am getting your problem right.

By saying "3 different resulsets based on x1, x2 and x3"

did u mean to say that the list of key figures u have specified in your columns portion of your query should be displayed 3 times,First with x1, then with x2 and then x3.?

If thats the case what u can do is drag the characteristic C1 into the columns section of your query designer and keep it in top , followed by the key figures.

Then you can achieve the desired result..

Hope it helps.

Regards,

Parth.

[Former Member]

Hi Anil,

I couldn't quite get your question. Can you explain?

Parth,

That is not what I want. I want different tabular displays (let's say) for different values if C1.

Thanks,

Satyajit.

[Former Member]

Hi,

do you want to have different layout than the report which has property(supress result rows) for 'Characterstic C1' = 'Never'.

with rgds,

Anil Kumar Sharma .P