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

GROOVY SCRIPT FOR ASO data export

Received Response
157
Views
12
Comments
edited Feb 17, 2024 6:38PM in EPM Platform and Freeform 12 comments

Summary:

Hi All,


I have writeen a Groovy script to export the level0 data from the ASO cube to a csv file based on few conditions. Account dimension is not a compression dimension so had to use on the Column filter 

Content (please ensure you mask any confidential information):

List<Member> CC = operation.application.getDimension("CostCenter").getEvaluatedMembers("ILvl0Descendants(Total Cc)", cube)

List<Member> Dept= operation.application.getDimension("Department").getEvaluatedMembers("ILvl0Descendants(Total Dept)", cube)

List<Member> Customer = operation.application.getDimension("Customer").getEvaluatedMembers("ILvl0Descendants(Total Customer)", cube)

List<Member> periods = operation.application.getDimension("Period").getEvaluatedMembers("ILvl0Descendants(YearTotal)", cube)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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