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
- 31381 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 anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?
Did you face any problems while creating reports? Name? Solutions?
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
any difficulitis have you phase while creating bo reports and how did u solve it
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
can u create report to connect oracle and sqlserver at a time?
What is the difference between absolute and relative div positioning?
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?
Teradata 
