Dayalan Punniyamoorthy Blog

Thursday, April 18, 2024

Groovy Rules Calling Enterprise Profitability and Cost Management Rules using REST API!


Using the Groovy script we can invoke the following REST API provided by an Enterprise Profitability and Cost Management system.

  • Calculate Model - Runs the calculation on a given point of view in a selected cube.
  • Clear Data By Point of View - Clears the data for a given point of view in a selected cube.
  • Copy Data by Point of View - Copies data from a source to a destination point of view in a selected cube.
  • Delete Point of View - Deletes the data associated with a point of view from the calculation cube.
  • Generate Model Documentation Report - Generates an Enterprise Profitability and Cost Management Model Documentation report. Any validation failures are written to file with file name provided in the parameters and can be accessed from Inbox/Outbox Explorer.
  • Validate Model - Automates the calculation process for validating a model. Any validation failures are written to file with file name provided in the parameters and can be accessed from Inbox/Outbox Explorer.
  • All this are asynchronous call, so use the job status URI to determine whether the operation is complete. For running all the above REST API Required Roles is Service Administrators.

Thursday, April 4, 2024

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.