At the analysis level you control it in the Analysis properties -> Interactions.
In OBIEE 11.1.1.7 the default of the list is 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)
The bellow are the definitions with the default values.
Those are the default values if you omit the definition from instanceconfig.xml:
<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>
<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>
You might want to change some/all to true (as I did):
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.
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.
No comments:
Post a Comment