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
- 31248 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 tell me about issues faced while creating universe. thanks in advance
suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
When to use local filter and when to use global filter?
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
can BO generate reports with out CUBICAL data to repository?
What is DSS?? (Defination of DSS)
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
. User wants to modify a report and wants to add additional data. How will you approach.
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?
Teradata 
