Explain about MTD(Month To Date) and YTD(Year To Date) with
one example and where you use this in your project?
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 |
Difference between Decode and Case?
I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Can i use personal database connection to the Webintellegence reports?
IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER
I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?
what is universe
How to sheduling the report ? What is the need of it?
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
what are the debuggings in the business objects?
Explain how many universes can be created in a project?
5.what is slowly changing dimension ?