cancel
Showing results for 
Search instead for 
Did you mean: 

How to get result of 2nd value based on first characteristics value

manna_das
Contributor
0 Kudos

Hello All,

Please see the screenshot and let me know how can i achieve the Desired Result:

Objective :

Show only those values which are available in first Column i.e. after Date.

Thanks in advance

MD

Accepted Solutions (1)

Accepted Solutions (1)

yasemin_kilinc
Active Contributor
0 Kudos

Hi Manna,

I assume that you have 2 characteristics and one key figure and for each characteristic you have a combination of two values (such as char-1 having values a or b, char-2 having values c or d and in your screenshot you have data for a,c and b,d)

You need to have restricted key figures for each combination if you desire a condition on any combination of two characteristics. (I suppose you want to show only values greater than 0 for a,c combination of data). Then you can add a condition for the RKF (with a,c combination) to show values greater than 0.

Regards

Yasemin...

manna_das
Contributor
0 Kudos

Hi Yasemin,

Kindly check the screenshot, it might help to understand my problem:

I need only those result in Finished column where WIP quantities are present.

Thanks in advace

Manna Das

former_member199945
Active Contributor
0 Kudos

Hi,

Try like this create new formula copy of WIP QTY with  formula WIPQTY + 0 or (wipqty +1 -1  ) now in wip qty instead of blank it will dsipaly 0.

apply condition on wipqty+0  when  it ie equal to 0.

this might work.

Thanks.

yasemin_kilinc
Active Contributor
0 Kudos

Hi Manna,

If you are going to build a query for all of the materials, then create an RKF (RKF1), add your key figure and restrict material type with WIP and for the other RKF (RKF2) add your key figure and restrict material type with Finished. Now you have two RKFs. Create a condition on RKF1 greater than 0 and select material as the characteristic. In the query remove material type from the query.

Hope it helps

Regards

Yasemin...

manna_das
Contributor
0 Kudos

Hi Yasemin

I tried ur solution, but no help

Moreover if i remove material type how would end user know which column represents which material type?

KR,

Manna

yasemin_kilinc
Active Contributor
0 Kudos

Hi Manna,

I am not sure if you have applied the procedure in the suggested way. This is a procedure that works pretty for sure. You can remove material type (I assume you have only two types), and give the suitable names to the RKFs. (Such as WIP KYF and Finished KYF). Please share the screenshots of your query, how you defined the RKFs and the condition. Then maybe we can advise what to do...

Regards

Yasemin...

manna_das
Contributor
0 Kudos

Hi Yasemin,

please use the link to download the various screenshot

https://www.dropbox.com/s/6hr34s921pt5oo9/Doc1.docx?dl=0

yasemin_kilinc
Active Contributor
0 Kudos

Hi Manna,

Is RKF5 WIP, if not please apply the condition on RKF3.

manna_das
Contributor
0 Kudos

Hi Yasemin,

RKF5 is WIP.

And one more option I tried to restrict RKF5 as global filter, but the problem is output is showing only for RKF5.

yasemin_kilinc
Active Contributor
0 Kudos

Hi Manna,

I just realized that you hide RKFs. Please remove ZMES_QKLA from columns (you can remove it from query, you already have that information in RKFs), hide formula1 and make RKFs visible. (Since RKF is visible the condition you created is not applied when you run the query)

Regards

Yasemin...

manna_das
Contributor
0 Kudos

Hello again Yasemin,

thanks a lot for continuous help

see the output now:

Kind Regards

MD

yasemin_kilinc
Active Contributor
0 Kudos

Hi Manna,

In the condition will you also check the CPU-Datum characteristic.

manna_das
Contributor
0 Kudos

Hi Yasemin,

Thanks a ton, you made my day. A BIG thanks for continuous help.

Solution:

I selected on Date on condition and it worked .

Kind Regards

Manna

yasemin_kilinc
Active Contributor
0 Kudos

Hi Manna,

Have a great day, I am glad that your issue is solved .

Regards

Yasemin...

Answers (5)

Answers (5)

dhrubojyoit_saha
Explorer
0 Kudos

If you have only two chars to display you might take the static route. Instead of placing the chars in the columns create two restricted key figures based on the chars and then use boolean if else to achieve your results. Something like RKF1 = 0 * RKF2 + RKF1

Regards,

