Friday, April 5, 2013

OBIEE 11.1.1.7 - Where are all my Right Click options?


When working in OBIEE 11 you can use Right Clicks of the mouse for various action.
In the report level you control it at the Analysis properties -> Interactions.
In OBIEE 11.1.1.7 the default of the list of rather restrictive. 


I guess you don't want to change it on the report level, each time. So to set a different default, you will find in the System Administrators Guide, chapter "19.3.4 Manually Configuring for Interactions in Views". There you learn you can set different defaults in the instanceconfig.xml file (located at MWHOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1)

<ServerInstance>
   <Analysis>
<InteractionProperties>
<InteractionPropertyAddRemoveValues>false</InteractionPropertyAddRemoveValues>
<InteractionPropertyCalcItemOperations>false</InteractionPropertyCalcItemOperations>
<InteractionPropertyDrill>true</InteractionPropertyDrill>
<InteractionPropertyGroupOperations>false</InteractionPropertyGroupOperations>
<InteractionPropertyInclExclColumns>true</InteractionPropertyInclExclColumns>
<InteractionPropertyMoveColumns>true</InteractionPropertyMoveColumns>
<InteractionPropertyRunningSum>false</InteractionPropertyRunningSum>
<InteractionPropertyShowHideSubTotal>false</InteractionPropertyShowHideSubTotal>
<InteractionPropertySortColumns>true</InteractionPropertySortColumns>
<InteractionPropertyHideColumns>false</InteractionPropertyHideColumns>

 </InteractionProperties>
   </Analysis>
</ServerInstance>

Don't forget to restart the server.

By the way, the InteractionProperties are not new in 11.1.1.7.
In 11.1.1.6, for example, there was a shorter list (the Hide Columns is new in 11.1.1.7), with all defaults as true. This is not the case in 11.1.1.7.