Groovy MDX script to get HTD value
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
Tagged:
0