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 MDX script to get HTD value

edited Jun 21, 2024 8:23PM in Essbase

Hi Folks,

Can you please help me writing MDX script in groovy to calculate HTD value or at least YTD value.

Below script is throwing error: A method called by the script failed, with error: The expression is invalid

String project = 'Project1'
String prevWBS = 'WBS_123'
String prevTLine = 'Line1'
String targetWBS = 'WBS_345'
String sTargetLine = 'Line1' Cube cube = operation.application.getCube("PCRrep")
CustomCalcParameters calcParameters = new CustomCalcParameters()
String sPOV = 'Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin({[ACT]},{[Local]}),{[Entity1]}),{[No Custom1]}),{[No Custom2]}),{[Final]}),{'+mdxParams(project)+'}),{[FY24]}),{[Feb]})'
println("sPOV:"+sPOV)
calcParameters.pov = sPOV

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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