The rex file is a text file that represents almost the same data captured in the rdf file.
The rdf file is the file format used by Oracle report to capture itself metadata.
I wrote a utility while I worked in the financial architecture at Oracle to cover the single org reports to support cross org reporting.
The logic is as follows:
The goal was that the report developers do not have to convert their report one by one. The utility will do the job.
I am a big fan of code generation.
The rwcon60 command line program is used to convert between the different file formats:
The rdf file is the file format used by Oracle report to capture itself metadata.
I wrote a utility while I worked in the financial architecture at Oracle to cover the single org reports to support cross org reporting.
The logic is as follows:
- Find the table that is multi-org enabled in the report definition
- Change it to use the _ALL table instead of the single org view
- Add the join criteria
- Add the new filter that can return more than one org.
- Make the report to run under these three context: Set of Books level, Legal Entity level, and OU level
The goal was that the report developers do not have to convert their report one by one. The utility will do the job.
I am a big fan of code generation.
The rwcon60 command line program is used to convert between the different file formats:
- rdf -> rex
- run a utility to change the rex file
- rex -> rdf
No comments:
Post a Comment