FdxExecuteDataUnit on OwnerPostAdj, OwnerPreAdj, Elimination, Share
Code:
Dim TimeName As String = "2023M1"
Dim dt_NIk As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si,"Consol", "E#KY00_Total.Base","OwnerPostAdj",Brapi.Finance.Scenario.GetScenarioType(si,si.WorkflowClusterPk.ScenarioKey).Id,"S#Actual_Hist","T#" & TimeName,"YTD",True,"Flow = 'EndBalanceLoad'",10,False)
Error:
Error processing data. The item was not found. Entity, Parent, -1.
Is there any alternate way to retrieve Data. It works on USD, Local
Can you actually see records against that member in Database / Tools / Data Records? FdxExecuteDataUnit deals only in hard data, anything not stored (e.g. Share etc) will not be extracted. If you want that type of stuff, build a Cube View instead and use FdxExecuteCubeView / FdxExecuteCubeViewTimePivot.
I was just looking at the same thing JackLacava
Nikpowar97 this may give you the insights you need for this:
Consolidation (onestreamcloud.com)That's correct. The default consolidation algorithm effectively does not store the result of a bunch of consolidation calculations, and Fdx cannot extract what is not stored.
I don't know what Fdx does when the Stored Share algorithm is used instead (i.e. those records are actually generated), but I wouldn't be surprised if it skipped those elements anyway.
The FDX Data unit api's will only work with C#Local or any base currency member e.g C#Currencies.Base from the Consolidation dimension. That is why you're getting an error when you are not using one of those cons members and it works when you do.
