Skip to Content

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

How to customize the BW Key type date format in Web Intelligence

hi experts,

I want customize the two different date formats from BEx to WEBI, I have two different date formats in BW end,

1.Dimension type

2.key type

In Webi, for dimension type objects I can able to customize easily usingĀ  =FormatDate([ BW Dimension Field Obj Name];"dd/MM/yyyy")

I am facing issue for Key type

In Webi, when I try to apply the same approach for Key value it showing an error

=FormatDate([BW Key Field Obj Name];"dd/MM/yyyy")

Error is

The expression or sub-expression at position 12 in the 'FormatDate' function uses an invalid data type. (IES 10037)

required to convert using any Todate function or any other option is in place

Need your inputs

Regards,

Balaji

Tags:
replied

Hi Balaji ,

It is always recommended to use INPUT_DATE /INPUT_DATE_TIME in date formatting .

If it is only to get format like you mentioned then use =replace([Date - key],".","/") or use

=FormatDate(ToDate([Date - Key];"dd.MM.yyyy");"dd/MM/yyyy")

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