Forum Discussion
Nikpowar97
2 years agoContributor
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.GetScenario...
- 2 years ago
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.
- 2 years ago
I was just looking at the same thing JackLacava
Nikpowar97 this may give you the insights you need for this:
https://femsadev.onestreamcloud.com/OneStreamWeb/Help/Content/Design%20and%20Reference/Financial%20Model%20Guides/Consolidation.htm - 2 years ago
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.
- 2 years ago
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.
sameburn
OneStream Employee
2 years agoThe 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.
Related Content
- 7 months ago
- 2 years ago