BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Year Format and sort Months


 
Search this topic... | Search Xcelsius - Crystal Dashboard Design... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Xcelsius - Crystal Dashboard Design  Previous TopicPrint TopicNext Topic
Author Message
zahmed
Forum Member
Forum Member



Joined: 14 Jan 2018

Posts: 17



PostPosted: Thu Nov 29, 2018 1:50 pm 
Post subject: Year Format and sort Months

Hi All ,

I run a dashboard on SAP Universe using Query browser

first i need to format field year to be 2017 , 2018 not 2,017 the data type of the year field is string

second i need to sort the months in Jan , Feb , March order not alphabetic ..

month field is datatype string too ..

Any Solution
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11245
Location: Manchester, UK


flag
PostPosted: Mon Dec 31, 2018 8:22 am 
Post subject: Re: Year Format and sort Months

You'll need to make changes at the universe level.
There's more to universe design than simply dragging and dropping source objects.

Format your Year without the comma.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
kevlray
Forum Associate
Forum Associate



Joined: 23 Jun 2010

Posts: 920
Location: California


flag
PostPosted: Wed Jan 02, 2019 10:04 am 
Post subject: Re: Year Format and sort Months

Probably will have to make that field a string.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Xcelsius - Crystal Dashboard Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0300 seconds using 17 queries. (SQL 0.0031 Parse 0.0009 Other 0.0260)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo