Hyperion EPM General (MOSC)

MOSC Banner

Has MDX changed between 21.5.3 and 21.5.6?

edited Aug 27, 2024 6:08PM in Hyperion EPM General (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center