You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Export with Pivot Dimension

edited Oct 8, 2024 8:20PM in EPM Platform and Freeform 5 comments

Summary:

Hello Wizards,

I have requirement to export BSO data (Non Num as well) to csv file with Account dimension on the column (Pivot).

Expected Output (StartDate and ACC_3456 are member of account dimension):
Years | Entity | Employee | StartDate | ACC_3456
FY23 | E_0101 | Emp 1 | 03/09/2024 | 10000

I have used createDataExporter and were able to export the data in similar manner. However, There is an extra row for pivot dimension members.

Cube cube = operation.application.getCube("OEP_WFP")
cube.createDataExporter()
.setDateFormat("dd/MM/yyyy")
.setDelimiter('|')
.setColumnDimension("Account")
.setColumnMemberNames(["StartDate","ACC_3456"])
.setRowDimensions(["Years", "Entity", "Employee"])
.setRowFilterCriteria("BU_01", "E_0101", "FY23", "BegBalance", "OEP_Working", "OEP_Actual", "Emp 1")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!