I have a requirement to exclude the range [FctMonth to Jul] from the period dimension dynamically.
My Period dim starts from Sep and ends in Aug. I have a hierarchy with quarters and a flat alternative hierarchy as well.
I tried IDescendants(TotalYear) where TotalYear is the parent of flat hierarchy and excluded IRSiblings(&FCSTMonth). But this excludes all the right siblings including Aug, in my case i dont want Aug to be excluded but only till Jul.
For Example if the member Feb is assigned to FCTMonth, i should get FEB to Jul excluded from the list.
Let me please know how we cam make this work?