07-08-2022 12:13 AM - last edited on 05-02-2023 10:26 AM by JackLacava
Hello OS Community,
I noticed there was a variable for suppressing no data records when using the FdxExecuteDataUnit function. Is there a way to bypass zero data records?
Thanks in advance for your help!
Clifton
Solved! Go to Solution.
07-08-2022 05:33 AM
You can use the Filter parameter and filter "Amount <> 0"
07-08-2022 06:02 AM
Thank you Sai_Maganti
I was a little too late, but I tested it, it works perfectly. Cheers
Dim yourCube As String = "legal"
Dim yourEntity As String = "Group"
Dim test As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si, yourCube, $"E#{yourEntity}.DescendantsInclusive", "Local", ScenarioTypeId.Actual, "S#Actual", "T#2022M3", "YTD", True, "Amount <> 0", 4, False)
If test IsNot Nothing Then brapi.ErrorLog.LogMessage(si, $"Count {test.Rows.Count}", String.Join(vbnewline, test.select("").Select(Function(x) String.Join(",",x.ItemArray)))) Else brapi.ErrorLog.LogMessage(si, "Nothing")
07-08-2022 05:33 AM
You can use the Filter parameter and filter "Amount <> 0"
07-08-2022 06:02 AM
Thank you Sai_Maganti
I was a little too late, but I tested it, it works perfectly. Cheers
Dim yourCube As String = "legal"
Dim yourEntity As String = "Group"
Dim test As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si, yourCube, $"E#{yourEntity}.DescendantsInclusive", "Local", ScenarioTypeId.Actual, "S#Actual", "T#2022M3", "YTD", True, "Amount <> 0", 4, False)
If test IsNot Nothing Then brapi.ErrorLog.LogMessage(si, $"Count {test.Rows.Count}", String.Join(vbnewline, test.select("").Select(Function(x) String.Join(",",x.ItemArray)))) Else brapi.ErrorLog.LogMessage(si, "Nothing")
07-08-2022 12:03 PM
That is pretty simple. Appreciate the help!