Skip to Content
0
May 06, 2013 at 04:32 PM

Date format webi vs bex

99 Views

Hello Experts,

I have created a webi report on BICS connection, report contains Date dimension which is comming from the bex.

The Date format comes with this format "dd/MM/yyyy" in the bex report, but in the webi its displaying like this "dd.MM.yy"

But i can give a FormatDate() formula to get rid of this, but user is saying not to create a variable or formula in the column to display

"dd/MM/yyyy", because of confusion with too many dates in the filter.

The requirement is let there be one field in the available objects, when user drops the date field to the report it should display the same as in the bex

"dd/MM/yyyy".

Appreciate your thoughts on this......

Thanks,

Vinay