Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
3 years ago

XFCell number format issue in People Planning Solution

Hi, I have setup the Global drivers in the People Planning module to be XFCell formulas, so that users can input drivers by Period/Scenario via cube views.   The formulas look like this one: (XFC...
Analytic Blend
  • AndreaF's avatar
    AndreaF
    3 years ago

    The workaround to the DriverValue column of the Global drivers table having insufficient space for the full XFCell command has been creating an XFBR rule which returns the full XFCell command as a string and to have the XFBR command called in the Global drivers table.

AndreaF's avatar
AndreaF
Contributor III
3 years ago

Quick update on this, it seems the issue was that I've simply hit the limit of number of available characters for the DriverValue column of the Global drivers table, so the

XFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|WFTime|:V#Periodic:A#PP_Acc_Driver_DE007:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None)

string can fit in the column of the table, while the

XFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|WFTime|:V#Periodic:A#PP_Acc_Driver_DE007:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None, NumberFormat=####0.00)

string cannot fit in the same column.

I'll need to figure out an alternative way to use the XFCell in the second case. Any suggestion is appreciated.

Thank you