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

MarkusWipp's avatar
MarkusWipp
Contributor
1 year ago

Issues getting currency displayed on CV for dynamic calc account

Hi all, 

I'm currently facing a challenge and do not seem to be able to get this to work.

I have a CV displaying (amongst other things) a Dynamic Calc-Account (in Column) across Entities (in Rows), where entities have various currency. I want to be able to display the currency in the cell (with setting on CV cell format (ShowCurrency = True)

I tried in essence the following in the business rule that calculates the value:

Dim currencyID As Integer = api.Pov.Cons.MemberId
Dim value As Decimal = 120.10
Dim result As DataCell = New DataCell(New DataCellPk(), value, New DataCellStatus(DataCellExistenceType.IsDerivedData, DataCellStorageType.Calculation))
               
Dim resultEx As New DataCellEx(result, "", currencyID, AccountTypeId.Asset)
Return resultEx


But that is not working unfortunately. Does anyone have an idea on how to get this working?

Thanks

Markus

Cube View

4 Replies

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    If your dynamic calc is in U8 (or any UD member) there is a setting on the UD member that will allow you to denote a currency.

    I think your issue is that setting the ShowCurrency = True pulls the currency from the entity dimension and cons dimensions you are displaying.  You may have to play around with the below, but it could work:

     

  • MarkusWipp's avatar
    MarkusWipp
    Contributor
    1 year ago

    Hi and thanks for your answer!

    Unfortuinately we have and need this calculation on the account and it would be sufficient to display the entities currency with this account (there is no need for a different currency), but unfortunately it's not displaying that currency at all. Am I missing something obvious?

    • T_Kress's avatar
      T_Kress
      Icon for OneStream Employee rankOneStream Employee
      1 year ago

      There is a cell format setting on the row where you can turn on currency like below.  Have you tried this:

      When you turn on it appears as follows:

       

  • MarkusWipp's avatar
    MarkusWipp
    Contributor
    1 year ago

    Hi, yes, that is what I tried and it seems to not work for dynamic calculated accounts. 

    In my test CV you can see that the first column, which is a stored account is showing the currency, whereas the last two e.g. which are dynamic calculated accounts, ore not showing the currency, even though they are leaving some space, where the currency should be displayed.