We can configure various options that change the way that right-click interactions are handled in views for an analysis at run time. These are controlled by the tags given below , to be configured in instanceconfig.xml file.
<ServerInstance>
<Analysis>
<InteractionProperties>
<InteractionPropertyAddRemoveValues>true</InteractionPropertyAddRemoveValues>
<InteractionPropertyCalcItemOperations>true</InteractionPropertyCalcItemOperations>
<InteractionPropertyDrill>true</InteractionPropertyDrill>
<InteractionPropertyGroupOperations>true</InteractionPropertyGroupOperations>
<InteractionPropertyInclExclColumns>true</InteractionPropertyInclExclColumns>
<InteractionPropertyMoveColumns>true</InteractionPropertyMoveColumns>
<InteractionPropertyRunningSum>true</InteractionPropertyRunningSum>
<InteractionPropertyShowHideSubTotal>true</InteractionPropertyShowHideSubTotal>
<InteractionPropertySortColumns>true</InteractionPropertySortColumns>
</InteractionProperties>
</Analysis>
</ServerInstance>
To Desable Right click option
This is controlled at the analysis level. In the results tab, if you click on ABC icon for analysis properties, it will open up a popup window with three tabs. If you navigate to the Interactions tab, you will see a list of options such as below where you can control the settings that you are have requested.
The settings are as follows:
1) Run-time Options All Interactions
2) Drill(when not a primary interaction)
3) Move Columns
4) Sort Columns
5) Add/Remove Values
6) Create/Edit/Delete Groups
7) Create/Edit/Delete Calculated Items
8) Display/Hide Sub-totals
9) Display/Hide Running Sum
10) Include/Exclude Columns
It can be done by doing below steps. 1) before doing this take a backup of instanconfig.xml file and do the below changes... You can 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. You can edit the properties of an analysis in Presentation Services to modify how the analysis handles right-click interactions in views. Before you begin this procedure, ensure that you are familiar with the information in Section 3.4, "Using a Text Editor to Update Configuration Settings." To manually configure for interactions in views: 2) C:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml Open the instanceconfig.xml file for editing, 3) Locate the sections in which you must add the elements Include the elements and their ancestor elements as appropriate, as shown in the following example: <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> 4) Save your changes and close the file. 5) Restart Oracle Business Intelligence.For More Refer Oracle Note: http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/answersconfigset.htm#BIESG3772 18.3.4 Manually Configuring for Interactions in Views
