What is the syntax for the ROUND function in an MDX query?
We are using on-premise Essbase 21c, version: 21.5.3.0.0, build: 027. I need to round the values from the MDX query to 2 decimal places. I'd rather do it in MDX then have to add it to my Excel ETL.
I've tried many versions of this by place ROUND in different places in the SELECT line, but get the same error: Essbase Error (1260052): Syntax error in input MDX query on line 1 at token 'ROUND'.
SELECT { ROUND([CurrencyNoScale],2)} ON COLUMNS,
NON EMPTY
CrossJoin( { /*[Nov],[Dec],[Jan],*/[Feb],[Mar],[Apr],[May],[Jun],[Jul],[Aug],[Sep],[Oct] },
CrossJoin({([FY24],[Final],[JanFcst])},
CrossJoin({[CoreData]},
CrossJoin( {EXCEPT( {DESCENDANTS([Financial Services
0