Forum Discussion

Rams_2022's avatar
Rams_2022
New Contributor II
6 months 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
MarcusH's avatar
MarcusH
Contributor III

Without the member formula it is difficult to say precisely what the problem is but I would guess that you are using a variable to hold the Entity member name and that variable is empty. If that is not the case, post the member formula so we have a better idea of where the problem might be.

Rams_2022's avatar
Rams_2022
New Contributor II
6 months 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
    Contributor III
    6 months 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