06-08-2023 03:24 PM
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.
06-09-2023 03:30 AM
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
06-09-2023 07:59 AM
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.