Skip to main content
Nikpowar97
Contributor
Mar 19, 2024 12:50 PM UTC
Solved

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

JackLacavaAnswer
Employee - Sage
Mar 19, 2024 1:16 PM UTC

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.

View in thread

7 replies

RobbSalzmann
Employee - Advisor
RobbSalzmannEmployee - Advisor
Employee - Advisor
Mar 19, 2024 1:02 PM UTC

Make sure entity member KY00_Total exists the Consol cube, and that the user running the rule where the FDX method call is has access to that entity and all its base members.

Nikpowar97Author
Contributor
Mar 19, 2024 1:10 PM UTC

Yes the Entity Do exist in the Cube. and there is no security setup for the application. It is working for me on Local, USD but not for other Cons Member.

Employee - Sage
JackLacavaEmployee - SageAnswer
Employee - Sage
Mar 19, 2024 1:16 PM UTC

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.

    Employee - Advisor
    sameburnEmployee - Advisor
    Employee - Advisor
    Mar 19, 2024 6:27 PM UTC

    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.

      Employee - Advisor
      sameburnEmployee - Advisor
      Employee - Advisor
      Mar 19, 2024 6:41 PM UTC

      The out of the box Data Management Export Data option might be path of least resistance to export data for those cons members

      Terms & ConditionsAccessibility statement