query for %notification completed with in the time by priority

[Former Member]

Hi..I want to build the query for caculate the required key figures to calculate the % completed on time.

able to show the report will be look like:

for priority A zdownvwend<4 hrs

for priority B zdowntime<8 hrs

for priority C zdowntime<12 hours

these queries will included in web page..

plz its urgent for good answer i will assign points...

[Former Member · Accepted solution]

Hi Sujata,

ZDOWNTIME is they keyfigure you are using in the model. I understand that you are already getting this value. Please confirm so that I can provide right solution to you.

Thanks n Regards,

Umesh

[Former Member · Accepted solution]

am not getting the out put..

[Former Member · Accepted solution]

did any one done this task or not..plz its urgent

[Former Member · Accepted solution]

Hi gabbeta,

would you please explain better your problem and your data-model, also in terms of KF and Char.

Ciao.

Riccardo.

[Former Member · Accepted solution]

am having a KF are down time during vend and downtime during euip.

Rows are..Notification number and company code..Priority in Free characteristic...

based on this I want to built the report..it should give the output like..

Priority A zdownvwend <4 hrs..

Priority B Zdowntime<8 hrs..

Priority C zdowntime <12 hrs..

plz its urgent...

[Former Member · Accepted solution]

Hi gabbeta,

not sure, but I try:

1) you want in single columns values <4 or <8...:

You can use Formula with boolean operator '<'. It gives you as feed-back 1 or 0 if corresponding to the operator.

2) you want single columns for single values of Priority:

You create a set of Restricted Key Figures with the corresponding value of Priority.

3) you can combine previous settings if you need both situation: Restricted Key Figure and values greater or less then 4, 8, 12.

Ciao.

Riccardo.