Issue with Dynamic Calculation for "Translated" Consolidation in a UD1 Grouping

Hello everyone,

I am experiencing an issue with a dynamic calculation rule in OneStream for a user-defined dimension (UD1) grouping entities. The rule works correctly for all Consolidation dimensions except for "Translated," where the data is not calculated or displayed at the UD1 level, even though the base entities have values for that member.

Context:

1. I have a dynamic calculation rule that sums the values of base entities grouped under a UD1. The rule’s logic is the following:
   

   Dim entity As String = api.Pov.Entity.Name
   Dim text5 As String = api.Entity.Text(5)
   Dim ud1 As String = api.Pov.UD1.Name
   Dim ud1Man As String = ud1.Substring(1,3)
   Dim parent As String = "P" & ud1Man
   Dim result As Decimal = 0.00
   
   'Filter the entities by Text5
   Dim entityPk As DimPk = api.Dimensions.GetDim("Entities").DimPk
   Dim entityList As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(entityPk, "E#PL00.Base.Where(Text5 Contains '" & ud1 &"')", Nothing)
   
   
   'If we deploy the entities with any of the parent entities we will see the totals
   If entity.Equals("PL00") Or entity.Equals("P000") Then
   For Each entityMember As MemberInfo In entityList
   Dim entityLooped As String = entityMember.Member.Name
   result = result + api.Data.GetDataCell("E#" & entityLooped & ":P#" & parent & ":U1#None").CellAmount
   Next
   Return result
   End If

    

2. The rule works perfectly for Consolidations like "Local" and "OwnerPreAdj," but not for "Translated."
3. I have manually confirmed that the base entities have values in the "Translated" Consolidation via Cube Views.

Example:

For the period 2024M8:

• UD1 S043 groups the entities E043 and E146.
• Both entities (E043 and E146) have values in the "Translated" Consolidation.
• However, the total for S043 in "Translated" appears blank.

   

Questions:

1. Is there anything specific to consider when handling Consolidations like "Translated" in dynamic calculations?
2. Could this be related to how data is configured or consolidated for "Translated" in OneStream?
3. Has anyone faced a similar issue or have recommendations to resolve this?

I would greatly appreciate any insights or suggestions!

Best regards,
Claudia