Explain about MTD(Month To Date) and YTD(Year To Date) with
one example and where you use this in your project?
- 2 Answers
- 30213 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan k k pottturi
MTD MEANS REPORT FROM THE STARTING DATE OF THE MONTH AND
CURRENT DATE EX:I WANT A REPORT FOR THE MTD AUGUST MEANS
The report start date must be august 1st to today date(4
aug).same for the YTD.
WHERE WE CAN USE MEANS WE CAN USE SALES AND INVENTORY ITS
DEPENDS UPON U R REQUIREMENT
| Is This Answer Correct ? | 36 Yes | 6 No |
Answer / 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 |
can i use stored procedure in webi?
When to use local filter and when to use global filter?
Explain what are the steps to do to use alerts in bo?
what is the difference between input file repository server and output file repository server ?
how to restrict up to three levels in hierarchy when u do drill mode?
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
why less number of records in loop? why more number of records in traps?
What is the sheduling the report? What is the need of sheduling the report?
what are the all possible reasons of getting partial result on a webi report?
HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?
When we go for OLAP , and When we go for OLTP for generating the reports ?
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
Teradata 
