Explain about MTD(Month To Date) and YTD(Year To Date) with
one example and where you use this in your project?
Answer Posted / sri
Eg for the MTD report is
select sal from emp where hiredate between
trunc(sysdate,'mm') and sysdate;
same for the ytd,qtd place yy or q respectively
| Is This Answer Correct ? | 14 Yes | 13 No |
Post New Answer View All Answers
What are the steps to do to use alerts in bo?
Explain what is the difference between slice and dice and cross tab report?
What is the difference between user and versatile user?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Difference between zabo and webi?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Difference between b.o 5.1 and 6.1b?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What are all difference between business objects 6.5 and xi r2?
how get the grand total in master-detail report?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain difference between zabo and webi?
How were the reports scheduled and how to resolve unexecuted documents?
What are the steps to be taken to schedule the report?