This content has been marked as final. Show 2 replies
Yes, you can't create aggregation levels in Year dimension. But you have period dimension in which you can create dynamically calculated base time periods which you can use combined with No Year.
So create a member in Period Dimension called Total of 3 Years. Place a member formula in it (IF(@ISMBR("No Year") FY09+FY10+FY11; ENDIF).
You can use this period combined with No Year.
Can I make Year a "normal" dimension rather than an attribute? We are trying to find a way that we can leave the Supress Missing option ON with Essbase Add-In and still have the dimensions show up instead of getting an error message. We do a lot of AdHoc analysis and it's a pain to have to turn the options on and off continually. Thanks.