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

How to restrict password to a user while sending a document in .pdf format

2272


When to use local filter and when to use global filter?

947


Can we configure two instances of CMS pointing to two different CMS system databases?

1971


Explain how we drill up week to month?

1042


Explain when to use local filter and when to use global filter?

1304


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?

10762


Explain what is the difference between business requirement document and use case document.

964


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

1058


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

1210


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2130


explain in detail about type 3?

953


What is the difference between datawarehousing and businessintelligence?

1036


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1994


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1165


What sort of existing documents should business analysts refer to when starting on a new project?

967