Osman Eyup

Get target schema name: <%=odiRef.getSchemaName("D")%> Get target table name: <%=odiRef.getTargetTable("TABLE_NAME")%> sample code: drop synonym <%=odiRef.getSchemaName( "D" )%>.syn_<%=odiRef.getTargetTable( "TABLE_NAME" )%> output: drop   synonym  XXTG_HR_STG.syn_BEN_BENFTS_GRP further codes will be here in a while

Some of my customers want to see detailed Usage Tracking Report with  all objects created in the repository whether not been clicked once. For this I'm planning to do:    - export the whole objects list with required columns from repository to csv file,    - then import it to DB as a table ,   - and then outer join this table to my Usage Tracking report table as required.   - Finally  every night ODI triggers the command line below  on the BI server : ./runcat.sh -cmd report -offline /u01/mw_home/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/ -outputFile /media/sf_expdp/CATALOG/export_object_names.csv -delimiter ";" -distinct -type "Analysis" "Name" "Created" "Creator" "Modified" "Modifier" "Owner" "Subject Area" "Path"