Explain about MTD(Month To Date) and YTD(Year To Date) with
one example and where you use this in your project?
- 2 Answers
- 30165 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 type of schemas did you use in your project?Andwhy did you use that schema
REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST
can i link two Universes having with different connection
Is there any other repository domains rather than universe, security, document?
Types of universes in business objects?
What is the link option in the reporting Environment?
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
What is metrics?
Can we have multiple domains?
In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.
what is difference between WEBi Report and Crystal Report?
3 Answers Cognos, Nucleus Software, Red Cross,
Teradata 
