A Customized data extract along with Process ID & Date it was ran using the Data Integration!

The requirement is to extract data from an ASO Cube from a EPM Cloud application to a .csv file, while also including the Process ID and the extraction date from the TDATASEG table.

I will not cover the steps to extract data from ASO cube, we will see how to extract the Process ID and the date it was ran using the TDATASEG_T.

The TDATASEG table serves as a repository for both the data provided by users and the transformations applied during the mapping process, capturing the relationships between original source dimension members and their resultant mappings. During the process it involves transferring data to the TDATASEG table from the staging table TDATASEG_T followed by the deletion of data in the TDATASEG_T table.

For this requirement we are considering the TDATASEG_T table to retrieve the LOADID which is the Process ID.

Added 2 columns to capture the LOADID and Date it was extracted.

  

Under the Mapping for the LOADID SQL mapping is invoked 

And the SQL statement to pull the LOADID from the TDATASEG_T table for a rule we are triggering. The Rule ID can be obtained from the table AIF_BALANCE_RULES.

Similarly for extracting the date a simple SQL to pull the Sysdate.

On Execution the rule will populate the .csv file as specified here, which is called as LoadID.csv

If you notice the Process ID is 867 and the rule executed successfully. Lets look in the inbox for the generated extracted file, 

On looking the contents of the file, LOADID & the date it was extracted is populated in the .csv file. This is great feature to customize the extracted files. 

Hope this was useful,

A big thanks to my awesome colleague who helped me in this. Nothing is impossible if you have an awesome team.