Results from conditions not passed to Jump query

[Former Member]

Dear all,

I have created a summary query and I have a condition applied on it. The condition is 'KF' < 4. I get the results of the query. I have changed the Calculate Result As to 'Total' to show the total of only the records that are displayed.

However I have a jump query on it and when I goto the Jump query, it shows all the records though they dont satisfy the conditions. I want the drill down report to show the results of only those values displayed in the Summary report.

Is there a setting where I can change to get the required result.

Any helpful reply would be awarded.

thanks,

KK

[Former Member]

Hi KK,

You can try in RSBBS using KF as a parameter in assignment details.

Regards

Srini

[Former Member]

Hey Srinivasa,

I can only see characteristics on the Assignmant details. I dont see any Key figures. Could you please elaborate..

thanks,

KK

[Former Member]

Dont u need to have d same condition in the receiver query ?

U can try that having same variables n conditions wid jst the additional line items in d receiver query.

[Former Member]

Hey Roberto,

Thank you for the reply. Yes I would also need to have the same condition in the reciever query. However, my condition is on result values in the reciever query. To explain u clearly...

I have the data as below in my cube

Material QTY

123 10

124 20

125 30

126 40

I have a summary query for which I want a condition where QTY < 40

When I enter Material 123;124;125;126 I get the result as below

Material QTY

123 10

124 20

125 30

When I drill down I get the below result

123 1 2

123 2 4

123 3 4

<b>Result 10</b>

124 1 5

124 2 10

124 3 5

<b>Result 20</b>

125 1 10

125 2 10

125 3 10

<b>Result 30</b>

126 1 10

126 2 20

126 3 10

<b>Result 40</b>

I cannot apply the same condition in the reciever query because I want the condition to be applied on the result rows. I have created one more formula KF with SUMCT(QTY) and applied condition on that but it still doesnt work.

Any suggestions would be highly appreciated.

thanks,

KK