Month Nbr Formating
Iam using Oracle 11g and BO SP5.
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
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.