The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

grgatlin's avatar
grgatlin
New Contributor
2 years ago

Transformation Rules (trx) Export Multiple files

Hi - Is there a way to export multiple trx at once? And where it would indicate which Account Dimension Transformation Rule it came from?
Data Integration
Transformation
franciscoamores's avatar
franciscoamores
Contributor II
2 years ago

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