on 10-18-2012 6:14 PM
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.
Hello Kelly,
You infoobject is a date so you wont get the formate number function.
You will have to use the Formate Date function to formate the 0bill_date in WEBi
Thanks,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kelly,
Whats the data type of 0bill_date?
If its a number: You will get the option of format number
If its a string or date : you wont get the option to format number
Solution:
If its a date:
Create a variable
VAR1 = FormatDate(0bill_date();"MM/dd/yyyy")
if its a string:
You will have to first convert it to date using function ToDate (conver string to date) and then use the function FormateDate to get the date.
You can use the new variable as the column.
OR
If you convert it to data type date and use it in the column you will get the option for formatedate too.
Thanks,
Vinay
Vinay - I am thinking it may be a Webi bug. It is a date field coming out of BW, so the number format option should show up, but it does not. I am having to bring over the date key part of the dimension or the dates do not show up at all...and I have to bring that over before any other key figures or I get an error. There are no issues with Analysis for Excel or CR for Enterprise running same query. Time to open a message I guess.
Thanks,
Kelly
Hi Kelly,
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:
=FormatDate(ToDate([OBILL_DATE];"dd.MM.yyyy");"MM/dd/yyyy")
Insert the new variable (e.g. varDisplayBillDate) into the table
right-click on the regular dimension field [OBILL_DATE] and hide dimension
Regards, Uli
Hi Kelly,
I was wondering what the OSS message is you raised, so i can refer to it also. We have the same problem. I can not create a variable as you did, because im using webi (based on a bex query) for my dynamic recipients where the date is used as a parameter. So variables are not shown in publication.
Kind regards,
Raymond
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.