cancel
Showing results for 
Search instead for 
Did you mean: 

SAP OLAP Universe - Date

Former Member
0 Kudos

Hi all i am getting below problem .. please let me know solution where can i convert char to date

Date is reflected as Characters in BO. Despite changing it at the Universe level (From Character to Date)

User Prompt : Between "Start Month-Yr" and "End Month-Yr"

User Response Start Month-Yr Jan 2005

End Month-Yr Mar 2005

Desired Ouput: Jan 2005 Feb 2005 Mar 2005

Actual Output Jan 2005 Jan 2006 Jan 2007 Jan 2008 ..(Till the data availability for JANu2026.)

Jun 2005 Jun 2006 Jun 2007 Jun 2008 ..(Till the data availability for JUNu2026.)

Jul 2005 Jul 2006 Jul 2007 Jul 2008 ..(Till the data availability for JULu2026.)

Mar 2005 Mar 2006 Mar 2007 Mar 2008

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

This is not a date issue but a problem that the values are sorted alphabetically.

Didier

Former Member
0 Kudos

so how to resolve this problem ?