Skip to main content
G
grgatlin
February 23, 2024

Transformation Rules (trx) Export Multiple files

  • February 23, 2024
  • 2 replies
  • 0 views

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

2 replies

F
franciscoamores
February 25, 2024

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

C
CarlosAlvear
March 3, 2024

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

F
franciscoamores
March 4, 2024

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

You can also automate XML extract/load with API.

Regards

Terms & ConditionsAccessibility statement