hi friends,

In our project , all the reports have underlying SQLs which fetch data. The views for each report are deployed in the metadata as a separate data source. For 11 reports , we have 11 Data sources correspondingly in metadata.

We have to include the ETL Data load time in all the reports. This time stamp is coming from a different data source ETL_RUN_STST.

So i used the concept of MATCH to merge two discrete Data sources. ( One data source being the view and the other being ETL_RUN_STST) and form a hold file.

In the master file of the view, we give customised titles to all the report columns.
But when i run the hold file , customised titles are not getting displayed , instead the default titles are displayed for the report columns.

Please advice.

AArvind,

Try SET HOLDATTR=ON
It will propagate the master file title to the hold file.
The default is SET HOLDATTR=FOCUS, which will propagate only for focus files.

Hope this helps ...

thank you very much mickey ,

One more doubt , in the data source ETL_RUN_STST the job id '9999' corresponds to reporting. So i used a simple where statement to pick the time stamp related to reporting in the match file.

After the Where statement the ETL_RUN_STST table has one row data corresponding to reporting.
Below is the code

MATCH FILE RIPTEST/T_ORA_SRVC_INV_V
PRINT SERVICE_ID SERVICE_NAME SERVICE_TYPE SOLUTION_NAME NEXT_STEPS_INSTRUCTIONS NEXT_STEPS_QUESTIONS_ANSWERS NEXT_STEPS_LINK NEXT_STEPS_IWR NOTIFICATION
BY SERVICE_OWNER
RUN
FILE RIPTEST/T_ORA_ETL_RUN_STST
PRINT ETL_STG_I ETL_LNK_I ETL_LNK_TYPE_C JOB_RUN_STRT_TS JOB_RUN_END_TS JOB_STAT_C STG_RUN_STRT_TS STG_RUN_END_TS
BY JOB_I
WHERE JOB_I EQ '9999'
AFTER MATCH HOLD OLD-OR-NEW
END

When i add the timestamp column in the print statement of the hold file.The timestamp appears only in the second row of the output.Rest of the rows are blank for that column.Is there any way where i can display 0 for the rest of the rows for that column??

I tried using Define , it s not working.
Please advice.

hi ,
I am still not able to display misssing values in a hold file. I want to display 0 for missing values