i had a request, to default OBIEE new analysis to Title and Pivot.
By default when you create a new analysis the default compound layout can be: Title + Table or Title + Pivot. The Pivot will be default when the analysis contains Hierarchical column.
The solution outline is described in OBIEE System Administrators Guide, Chapter 19.72.3 - Setting Defaults for Analyses in the Compound Layout. (the example there is changing default to narrative + chart).
In MWHOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips_Your_Number\msgdb I created folder custommessages .
There I created a file custommessages.xml with the following content:
<?xml version="1.0" encoding="utf-8"?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web.messageSystem">
<WebMessageTable system="Answers" table="ViewDefaults">
<WebMessage name="kuiCriteriaDefaultViewElements" translate="no"><HTML>
<view signature="compoundView" >
<cv signature="titleView" />
<cv signature="pivotTableView" />
</view>
</HTML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web.messageSystem">
<WebMessageTable system="Answers" table="ViewDefaults">
<WebMessage name="kuiCriteriaDefaultViewElements" translate="no"><HTML>
<view signature="compoundView" >
<cv signature="titleView" />
<cv signature="pivotTableView" />
</view>
</HTML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
(the critical part is <cv signature="titleView" /> <cv signature="pivotTableView" />)
It replaces the default definitions in MWHOME\Oracle_BI1\bifoundation\web\msgdb\messages\answerstemplates.xml
Saved it. Restarted presentation services.
When creating new analysis the default is always Pivot:
No comments:
Post a Comment