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

    • 345,608 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for March, 2012

OBIEE11g – Save Current Customization

Posted by Santosh Kumar Gidadmani on March 30, 2012

Save Current customizations allow users to save and view dashboard pages in their current state with their most frequently used choices for items such as filters, prompts, column sorts, drills in analyses, and section expansion and collapse. By saving customizations, users need not make these choices manually each time that they access the dashboard page.

There are two levels at which Save Current Customization can be created.
1. Create Save Current Customization for Individual.
2. Create Save Current Customization for Group of Users

Create Save Current Customization for Individual.

Click on Page Options – Save Current Customization.

Check on “Me – Use this option to save the customization for your own personal use and If you would like to make this dashboard page as default with this customization, check on “Make this my default for this page”
Click OK.

Create Save Current Customization for Group of Users

Click on Page Options – Save Current Customization.

Select on the others – Use this option to save the customization for use by others. Set Permissions and include the Group of Users\LDAP Groups. If you would like to make this dashboard page as default with this customization, check on “Make this my default for this page”


Click on + sign to open the window.

Click on Search to get all LDAP groups list and Application roles.
Select appropriate LDAP and application roles and Click OK.
This customization will save for all users’ who are part of the selected LDAP groups.

Save Current Customization will be very helpful if there are different requirements to analyze the same report by different users.

If you are using the customization as Default by selecting the option “Make this my default for this page”. The Customization will be the default for this dashboard page. If you are not using the default option, the saved customization will be available in “Apply Saved Customization”. To delete the Save customization, use the “Edit Saved Customization”.

– Santosh

Advertisements

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

OBIEE11g – Graph Views

Posted by Santosh Kumar Gidadmani on March 10, 2012

Let us understand a couple of charts Views, now called as Graph in OBIEE11g and properties of these graphs.

Create a simple Graph

1. Bar Graph: Create Bar Graph: Select the required columns from the subject area.

Click on the results, this will bring you the tabular (table) form of report. Select on new View and click on Graph > Bar > Vertical.
In Bar Graph, you can find vertical, horizontal, stacked vertical and stacked horizontal.

The above graph is the default Bar graph. You can find some important icons on the header of the graph, edit graph properties, show graph results, and show/hide graph layout pane.

In the Layout pane, you need to place the columns in graph prompts if you want that column to act as prompt, in section, if you want column to act as section which will display all values in different section, in measures, bars etc to create right bar graph.

There is a slider option in section. This is a new feature in OBIEE11g, if you check mark on the “Display as Slider” and set the section properties to 5 as an example, that column will work like slider in the graph.

I have placed the columns in right places. You can see below graph results.

After creating the Bar graph, click on Done and save the analysis.
You can go to the graph properties; the Bar graph properties are same as it was in 10g version with few new features.

All the options are self-explanatory, you just need to check each of these options and understand its results.
Important Properties: Zoom and Scroll: Use this option to zoom details in the graph.

2. Line Graph
Follow the above process to select the required columns in the reports before you create the Line Graph.
Go to new View and select Line Graph. There are 3 line graph style and you can use graph in 2D or 3D.
Zoom option on the graph properties to zoom the graph in particular area and zoom out as well. This is the new feature in OBIEE11g.

Make use of all graph formats available in OBIEE11g which are better compared to OBIEE10g. After creating the Line graph, click on done and save the analysis. I will not go through all the graph views at this moment and will do based on the request.

– Santosh

Posted in OBIEE 11g, OBIEE 11g Analysis | 4 Comments »

 
%d bloggers like this: