Forum Discussion

sandeepr's avatar
sandeepr
New Contributor II
2 years ago

Issue with FdxExecuteDataUnitTimePivot

Hi All,

I am using  FdxExecuteDataUnitTimePivot to export data from onestream cube, everything working as expected except one issue. i.e., I am using consolidation member C#Aggregated beacuse i want to export data for C#aggregated, but FdxExecuteDataUnitTimePivot is exporting data from C#CAD. All our users input data at C#CAD, also default currency on entity is CAD.

 

Just want to know is this the known issue, or FDX designed to export only base currency? Is there any way to pull only C#aggregated with FdxExecuteDataUnitTimePivot.

 

 

Connectors
  • ChristianW's avatar
    ChristianW
    Valued Contributor
    2 years ago

    Hi

    You should report this as a bug, FDX export was created before C#Aggregated, so it might not yet support it.

    Saying this, is it really needed? You might like to sum all the entities up for the same result (an aggregation of the data).

    You can do this in a report/dashboard/pivot table, or in VB if needed.

    Cheers

    Christian

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      2 years ago

      FDX cannot extract C#Share and C#Elimination by design, so I suspect that the same applies to C#Aggregated.

      sandeepr You can target the Parent Entity though.