When working with self-service is hard to read the numbers without the thousands separator. Is there a way to format the numbers, or even change the scale of the numbers?
Hi Karem,
You can resolve this by setting up an attribute on the measure dimension using Attribute table 3. Give it the name FORMAT_STRING and set the data type to String. You can then set the Number format to Decimal. You can view the set up for this attribute in the attached screenshots.
Jennifer Buchanan - Practice Director, CFO Solutions
Many thanks...
Dear Jennifer;
First of all thanks for your useful contribution. However I am using the 12.0.7 and I cannot find the dimension mentioned.
I am only working with the BPCMAIN cube for the self-service. Is it possible give me any clue of way to format the numbers.
Thanks in advance
João Miguel
To format the outputs, you need to do 2 things : 1. Have a dimension BPDACCOUNT with an attribute “Format_String” 2. Declare for the BPCMAIN cube that the format dimension is BPDACCOUNT 3. For each account put as “format_string” the proper format string “# ###.00” or “%” etc.Georges
João, you can also review this small session about working with format attribute. It is based on v.11, but still have same approach in v.12 (but in better UI ).
--
Nick Gladkov | Senior Product Manager, Infor d/EPM | Infor
George,
Thanks for your post. Now, when working with Budgeting and Planning MT (CS), I don't think we can add attributes to any dimension nor declare BPDACCOUNT as the measure dimension in the BPCMAIN cube. Do you have any ideas ?
