This is a first-pass solution for a question that invariably gets asked by all customers to add the capability to for a user to store comments against reports for OBIEE 11g.It creates a “discussion thread” on a dashboard page to allow users to add comments to a page.
The solution is basic and requires a couple of requests to be added to each dashboard page that will have commentary enabled. The report need to duplicate and modify for each page as the page name needs to be added as a parameter. A session variable might be an option to implement this solution generically.
Create a write back table to store comments in Oracle DB schema, I have used the ‘BISAMPLE’ schema.
-- Single Null row required for the insert writeback
insert into DASHBOARDCOMMENTS(USER_NAME, DASHBOARD_NAME, COMMENTS)values (null,null,null); -- Single Null row required for the insert Writeback
The repository changes in steps for the configuration to write back to dashboardcomments table are detailed as follows. These steps remain same as far as the configuration steps are concerned for any table to make it be used for “Writeback” option.
Open the “BI Administration” tool and then go to File >> Import Metadata
Provide connection information/ import ‘DASHBOARDCOMMENTS’, then disable the cache for the table
Make the table columns “writeable” of the table ‘DASHBOARDCOMMENTS’ in Business Model layer
Assign the Groups to the “writeable” columns in Presentation layer
Configuration File Changes
Create a folder called “CustomMessages” in the path shown in the below picture, if the folder is not available, then put an XML message file with write back tags as below.