Divide key figures in real time cube by using planning function

[Private_Member_24235]

Dear all,

I have a real time cube which contains one key figure which is defined by 10 characteristics.

For one country, the users types the values fpr the key figure in a wrong format, so I have to divide those values by 1000.

I have tried to do this with a planning function "Revaluating" and a filter (on this spec. country). I have combined this two element in a planning sequence. When I run this I just get the error message "planning function ended with errors" without any further information.

Is there an other way to devide values within the cube? the BI release is 7.0.

Any help would be great.

Best regards,

Stefan from Munich/Germany

[Former Member · Accepted solution]

from my point of view you can manage this requ as followed:

create a PLF of type exit which reads the planning area and divides the values as you want

you can find an idea how reading the planning area here starting at page 9:

www.geocities.com/cynarad/reference_for_bps_programming.pdf

If you need more help, don't hesitate to ask me.

Good luck!

Clemens

Edited by: Clemens Groetz on Jun 3, 2009 3:27 PM

[Former Member]

Hi Stefanos,

What you are doing is absolutely right.. However, I want to ask a few question..

1. Are the characterestic values included in the filter ? ie. If you want to change for Country: UK, is UK present in filter?

2. Are there any other characteristics that you have not included in the function and are getting changed by chance ? Like you might need to include 0fiscyer in To Change if you are assigning 0Fiscper.

3. Write a small FOX function with hardcoded values to check if the system is accepting the values or not..

It should work.. Please write back in case you need more help..

Regards, Rishi