12-15-2014 03:54 PM
I have an instalation of SAS Financial Management 5.3 with SAS 9.3. We have to extract data loaded into SASDM MySQL database to generate versions of budget and load these versions again to FM. To do this extraction we are using pre-built macro FMQuery
Process used by FMQuery is rather inefficient. After set the extraction parameters extraction, fmquery query and extract all combinations of data, even with value 0. For avoid this, I design a macro program that extract data partially. When I execute the program, sometimes, process fmquery fails, but when I run fmquery with the combination that cause error, it works fine.
Have you ever used FMQuery to extract data from FM database?