Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

MDX Formula not working if member value is missing

edited Aug 2, 2018 2:36AM in Essbase 6 comments

Summary

MDX Formula not working if member value is missing

Content

Hi Gurus,

I am working on to calculate total rolling year

If its 2016 December ...its should calculate previous12 months including 201612(so 201612+201512+201511+201510.....etc 12 months)

but if 201612 data is missing  its not summing up the values even we have the values for jun2016  and july2016

no issue if we have the data for the current member..

My hierarchies are YEAR->QTRS->Months->weeks

CASE WHEN IsLevel([Time].CurrentMember, 0) AND  ( [Time].CurrentMember.Parent <> [Time].CurrentMember.Lead(1).Parent) AND ([Time].CurrentMember <> Missing)
THEN
sum(MemberRange ([Time].currentmember.Parent,[Time].currentmember.Parent.Lag(11)))

WHEN IsLevel([Time].CurrentMember, 1)  AND ([Time].CurrentMember , Missing)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!