Forum Discussion

prash4030's avatar
prash4030
New Contributor III
3 months ago
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!

Data Management
Transformation
  • MarcusH's avatar
    MarcusH
    2 months ago

    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

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    2 months ago

    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.