How to use Fast Formula in HCM Extract

Requirement 
Can we use Fast Formula in HCM Extrat to derive any Database calculation ?

Solution 
Oralce provides rule type attribute in HCM extract.  We can use this type to use fast formula driven attribute. 

In order to access Fast formula in Extract attributes, use type = "Extract Rule" 

If using GET_VALUE_SET method to cal value set ( only TABLE type value set are supported). Please ensure you pass value to ID field as well.  

How to schedule a report with timestamp in filename

 Requirement 
Schedule a report to deliver output file with timestamp in filename so it can be differentiated 

Solution
Dynamic filename can be achieved using 2 ways - 

1) User delivery option manually in schedule

In this method in delivery tab, select the delivery method and use below syntex in filename - BIPReport_%y%m%d%H24%M%S.txt

2) Define bursting and use SQL method of appending timestamp in filename parameter -  

'BIPReport_'||to_char(SYSDATE, 'YYYYMMDDH24MISS'||'.txt' PARAMETER5

How to default Date value in parameter

Requirement

Default dynamic date parameter values 

Solution 

Use following predefined function to default date para,eters -

 {$SYSDATE()$}                            – current date

 {$FIRST_DAY_OF_MONTH()$} – first day of the current month

 {$LAST_DAY_OF_MONTH()$}  – last day of the current month

 {$FIRST_DAY_OF_YEAR)$}      – first day of the current year

 {$LAST_DAY_OF_YEAR)$}       – last day of the current year

*Dates are system date of the server on which BI Publisher is running.

Example