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. ...
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.

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.