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
Explain the difference between union and group?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
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?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain the data types present in bo and what happens if we implement view in the designer and report?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain how to schedule the report in b.o?
Explain difference between zabo and webi?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What is top business?
Can you please send me the migration related issues .
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??
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?