OBIEE 11g Configuration for Interaction for Views

OBIEE 11g offers number options on the way that right-click interactions are handled in views. To configure various options that change the way that right-click interactions are handled in views for an analysis at runtime. The elements in the instanceconfig.xml file specify the default settings for a new or upgraded analysis. One can edit the properties of an analysis in Presentation Services to modify how the analysis handles right-click interactions in views.

Interaction for Views at Analysis Level

The interaction for views can be controlled at Analysis Level.  Click on button Edit Analysis Properties > choose tab Interactions, we can set interaction properties by choosing the options.  

I believe it is not really practical to set properties at each Analysis Level, there is an configuration needs to be done to set these at Analysis Level.

Manual Configuration for Interaction

Open the instanceconfig.xml file for editing,

ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsn

For example:

\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>

I hope you find this information useful.