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

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

3839


Can anybody tell me what are the tuning problems?

1582


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4435


what will be the contents for a functional requirements specifications

1775


Explain what is the difference between slice and dice and cross tab report?

596






Explain the data types present in bo and what happens if we implement view in the designer and report?

555


Explain what would you consider as your biggest achievement and why?

569


How can you first report in Business Objects by using broadcast agent?

2593


What is the difference between datawarehousing and businessintelligence?

607


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

616


What is the dense rank?

665


8. How much supervision have you typically received in your previous job?

1824


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3908


How to generate the report from excel sheet?

576


in sap bi we have wad, then why we go for sap bo

2770