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
Solved
Automated Extraction of Transformation rules
We have a recurring requirement to share the transformation rules/logic on a regular basis with downstream teams or auditors.
Currently, this is being done manually, which is time-consuming. ...
You can extract Transformation Rules using Business Rules. Search the forum for XmlExtractOptions to give you some ideas. I have only ever extracted all the items so I do not know how to specify just the Transformation Rules. However you can read the output from the ApplicationZipFileHelper.Extract function and pick out just the Transformation Rules xml.
I don't think it is possible to view Transformation Rules through Cube Views.
I have written an Excel xlsm that reads and writes Transformation XML and trx files. It is a manual process but it puts the TRs into a readable format. DM me if you want it.
You can extract Transformation Rules using Business Rules. Search the forum for XmlExtractOptions to give you some ideas. I have only ever extracted all the items so I do not know how to specify just the Transformation Rules. However you can read the output from the ApplicationZipFileHelper.Extract function and pick out just the Transformation Rules xml.
I don't think it is possible to view Transformation Rules through Cube Views.
I have written an Excel xlsm that reads and writes Transformation XML and trx files. It is a manual process but it puts the TRs into a readable format. DM me if you want it.