Dhrubo

kohesco
Active Contributor
0 Kudos

Hi,

create a prequery, retrieving only the dates you desire.

In prequery, restrict your char to first value, create condition on the keyfigure (NE 0) and in the rows set your days as result.

in the main query, use replacement path variable to retain your result list of the prequery.

run the report with your initial setup.  and you have achieved it

check out doc ...

http://scn.sap.com/docs/DOC-54844

manna_das
Contributor
0 Kudos

Hi Koen,

thanks for the reply.

My dates are not fixed. 0calday. I have only one KF, whereas your solution is based on two KF.

Regards

MD

kohesco
Active Contributor
0 Kudos

Hi

It doesn't matter one or more KF's.

Just create prequery that results in the list of 0calday's you want to see in the mainquery.

and then fetch them in the main query via a replacement path variable on 0calday.

It definitely works !


Former Member
0 Kudos

Hi Manna,

  Can you try with the below setting.

Righclick on KF>GOTO Calculations tab>In local calculation: Calculate result as:Hide>Calculate single value as:Moving average.Pls check this setting it might help you.

Best,

SAtya.

manna_das
Contributor
0 Kudos

Hi Satya,

Thanks for the reply, i tried your suggestion but unfortunately the figures are not correct and for certain dates data is not available after trying above settings data is showing for those date, which is not correct.

Regards

MD

manna_das
Contributor
0 Kudos

Hello all,

I did some experiment with BEx designer and i think i am very close to the result, i restricted the first char value in "Characteristics Restriction". But it's not working properly. Now for Second Char it's not showing the value.

Any suggestions?????//

Thanks in advance

MD

Former Member
0 Kudos

Hi Manna,

i hope this is your output:-

Date  KF1   KF2  (please correct here ,if you dont have 2 KFs)

so your requirement will be,, if KF1 is null, don't display KF2 value.

we can do condition on KF1 not equal to zero as told above , but  the overall result row still considers all the values in aggregation.

Or in KF2, you can have the condition as if KF1> 0, then KF2 value, else 0. and then you can suppress the zero values from the report.

or the column values you are mentioning ,both are char values, and not KF values? if so, you can filter out # values in the filter section.

Regards,

Sakthi.

manna_das
Contributor
0 Kudos

Hi Sakthi,

Morrow less you have understood my requirement.

and I don't have two KFs. I have taken only 1 KF and mentioned it on Column.

I have created the condition but that's not working

Regards

Manna

Former Member
0 Kudos

Hi Manna,

i got it..

so this is what your output:

                    chocolate  biscuits

01.01.2014  100             100

02.02.2014   0                50

on a particular day, if the chocolate has the value, then only display that particular row?

If so, you can try with RKF restricted with chocolate, and apply the condition on this RKF.

plz try once and let us know.  also i guess this works when we know the char value beforehand, if it gets change, we need to do something else i guess.

I  may not correct somewhere. experts can advise further if this doesn't work.

Regards,

Sakthi

manna_das
Contributor
0 Kudos

you got it correct Sakthi .

I am testing this. What would be my characteristics assignment?

Regards

MD

Former Member
0 Kudos

Hi Manna,

you need to restrict the KF with Characteristic(lets say 0product) with value as for eg. here as Chocolate.

Regards,

Sakthi.

manna_das
Contributor
0 Kudos

i know abt RKF, i was asking about char assignment in Condition.

Regards

Manna

Former Member
0 Kudos

I am Sorry:).

Plz try with default(all char).

Regards,

Sakthi

manna_das
Contributor
0 Kudos

not able to get the desired result.

ccc_ccc
Active Contributor
0 Kudos

Hi Manna,

I guess your query designer look like this. please confirm

Two chars objects with only one key figure, please confirm this, so that i will provide logic to get desired result.

Regards,

Nanda

manna_das
Contributor
0 Kudos

Hi Nanda,

ya my designer looks like same as you mentioned.

Regards

MD

former_member182470
Active Contributor
0 Kudos

Create a Condition on your first "KF Not Equal to Zero".

manna_das
Contributor
0 Kudos

Hi Suman,

The keyfigure is same. the values are coming from same characteristics.

Regards

MD

former_member182470
Active Contributor
0 Kudos

Same in which sense? How did you keep same KF twice in query? Anyway create a condition..