Skip to main content
sandeepr
Newcomer
Jun 8, 2023 7:24 PM UTC

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.

 

 

2 replies

ChristianW
Employee - Advisor
ChristianWEmployee - Advisor
Employee - Advisor
Jun 9, 2023 7:30 AM UTC

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

Employee - Sage
JackLacavaEmployee - Sage
Employee - Sage
Jun 9, 2023 11:59 AM UTC

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.

Terms & ConditionsAccessibility statement