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
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 are the traps ? What are the disadvantages of traps?
How many ways you can restrict data in business objects?
what happens if cardinalities are not resolved?
Shall we connect to the oltp systems directly .,
Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.
2 Answers Cap Gemini, Infinity, TCS,
while migrate bo 5.1 report into boxir2 ,what are the problems faced
What is the difference between the public object&schema object?
How to change font color of values in hyperlinked columns?
define universe parameters?
is there any limit for rows and columns in cross tab
WHAT IS SYNCHRONIZATION IN BOXI?
How will solve a loop caused by lookup table without using alias?