The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
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...
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.
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