Has MDX changed between 21.5.3 and 21.5.6?
We run Essbase with EPM. I updated EPM 11.2.15 to 11.2.18, which updated Essbase from 21.5.3 to 21.5.6.
The following MDX query does not return data in 21.5.6 but returns data in 21.5.3. I loaded the cubes in both environments with the same data. I do not know much about MDX. Do I have to change this query in some way to work with 21.5.6?
SELECT
{[Actual]} on Columns
,CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(
{
Descendants([Income_Statement],20,LEAVES)
}
,Leaves([603]))
,Leaves([Department]))
,Leaves([Location]))
,Leaves([Source]))
,Leaves([Type]))
,Leaves([Detail]))
,Leaves([ICP]))
,Leaves([Generic]))
,Leaves([FY24]))
,Leaves([Jul]))
on Rows
FROM PLANFS.FS