Transformation Rules (trx) Export Multiple files

[grgatlin]

Hi - Is there a way to export multiple trx at once? And where it would indicate which Account Dimension Transformation Rule it came from?

[franciscoamores]

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

[CarlosAlvear]

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

[franciscoamores]

Yup, that would be another way but it produces an XML instead of TRX

You can also automate XML extract/load with API.

Regards