02-23-2024 12:32 PM - last edited on 02-24-2024 03:22 PM by JackLacava
Hi - Is there a way to export multiple trx at once? And where it would indicate which Account Dimension Transformation Rule it came from?
02-25-2024 01:19 PM
Hi,
the way I did in the past is using the following API:
OneStream.[Shared].Wcf.TransformationRuleExtractor.ExtractTrx(dbConnFW, dbConnApp, TransformationTableName)
This function returns the content of the TRX file as String so you would have to write to a TRX file.The function checks security access so only users to the transformation table can run the BR that uses it.
It should work in V7, not sure in v8 as I have not tested.
HTH
03-03-2024 05:05 AM
Hi there,
You can also export the file, in app/load-export file. Select transformation rules, and then the rules you want to download. You'll get an XML file that you can read and update if necessary.
Regards,
Carlos
03-04-2024 10:29 AM
Yup, that would be another way but it produces an XML instead of TRX
You can also automate XML extract/load with API.
Regards