Wednesday, September 11, 2013

Disabling interactions in OBI 11g Table Views

Recently had a issue with client wanting to globally disable certain interactions that user can use within OBI 11g globally not on a per report basis, found that by editing the instanceconfig.xml and add the following you can toggle those interaction globally. Below is the settings you would need to add to instanceconfig.xml make sure you add them between the correct tags. Make backup of instanceconfig.xml first then restart OBIEE services after you have made the necessary changes.

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

No comments:

Post a Comment