Explain about MTD(Month To Date) and YTD(Year To Date) with
one example and where you use this in your project?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the difference between detect alias and detect context?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What is the difference in creating filters in designer and business objects?
Difference between zabo and webi?
What is object stores?
What is a fantrap in business objects?
What would you consider as your biggest achievement and why?
Explain in detail about type 2(scd),
what are the tables used in health care domain project and columns used in report?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain what three things do you consider to be the most important factors for a manager?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain about a tricky situation for which you found a very simple solution?
What is the difference between datawarehousing and businessintelligence?