Dimension formula - solve_order

[Former Member]

In SAP BPC 7.5 I created a dimension formula. The formula works fine for the base elements of the time hierarchy, but gives wrong values for the quarter and year because of the wrong solve order. I think this is a problem for the solve_order functionality, but how can I specify the time hierarchy to be solved as last, as the hierachy is no explicit formula?

[Former Member]

We had the same issue. We had to include the solve order in the formula. Here is an example.

IIF([ACCOUNTOPS].[SKF_PLBS]=0,NULL,[ACCOUNTOPS].[VarOH_Prodsupplies]/([ACCOUNTOPS].[SKF_PLBS])),SOLVE_ORDER=20

[PatrickFavre]

Hi again,

In any case, and as explained in the SAP note, your solve_order on the dimension formula should have a value greater than 3, as 3 is the default value for all Measures calculation.

Hope it helps,

Kind Regards,

Patrick

[Former Member]

Hi Patrick,

thanks for your answer. Unfortunately I don't have a ytd-application, I have a periodic application.

I hope someone can help

Jean-Marc

[PatrickFavre]

Hi,

Did you have a look to SAP note 1478786?

Depending the value of the solve_order you're using, this note could be useful.

Hope it helps,

Kind Regards,

Patrick