Skip to Content
author's profile photo Former Member
Former Member

Sorting of months in Explorer

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 22, 2013 at 02:57 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.