Planning Key figure with type integer

[Former Member]

Hello Guys,

My planners enter a yearly value and afterwards the value is distributed to 12 month. Some of the values are small e.g. 1. I want to have as result 1/12 = 0.08333. But the distribution by keys moves the value 1 to month June.??? All other month contain zero.

I have following settings in the Planning Function:

- Selected all Key Figures

- Condition: Fiscal year 2008

- Top-down distribution u2013 Distribute All

- From: ALL

- To: 001.2008-012.2008

- Faktor: 100

The Key figures are defined as data type integer, Aggregation SUM and Summation. I suppose my problem is that data type integer is only for whole numbers without decimal places. If yes is it possible to convert my Key Figure from type integer to number? Any ideas how to solve the problem also welcome.

I know about the solution to create new Key Figures and replace the old ones in my Planning Layout. But the old Key Figures are also used in our Monthly Reporting used by the bussiness and I would not like to change these Reports.

Thanks in advance.

Doris

[gregor_dieckmann]

Hi Doris,

yes, the effect comes from the integer key figure since the DB structures for this type have no decimals. The system always rounds to the technical decimals supported by the key figure type. So the type 'number' (has 3 decimals) would be better. But before changing the key figure type one should check why the technical type 'integer' was used (in reports, in WHM, transformations, etc.).

Regards,

Gregor

[Former Member]

Hello Gregor,

thanks for the answer. The Key figures are used only in one report so I suppose a change is possible. But my problem is how to change? To change the type from the Key Figures with the normal change function is not possible. Do you know a reports or a Function module or whatever?

Regards

Doris

[gregor_dieckmann]

Hello Doris,

there seems to be no easy way to adjust the technical type of the key figure (when the cube contains data). One way is to create a new key figure (of type number) and copy the data from the integer key figure to the number key figure. Then one can delete the integer key figure from the cube, e.g. with the remodelling toolbox (RSA1, cf. context menu of the InfoCube: Additional Functions -> Remodelling). In addition one then has to adjust the query and MultiProvider, aggregation Level, etc.

Regards,

Gregor