Restriction by key fig

[Former Member]

Hi ,

I am creating a report in which as if now i m restricting a quantity(key field) with Statistical key fig and 0calday where 0calday let say for april month is an interval 01.04.2008-30.04.2008 but there is a requirement there is one more key figure End date lets say = 20.04.2008 now i want to restrict the say quanity with statistical key fig and 0Calday with value 21.04.2008-30.04.2008 is it possible to do so.. if so plz let me know , hlep will be appreciated .

PresentScenario

0quantity 0skf 0calday

OP009 01.04.2008-30.04.2008

New scenario

0quantity 0skf 0calday

OP009 21.04.2008-30.04.2008

where 0calday has been calculated according to the End date key fig... whatever is the end date value shud be from next day to end of the month

Thanks

[Former Member]

Hi,

Generally to restrict on keyfigure we can use conditions and here we can define any kind of conditions on this keyfigure.

otherwise you can write formula in this way (Keyfig == 20.04.2008)*(Required KF value)

in your case i think u should have used characteristics for dates rather than keyfigure.

Thanks

Tulsi

Edited by: Thulasi ram on Jun 25, 2008 10:56 AM

[Former Member]

Hi,

You can restrict a particular key figure with N number of characteristic restriction ....,

With what char's you want to restrict the Key figure Qty ??

1. 0Calday -simply drag and restrict it whatever value u want that can be single value or value range itself.

2. Statistical key figure - Not clear ????

Thanks

Dipika

[Former Member]

Hello,

I'm not 100% sure what you're asking about, but it is not a problem to include two different restrictions in a report even if these are based on the same key figure. You just drag the key figure once more to the key figure structure and apply the restrictions, change the name so it doesn't have the same name as the other restrictions and so on.

If your question is if the variable for 0CALDAY can have different values for different restrictions, the answer is no. A variable always have the same value for the complete query. You need to create another variable for 0CALDAY.

Regards,

Christoffer