Webi Date Format
Hello - I am on Business Platform 4.0 SP4 Patch2 and using Webi with a OLAP connection to a multiprovider on a BW system and run a BEx query. I am retrieving a date field (OBILL_DATE) which defaults to dd.mm.yyyy. I want it in the format mm/dd/yyyy. When I right click on the column, I do not get the option "Format Number" like I do on other number columns. How can I change the format? I have tried both Webi Rich Client and Webi from the BI Launch pad. When looking in BW (RSA1), using Analysis for Excel, or using CR for Enterprise it is fine. Any help will be appreciated.
if I understand your problem correctly this could help...
Insert the regular dimension field [OBILL_DATE] into the table.
Create a new variable, e.g. "varDisplayBillDate" with qualification "Measure" with a formula looking something like:
Insert the new variable (e.g. varDisplayBillDate) into the table
right-click on the regular dimension field [OBILL_DATE] and hide dimension