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

Rams_2022's avatar
Rams_2022
New Contributor II
1 year ago

Force consolidation error

Hi OS Experts: While I am running the ForceConsolidation in cube view, I am getting the below error message. Are there any possibilities of this error: Error calculating member 'EndBal_Calc' in d...
XFBR
Rams_2022's avatar
Rams_2022
New Contributor II
1 year ago

Hi MarcusH , yes you are correct. in the member formula, we have variable that concatenates the entity, you can see the below. while execute the api.data.calculate the error is getting trigged during forececonsolidation.

Dim currMonthNum As Integer = api.Time.GetPeriodNumFromId(api.Pov.Time.MemberId)
Dim strSourceEntity As String = api.Entity.Text(2)

Dim SourceUDs As String = "V#YTD:O#Top:I#Top:U1#USACAP:U2#TOT_DEPT:U3#TOT_PROJ:U8#None:E#" & strSourceEntity

api.Data.Calculate("A#TP_FP:F#EndBal_Calc:" & TargetUDs &" = RemoveNoData(A#PDE_NET:F#EndBal:" & SourceUDs &")-RemoveNoData(A#PAS_WO:F#EndBal:" & SourceUDs &")-RemoveNoData(A#ACP_EU_TEM_CR:F#EndBal:" & SourceUDs &")")

what is the possibilities of the resolutions?

MarcusH's avatar
MarcusH
Valued Contributor
1 year ago

One possibility is to set the EndBal_Calc to 0 if there is no value on Text2 for the Entity:

Dim currMonthNum As Integer = api.Time.GetPeriodNumFromId(api.Pov.Time.MemberId)
Dim strSourceEntity As String = api.Entity.Text(2)

If String.IsNullOrWhiteSpace(strSourceEntity) Then
    api.Data.Calculate("A#TP_FP:F#EndBal_Calc:" & TargetUDs & " = 0"
Else
    Dim SourceUDs As String = "V#YTD:O#Top:I#Top:U1#USACAP:U2#TOT_DEPT:U3#TOT_PROJ:U8#None:E#" & strSourceEntity

    api.Data.Calculate("A#TP_FP:F#EndBal_Calc:" & TargetUDs &" = RemoveNoData(A#PDE_NET:F#EndBal:" & SourceUDs &")-RemoveNoData(A#PAS_WO:F#EndBal:" & SourceUDs &")-RemoveNoData(A#ACP_EU_TEM_CR:F#EndBal:" & SourceUDs &")")
End If