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
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
how get the grand total in master-detail report?
How to generate the report from excel sheet?
What task is 98% of the required work of a business analyst?
What are the data types present in bo? What happens if we implement view in the designer and report?
What is report template in b.o?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
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?
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?
How were the reports scheduled and how to resolve unexecuted documents?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
When we use aggregate awareness function in designer?