Discoverer Dashboard and Intelligence
Why should you document your Discoverer and BI Objects?
Click - Complete list of available portlets and metrics
Documenting your Discoverer Business Area, Folders and workbooks is a good idea because it helps you keep track of your BI inventory. Your reports and dashboards are part of the BI inventory and as an IT administrator, it is always a good practice to keep track of any changes to your BI inventory.
If you were running your own hardware store, would you be keeping track of your store inventory?
On similar lines, you should treat every object that caters to running your organization or business as part of your IT inventory.
What are the features?
Complete list of metrics
- This a real-time dashboard
- Perform live queries against your Discoverer meta-data
- Create instant documentation in PDF with bookmarks for easy navigation
- Create Drill-thru HTML documentation for publishing on your intranet and creating a Discoverer KB(knowledge base)
- You can check-in your generated PDF into source control such as PVCS and keep track of any changes
Please check these Sample Reports
Check this list of available portlets and metrics
Check this video for quick guide on how to generate Documentation for your EUL
If you are looking to generate similar documentation against your own Discoverer environment then please follow the steps below.
- Download Infocaptor
- Launch InfoCaptor. Connect to the database as the EUL owner (e.g eul5_us).If you are using ‘Apps’ based EUL then you could login as ‘Apps’ check this article for help connecting Connect to Discoverer Database
- Download Installation Wizard/Dashboard and open the disco_report_install.icv file from InfoCaptor.
- Follow the instructions shown on the screen. Click here for more information
- Next, Download the Discoverer Dashboard/Report Definition
- Open disco_report.icv file from InfoCaptor.When you launch for the first time, select the database connection from the live connection list.
- The dashboard parameters may not populate for the first time. Just click on each Parameter
Here is the parameter list- EUL Owner
- BA Creator
- Workbook Creator
- The Dashboard should open in Tree mode, if it is not then click on the “Tree icon - Toggle Tree and Dashboard view” located on the far right on the Toolbar.
- Once you have all the parameters working, then click on the ‘Business Areas’ node. It should display the results. You can double click on the node to refresh again. Right click on the “(Drill++) Business Area” column. You will see a list of all defined drills. Click on any drill e.g “Folder Details” and it will show the corresponding information.
- You can select the checkbox by right clicking on the node and select it to include in report export.
- You can right click on any node on the Tree and it will display a list of available export options. Pick any export option such as PDF or HTML. Once you start the export, there will be a progress bar running on the toolbar (Top section). If the export is taking long time, you can request to stop the export at any time during the operation. The export will abort cleanly as soon as it finds the right moment and display the incomplete output in PDF or HTML. For initial testing, select only few nodes in the Tree to be included in the report.
- You can specify the export directory and file name on the “Export Options” button on the toolbar.
- Similarly try other export options with complete dashboard and Html output.
- Play around with colors and formats. There are lot of other things you can do to exclude certain nodes and change the color scheme.
Get the Free License key by emailing to infocaptor@gmail.com
More Discoverer Dashboards - browser and intelligence
Once done with this dash-board, Also checkout -
Please provide your feedback or Ask a Question