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
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is the difference between datawarehousing and businessintelligence?
how many reports have u created ? explain a few.
what is the difference b/w the refresh and buffered data?
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.
What Is The Difference Between Oltp And Olap?
Can we create universe with no cache??
What is thumbnail?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What are the steps to do to use alerts in bo?
what are the tables used in health care domain project and columns used in report?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain when we use aggregate awareness function in designer?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.