Skip to main content
prash4030
Newcomer
Dec 9, 2025 4:02 PM UTC
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.  

Is there a way to automate the extraction/export of transformation rules?  
Some options I’m thinking of:  
- Can this be done via Business Rules (BR) / Decision Model (DM) modules?  
- Is it possible to extract or view all applied transformation rules directly through Cube Views?  
- Has anyone built an automated solution (e.g., a dashboard, cube view, report, or extender rule) to export/list all transformation rules in a readable format?  

Would really appreciate your thoughts or examples if you’ve implemented something similar.  

Thanks!

MarcusHAnswer
Expert
Dec 10, 2025 8:59 AM UTC

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.

View in thread

1 reply

MarcusHAnswer
Expert
Dec 10, 2025 8:59 AM UTC

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.

    Terms & ConditionsAccessibility statement