The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

sandeepr's avatar
sandeepr
New Contributor II
3 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

2 Replies

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    3 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
      Icon for OneStream Employee rankOneStream Employee
      3 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.