Skip to Content
Former Member
Sep 28, 2011 at 01:05 PM

Sorting months/years in webi 4.0



Has anybody tried sorting cal month year in WEBI 4.0 charts as well as filters. Since custom sort does not work in WEBI 4.0, please advice how to sort with steps..

@ David Gilbertson

Thanks for your blog on sorting months in WEBI and I understand it works well in 3.1 version. I tried replicating the steps to sort the months in charts...I created the variables Month Year dimension and Year Month Code dimension. When I drag the Year Month Code into a report block along with a measure, the measure displays as #UNAVAILABLE and does not seem to be working well with the newly created dimensions. The measure displays correctly if I remove the new dimensions. My source is BW query via BICS. Appreciate any inputs.

Thank you