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
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Can anybody tell me what are the tuning problems?
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
what will be the contents for a functional requirements specifications
Explain what is the difference between slice and dice and cross tab report?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain what would you consider as your biggest achievement and why?
How can you first report in Business Objects by using broadcast agent?
What is the difference between datawarehousing and businessintelligence?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is the dense rank?
8. How much supervision have you typically received in your previous job?
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??
How to generate the report from excel sheet?
in sap bi we have wad, then why we go for sap bo