EPBCS groovy CustomCalcParameters script syntax issue
Hi All,
I'm struggling with MDX syntax to calculate actual to Date using groovy CustomCalcParameters. Although when I use RHS part of the script Sum(TupleRange(([FY20],[Mar]), ([Years].CurrentMember,[Period].CurrentMember)),([Cost],[OEP_Working],[Total_TL]))in dynamic calc member formula for Actual_To_Date member in accounts dimension, it is working perfect.
Below script gives me error message: A method called by the script failed on line: 13, with error: Syntax error in input MDX query on line 1 at token )
Cube cube = operation.application.getCube("PCRrep")
CustomCalcParameters calcParameters = new CustomCalcParameters()
String sPOV = 'Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin({[ACT]},{[GBP]}),{[Final]}),{[No Custom2]}),{[EN_3011]}),{[Porject1]}),{[WBS1]}),{[Line1]}),{[FY24]}),{[Feb]}),{[No Custom1]})'
Tagged:
0