ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 337,456 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘OBIEE 11g Analysis’ Category

Right Click Interactions in OBIEE 11g Views

Posted by Santosh Kumar Gidadmani on December 25, 2014

You can specify which interactions are available when users right click in a pivot table, table, treemap, or trellis view at runtime. Not all right-click interactions are available for each view type. Developer can specify which right click interactions are available for an analysis. Following are the interactions available when user right click on the data at the run time in the dashboard reports.

Analysis editor->Edit Analysis properties->Interactions

rightclick_1

Run time right click interactions on dashboard reports as shown below.

rightclick_2

Customize the interactions based on the business requirements. If they need only one or few like below

rightclick_3

The report will only show the Sort option when the user right click on the value as below.

rightclick_4

There are additional interactions available for presentation hierarchy columns like expand, collapse etc.

Thanks,

Santosh

Advertisements

Posted in End User Analysis, OBIEE 11g, OBIEE 11g Analysis, OBIEE 11g Dashboards | 1 Comment »

OBIEE 11g Sorting

Posted by Santosh Kumar Gidadmani on December 7, 2014

OBIEE 11g Common Sort Functionality

  • Pivot tables always sort each edge from outer to inner layer by default or Pivot table View Sort are always Left to Right by default.
  • Table View Sort are at any column levels.
  • The options that you specify on the Criteria tab serve as the initial sorting state of the analysis. You can modify the sort later when the analysis is used.
  • When you sort items in a hierarchical column, you always sort within the parent. That is, children are never sorted outside of their parent. The children are displayed below the parent in the proper sort order; the parent is not sorted within its children.
  • If you have deselected Sort Columns in the “Analysis Properties dialog: Interactions tab,” you cannot sort a column in a view at run time.

sortimage1

Sort Examples:

1. Table View Sort

sortimage2

Click on any column the report will sort as per that column.

sortimage3

Clicked on Cust City column ascending, the Full Name column data has changed as per Cust City Column.

2. Pivot Table View Sort

sortimage4

If you try to sort on Cust City by descending order as below

sortimage5

The data values on the column Prod Category will not change because it is in the outermost layer.

Clearing Sorts

For sorts that have been applied in the Selected Columns pane, click Clear All Sorts in All Columns.

sortimage6

For sorts that have been applied directly in a pivot table, table, or trellis, right click on any of the column header -> Sort Column -> Clear All Sorts in View.

sortimage7

Thanks,

Santosh

Posted in End User Analysis, OBIEE 11g, OBIEE 11g Analysis, OBIEE 11g Dashboards | Leave a Comment »

OBIEE 11g – Auto Complete Functionality in Prompts

Posted by Santosh Kumar Gidadmani on November 23, 2014

Oracle BI EE provides auto-complete functionality for prompts, which, when enabled, suggests and highlights matching prompt values as the user types in the prompt selection field. Auto complete is only available for the Choice List as user input and when checked the “Enable User to Type Value” option.

image1

Configuring Auto Complete at system level.

Open the instanceconfig.xml file for editing

Location: D:\OBIEE11g_HOME\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Take backup copy

Right click and click on Edit

Insert the below code between the    <ServerInstance>…….. </ServerInstance>

<Prompts>

<MaxDropDownValues>256</MaxDropDownValues>

<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>

<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>

<AutoCompletePromptDropDowns>

<SupportAutoComplete>true</SupportAutoComplete>

<CaseInsensitive>true</CaseInsensitive>

<MatchingLevel>MatchAll</MatchingLevel>

<ResultsLimit>50</ResultsLimit>

</AutoCompletePromptDropDowns>

</Prompts>

Save your changes and close the file

Restart Oracle Business Intelligence.

The auto complete functionality is enabled at the system level, but the dashboard designer or BI Reports developer can exclude the auto-complete functionality from dashboards, and user can turn auto-complete off by using the “My Account dialog”.

After implementing the auto complete functionality at system level, you can enable or disable at dashboard properties level

image2

And by user level in my account settings.

image3

The results in Prompts for auto complete are shown below

image4

These are not case sensitive, you can type in any case (this is part of the above code)

image5

image6

 

Thanks,

Santosh

 

Posted in End User Analysis, OBIEE 11g, OBIEE 11g Analysis, OBIEE 11g Dashboards, OBIEE 11g Prompts | 1 Comment »

 
%d bloggers like this: