Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Month Nbr Formating

Hi,

Iam using Oracle 11g and BO SP5.

In Universe:

1) iam trying to display values YearMonth Dimension in format 2014008.

I have Fiscal year which is coming from database in the format as = 2010......2015

I have Fiscal Month which is coming from database in the format = 1.....12

My Need is to display as 2014008 format, i tried like below

@Select(cc\Fiscal Year) ||'00'|| @Select(cc\Fiscal Month) = > 2014001

                                                                                           ....

                                                                                           ....

                                                                                           20140010

                                                                                           20140011

                                                                                           20140012

above i have an issue while iam trying to format fiscal month 10 onwards it is prefixed with two zeros..which 20140010 instead 2014010.

2) i have period name which is in format Apr how do we change to 004 format.

Appreciate your help.

Thanks,

Dinya.

replied

Hi,

use case statement for this in universe.

example

Case

when

length @Select(Date\Calendar Month)=1

then

(@Select(Date\Calendar Year))||'00'||@Select(Date\Calendar Month)

else

(@Select(Date\Calendar Year))||'0'||@Select(Date\Calendar Month)

end

Amit

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question