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/ OracleBIPresentationServicesCo mponent/coreapplication_ obips1)
<ServerInstance>
<Analysis>
<InteractionProperties>
< InteractionPropertyAddRemoveVa lues>false</ InteractionPropertyAddRemoveVa lues>
< InteractionPropertyCalcItemOpe rations>false</ InteractionPropertyCalcItemOpe rations>
<InteractionPropertyDrill> true</ InteractionPropertyDrill>
< InteractionPropertyGroupOperat ions>false</ InteractionPropertyGroupOperat ions>
< InteractionPropertyInclExclCol umns>true</ InteractionPropertyInclExclCol umns>
< InteractionPropertyMoveColumns >true</ InteractionPropertyMoveColumns >
< InteractionPropertyRunningSum> false</ InteractionPropertyRunningSum>
< InteractionPropertyShowHideSub Total>false</ InteractionPropertyShowHideSub Total>
< InteractionPropertySortColumns >true</ InteractionPropertySortColumns >
< InteractionPropertyHideColumns >false</ InteractionPropertyHideColumns >
</InteractionProperties>
</Analysis>
</ServerInstance>
<Analysis>
<InteractionProperties>
<
<
<InteractionPropertyDrill>
<
<
<
<
<
<
<
</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.
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.