Issue with FdxExecuteDataUnitTimePivot

[sandeepr]

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.

[ChristianW]

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]

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.