This discussion is archived
3 Replies Latest reply: Sep 20, 2013 3:40 PM by user13160088 RSS

Suppress decimal places in OBIEE Year column prompts

968496 Newbie
Currently Being Moderated
Hi gurus,
I don't know its a bug or what , in our database the "Year" columns comes without any decimal places ,also in the criteria section of the report ,I have made the data format "with '0' decimal places ", but still in the column prompt in the dashboard , I am getting year value with decimal places .
Eg. 2012 coming as 2012.00 in choice list of the prompts . Can you provide me any work around? for that thanks in advance..


  • Correct Answers - 10 points
  • Helpful Answers - 5 points