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

xtensibilitybro's avatar
xtensibilitybro
New Contributor III
3 years ago
Solved

Adding Cultures after Go-Live

Hi All, I was wondering if anyone had experience adding cultures to an applicaiton after go-live. Considering this is a system wide change its difficult to test without applying across all applicat...
Application Properties
Methodology
  • ChrisLoran's avatar
    ChrisLoran
    3 years ago

    This is similar to an existing enhancement request PF-26868.
    Unfortunately you can't add custom culture codes ( well, you can in the server config, but they won't actually appear in the application unless they are one of the standard culture codes as set my Microsoft )
    If it is only a few variations of descriptions, then you could use some other "English" culture codes like en-AU, en-CA, en-CB, en-IE, en-NA, en-GB, en-ZA , and get your cube views to display the correct one depending on the entity.

    You could of course do something more custom, using XFBR/BRString in the :Name override in the Cube View Rows/Columns, but then this won't work so well if you are using member expansions like A#BS.Tree, A#PL.Descendants.  A DynamicCalc on the V#Annotation (or other text-based view member) could also be used to show alternate descriptions based on some lookup logic, but will probably have a negative impact on performance.

ChrisLoran's avatar
ChrisLoran
Icon for OneStream Employee rankOneStream Employee
3 years ago

On the flip-side of the above examples:
This use of XFToStringForFormula  will work for all culture codes, but suffers from accuracy because it truncates to 9 decimal places in the calculation:

Dim someRate As Decimal = 0.00000001234567
api.Data.Calculate( "A#Result = A#Qty * " &  someRate.XFToStringForFormula()  )

 The best way to combine Decimal amounts with a calculation, is to use Formula Variables:

Dim someRate As Decimal = 0.00000001234567
api.Data.FormulaVariables.SetDecimalVariable("someRate", someRate)
api.Data.Calculate("A#MyResult = A#Quantity * $someRate")

* Works for all culture codes
* Doesn't have the overhead of converting Decimals to Strings
* Doesn't suffer the consequences of trying to present numbers as strings in various culture settings