Rolling months reports
I am trying to do a rolling 12 report in FR against an Essbase application (11.1.2.1). Hope that someone can offer me some answers:
1. I am using the function "Relative to Prompt for Month offset by 1" to move between the months. However, in the hierarchy for months I found out that I have other level zero members than Jan through Dec. As a result, when I move across the hierarchy I get non desirable info:
YearYearYearYearYearYearYearYearYearYearYearActualActualActualActualActualActualActualActualActualActualActualActualJunJulAugJanOctYTD