Top 50 BI Publisher Reporting Interview Questions

Interview Questions on BI Publisher Reports:

1. Can we create multiple data sets which aren’t inter dependent in BI Reports?
2. Can we create bursting query to burst the complete output to single FTP server without splitting by any key?
3. Can we use before or after triggers in BI Report in Fusion?
4. Can we write Non-Standard SQL in BI Report and what’s the advantage of it?
5. Can we use an attribute selected in one dataset in another dataset?
6. What is the difference between Split by and Deliver by fields while setting up bursting?
7. How to turn off the auto-run for BI Reports?
8. Can we achieve dependent parameter lookup for BI prompts?
9. Can we make an input file required on BI Report?
10. Can we get the BI output in .csv format by using a custom template without input values getting shown on the .csv file?
11. In which cases do we use rtf/etext and excel templates?
12. If we use excel template can we get the output on the interactive viewer online when we run the report?
13. Can we get excel output in multiple worksheets split by department/business unit if there is a requirement?
14. Is it possible to generate an excel output with different tabs using rtf template?
15. Can we show person images on BI Report?
16. Can we create master detail BI reports with one linking to another using an hyperlink?
17. Can we use deep links in BI Report and pass parameters to navigate to that page directly when an employee/manager receives an email using bursting?
18. Can we create BI Report which produces output in HDL format so that it can be loaded directly on HDL without any modifications to it?
19. Can we add the BI Reports to Dashboard? How does the BI prompts work?
20. Can we generate an encrypted output from BI Report?
21. Is it possible to upload the output of BI Report to UCM?
22. How to add dynamic date parameters to BI Report parameters?
23. Can we run the reports from Payroll flow?
24. Can we change the default timeout settings of BI Publisher report?
25. Can we retrieve the XML output of the BI Report which is scheduled? If yes how to retrieve it?
26. How to enable diagnostic log for BI Reports?
27. What are session variables and how to use them in BI Report?
28. Can we achieve QR code in BI Report?
29. Is it possible to add digital signature to BI Report?
30. Can we create multi-lingual reports in BI Publisher?
31. How to customize seeded templates? Will the seeded template also change when we change the custom template?
32. How to set custom permissions to BI Report?
33. How to set custom scheduling of BI Report to schedule on alternate days and skip on first and last day of month?
34. What’s the use of schedule triggers in BI Report?
35. If a schedule trigger is setup on one data model, can we use it to schedule another report as well?
36. Can we invoke BI Report using web services?
37. What is the output format of BI Report when you run it using web services?
38. Can we add BI Report as hyperlink to the navigator and hide the BI catalog, headers and other options?
39. Can we create Job and Job Set for executing multiple BI Reports at once?
40. Can we create dynamic password pdf and excel output using BI Report?
41. Can we get the CLOB fields in html format on the BI output?
42. Can we create audit report for Business object changes?
43. Can we audit the BI Report and check which report was run by which user and when?
44. Can we create PDF templates with form fields and use it to fill information using BI Reports?
45. Can we use flex fields on BI Reports?
46. Can we use an excel file as data source in BI Reports? Can we map the excel field to another data set field to get the output?
47. Is it possible to use web service as input to data model?
48. Can we get the zipped pdfs directly from BI Report without using any additional coding outside of BI?
49. How to use caching feature in BI Reports and is it advisable to use it every time?
50. What is the usage of XSL style sheets and how do they work with BI Reports?