in a database date formate is in dd/mm/yy. In my report I
want when I prompt the date coloumn it should be
displayed in (yyyy/mmm/dd)format.
how could I do this
plse send me as soon as possible.
- 3 Answers
- 7110 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Change the object SQL, I mean in SELECT class of that
object conver that by using the to_date or correct syntax.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / aditya
create a derive table for that
select to_char(hire_date,'yyyy/mmm/dd') as date from
employees
it will work when you use in the prompt
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / yogendra
Go ahead and make the change in the .prm file. So you will
be doing the change only once. And it will be universal for
all the objects.
| Is This Answer Correct ? | 2 Yes | 1 No |
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?
What are the steps to taken care to improve the Report performance?
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
How can you first report in Business Objects by using broadcast agent?
0 Answers Ness Technologies, Wipro,
what are they different types of report in BO?
what is custom sorting?how we can do this expalain with procedure???
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
Explain how to schedule the report in b.o?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Teradata 
