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.
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 different types of Filters available in BUSINESS OBJECTS?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
What is the size of data base?
BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.
5.what is LOV? where it is store?
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
What is top business?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
when will use compatible and incompatible objects?
1 Answers Business Intelligence Analytics, iGate, TCS,
Tell me about linked universe ?
what r the universe connection types?