Interested to Buy Any Domain ? << Click Here >> for more details...
i am facing date format issue in webi report in BI4.0
environment.
i have unx based on Mysql connection.
date is coming in 10 digits numeric format like(2345623456).
I want to change it in dd.mm.yyyy format.
Please suggest
- 3 Answers
- 8869 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siri
by using FORMAT NUMBER function we can change the numeric format
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gowthami
Right click on the column and do date formatting.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / avijit paul
create a variables to get the individual digits and then
concat the extracted digits. you can change it to date
format also using todate().
| Is This Answer Correct ? | 4 Yes | 5 No |
What is the size of data base?
what are the complex reports you have created. Tell me with example?
Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
How will you know the version of Bo using designer?
4 Answers Tavant Technologies,
What is broad cast agent?
How would I achieve Traffic Lighting in Business Objects
how to connect the hyperlink in webi reports?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
why less number of records in loop? why more number of records in traps?
what is diff between webi,deski,infoview
Teradata 
