Log anything with JSON
I showed it at Wave and share it with all of you: when you use JSON to log, you can log anything, not just strings, you can log a Dictionary, a list, a MemberInfo, even a Databuffer.
First, you nee...
Forum Discussion
Hi Ludo,
Many thanks for sharing the code for logging using Json - I tried but I am not getting any results. Here is my code:
Imports Newtonsoft.Json
Imports Newtonsoft.Json.Linq
Namespace OneStream.BusinessRule.Finance.FinVB
Public Class MainClass
Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As FinanceRulesApi, ByVal args As FinanceRulesArgs) As Object
Try
Select Case api.FunctionType
Case Is = FinanceFunctionType.CustomCalculate
If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("TestJsonLog") Then
Dim objDimPk As DimPk = api.Dimensions.GetDim("UD1Main").DimPk
Dim ctryList As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(objDimPk, "U1#APAC.Base", Nothing)
Dim ctryInfo As MemberInfo
For Each ctryInfo In ctryList
If Not ctryInfo Is Nothing Then
Dim stringObj As String = JsonConvert.SerializeObject(ctryInfo, Formatting.Indented)
BRApi.ErrorLog.LogMessage(si, ctryInfo.Member.Name & ", ctryInfo: " & stringObj)
End If
Next
End If
End Select
Return Nothing
Catch ex As Exception
Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try
End Function
End Class
End Namespace
And, here are my result - not sure what I am missing -
Many thanks for your help
Wei
Hi Wei,
the results look good to me. You only see 1 member at a time, you can log ctryList =and you will see the entire list if it's what you're looking for.
best
Thanks Ludo - I am getting "null" for LocalDescription for all of them, where your deck shows there should be some property information listed under "LocalDescription" - are there any other config I need to do to see them?
Thank you
Wei
Oh I see, the Local Description field is misleading. Only the Default Description is stored in the MemberInfo table
Descriptions in multiple languages are stored in another table, you can read it in a rule with a Dictionary(Of String, Memberdescription).This is a good place to start: Solved: Cannot save Descriptions to a member - OneStream Community (onestreamsoftware.com)
Hi Ludo, I don't have access to the link you shared, are you able to provide more details on that? I will give Dictionary a try.
Thanks
Wei