Skip to main content
A
Akalya_N
January 24, 2024

FDXExecuteDataunit

  • January 24, 2024
  • 1 reply
  • 0 views

Hi Community...! Here I'm getting Zero but instead of this I want to get  accounts data for that...Can you please share me some insights or some reference for this...?
I'm using FDXExecuteDataunit method for this


Akalya_N_0-1706073521591.png

 

1 reply

M
MarcusH
January 24, 2024

You haven't given us much information but I will give it a go. It is retrieving 107K rows - are they all zero or is that just the first page? You could try suppressing zeroes in the FDXExecuteDataUnit call. Have a look at this page 

A
Akalya_NAuthor
January 24, 2024

Nope...What I meant is, I can able to get raw data by using FDXExecuteDataunit, and then I want to manipulate rows and columns according to my requirements...
My requirement is like, I want to display Jobname, Accounting method, Revenue, GP, Etc .. I can get Jobname and Accounting method from UD4 and UD5 but i just want to know, how to get remaining Account data.. In this below picture you can see how I want


Akalya_N_1-1706087129993.png

 

 

J
JackLacava
January 24, 2024

FdxExecuteDataUnit only retrieves stored records. Looks to me like you want a bunch of data from DynamicCalc accounts. For that, you'll have to set a Cube View and then use FdxExecuteCubeView instead.

Terms & ConditionsAccessibility statement