Skip to main content
P
prash4030
December 9, 2025
Solved

Automated Extraction of Transformation rules

  • December 9, 2025
  • 1 reply
  • 0 views

 

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!

Best answer by MarcusH

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.

1 reply

M
MarcusHAnswer
December 10, 2025

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