Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1072


how get the grand total in master-detail report?

2191


How to generate the report from excel sheet?

1133


What task is 98% of the required work of a business analyst?

1003


What are the data types present in bo? What happens if we implement view in the designer and report?

986


What is report template in b.o?

975


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4274


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1226


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3033


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10803


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1909


How were the reports scheduled and how to resolve unexecuted documents?

2636


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

979


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

942


When we use aggregate awareness function in designer?

925