Interested to Buy Any Domain ? << Click Here >> for more details...
Explain about MTD(Month To Date) and YTD(Year To Date) with
one example and where you use this in your project?
- 2 Answers
- 31439 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 |
what is the syntax for aggregate awareness?
3 Answers Exilant, i-Tree, Wipro,
Can i merge two dataproviders if they do not have common column?
what is meant by slowly changing dimensions?
Explain is there any default username & pwd for bo designer & supervisor?
What is the difference b/w breaks and sections
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?
What would you consider as your biggest achievement and why?
What is the difference between condition & filter?
What is casual dimension?
How to create an popup in the WEBI report if the report is showing partial result?
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)
Teradata 
