Sorting of months in Explorer

[Former Member]

Hi,

We have the following requirement in Explorer,

Customer has defined the financial year as April to March. But Explorer provides the sorting of months as "Jan - Dec". We set the character based sorting it will get sorted as April, August,....

So is there any possible way of sorting the month as April, May, June,... in Explorer.

Thanks,

Ravi

[Former Member]

HI Ravi,

what is your source? For non accelerated you can specify the dimension object to be of date type prior to Indexing. For BWA we don't have Date type, in Explorer will be treated as text, you may have to use the Key object for proper sort.

[Former Member]

Hi Geoge Pertea,

Thanks for the reply. Here the actual problem is on sorting of months in the Indian Financial year format (ie., April to March). Data Source is UNX based on relation connection to BW.

In BW, posting period is defined as 1 to 12. At IDT level, these posting period is mapped to month name. eg: case when @select {......./posting period}=01 then "APR"

                          when @select{....../posting period}=02 then "MAR"

                        ......

                        ......

                    end

In Explorer if we select the sorting option as "JAN - DEC", it sorts according this format.

But there is no option available in Explorer to customize this sorting. ie., sorting the months as "APR- MAR". Please let us know if any options are available to handle these type of requirement.

Regards,

Ravi