Sunday 19 May 2013

New Features with OBIEE 11.1.1.7

The list covers new features for BI Presentation Layer, BI Mobile, BI Server, Server Administrators and BI Publisher. If you notice any other additional 11.1.1.7 features then please post a comment at the bottom ... :)

Presentation Services Features :


1) Recommended Visualizations Feature for Creating Views:
  • When you create a view, you can choose a recommended view type based on the data in your analysis and, optionally, what you want to use it for (for example, to analyze trends).
  • You can choose a suggested "Best Visualization" as well as a "Recommended Subtype". Or you can instead choose the "Recommended Visualization" option, for which you specify your intent for the new view.
2) Breadcrumbs :
  • Breadcrumbs have been added to help users understand their current location within Oracle BI content and the path that they have used to navigate 
  • Oracle BI Breadcrumbs display at the bottom of the page, and users can click a breadcrumb or the breadcrumb overflow button to navigate to a specific location on their breadcrumb trail.
3) Enhancement to Dashboards:
  • The ability to create custom print layouts for high-fidelity printing of dashboard pages (i.e. automatic creation BI Publisher reports)
  • A new default style called FusionFX (instead of "blaf")
  • The addition of the Freeze Column option to the Column Properties menu. This option allows you to freeze a column at an edge (top or left) of a dashboard layout.
  • The addition of "Size" and "Page Size" options that allow you to control the position and size of columns and sections.
  • The ability to export an entire dashboard or a single dashboard page to Microsoft Excel 2007+
  • A new "Replace Analysis in <Dashboard>" option added to Answers to replace an analysis on a dashboard.
  • A new "Return to <Dashboard>" option within Answers to return to a dashboard from the Analysis editor.
4) Enhancements to Graphs

 In 7.0 comeing with Three New graph Views
 a) Waterfall graph,
 b) Stacked graph,
 c) 100% Stacked graph (the latter two are subtypes of Bar and Area graphs)
New Options :
Zoom to data range :- This option lets the system evaluate the range of values on an axis, and choose appropriate minimum and maximum values for the scale. This is useful when graphing a set of large values that are all within a small percentage of each other
Hide sliders in graph views that listen to master-detail events: For graphs in master-detail relationships, if you want to simplify the appearance of an analysis or dashboard, you can hide the slider that is created to accommodate detail columns.

5) Enhancements to Views :
  • A new view type named performance tile. This view type displays a single aggregate measure value in a manner that is both visually simple and prominent.
  • Action links in trellis views. In simple trellis views, action links can now be used on inner graphs per unit, including the context of the outer edges. Action links can also be used in legends and in axis labels. In advanced trellis views, action links can be used in micro charts, where the micro chart functions as a single unit (such as an aggregate number), including the context of the outer edges.
  • For map views, you can now vary the width of a line by measure to accentuate a feature
  • You can link a map view as a detail in a master-detail relationship
  • Auto Correct option for Map views (as errors in Map views can occur for various reasons). If the issue appears to be related to missing layers, maps, or styles, then it might be possible to correct the map by replacing the missing map view components with similar items that exist in the spatial metadata 
  • Legend and formatting highlighting
  • Null suppression at view and analysis levels. You can set null suppression options at the view level (which overrides the analysis level) for data views including: table, pivot table, trellis (both simple and advanced), graph, gauge, and funnel views when the entire row or column contains nulls.
  • Ability to include or exclude calculated items and groups at the view level for columns and column headers. Specifically, two new options have been added: Include Custom Member and Exclude Custom Member
For tables, pivot tables, and advanced trellises:
  • The ability to ◦specify the method to be used to browse data — either scrolling or paging controls
  • Re size rows and columns
  • Row count. If your table or pivot table view contains a grand total or subtotal on the row edge, the display totals, that is the grand total and subtotals, are now included in the Rows per Page count for content paging. In prior releases, if you had the Rows per Page count set to 10 for example, the table or pivot table would display more than 10 records if display totals were shown in the view results
  • For right-click interactions, the ability to specify whether the Hide Columns interaction is available at run time.
6) Enhancements to Prompts:

  • This release includes an enhancement to the SQL Results prompt option. If you are working with double columns, you can now write the SQL statement so that filtering is done on code values rather than display values
  • An enhancement to the prompt constraint option. The prompts designer can now limit a column prompt value list by more than one column
  • This release includes enhancements to the parameters for prompted links.

7) New Menu Options for Exporting Views and Results:

This release adds the Excel 2007+ and Powerpoint 2007+ options for exporting views and results

8) Total Member Placement for Hierarchical Columns:

This release includes an enhancement that allows placement of total members on a hierarchy.

9) Browse Catalog Search Results by Object Attributes:

The capability to use full-text search to find catalog objects and then filter the search results by attributes. This search is available when the administrator integrates Oracle BI Enterprise Edition with Oracle Endeca Server. After the full-text search results are returned, the Catalog area displays a list of matching items, and the Search pane displays the search results grouped by attribute (that is, Type, Name, Path, and Created By)

10) Navigate from the Total or Grand Total in a Table or Pivot Table:

If an analysis contains a total or grand total and the associated attribute or hierarchical column contains an action link or a conditional action link, the action link (or conditional action link) is applied to both the column and the total or grand total.

11) New BI Desktop Tools Available for Download:
  • Oracle Hyperion Smart View for Office
  • Oracle Hyperion Financial Reporting Studio (if Essbase is installed)
  • Oracle Essbase Studio Console (if Essbase is installed)
  • Oracle Essbase Administrative Services Console (if Essbase is installed)
12) Enhancement to Favorites:

This release provides the capability to organize your favorites from the Category Tree area and the Selected Category area in the Manage Favorites dialog. In previous releases, you could organize favorites from the Category Tree area.

13) Integration of Oracle BI EE with Oracle Enterprise Performance Management System

With this release, OBIEE is integrated with Enterprise Performance Management Work space (as part of the installation process)

New BI Mobile Features

Till  To Next Time .. !!!

Friday 10 May 2013

OBIEE 11g - Change the Rpd Password

Hi All,

One utility is Available in 11.1.1.7.0 to change the Rpd password by command line. 

Follow these steps to change the repository password using the obieerpdpwdchg utility, and then deploy the modified repository in Fusion Middleware Control:

1.Run bi-init to launch a command prompt.

Find the Location of the bi-init

A) Client installations : ORACLE_HOME/bifoundation/server/bin
B) Other all installations : ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup

 Double-click bi-init.cmd (or bi-init.bat for client installations) to display a command prompt that is initialized to your Oracle instance.

2. At the command prompt, type obieerpdpwdchg with the following arguments:
  • -I name_and_path_of_existing_repository
  • -O name_and_path_of_new_repository          
Then, enter the current (old) password and the new password when prompted. The repository password must be longer than five characters and cannot be empty. For example:



obieerpdpwdchg -I E:\SampleAppLite.rpd -O E:\New_SampleAppLite.rpd
Give password for repository: Admin123
Give password for repository: <new Password>


       Note that passwords are masked on the command line unless you include the -C option in the command to disable masking.

3. Open a Web browser and log in to Fusion Middleware Control from the computer where the updated repository is located.
4 .In the navigation tree, expand Business Intelligence and then click coreapplication to display the Business Intelligence Overview page.
5. Display the Repository tab of the Deployment page.
6. Click Lock and Edit Configuration.
7. Click Browse next to Repository File. Then, select the updated repository file and click Open.
8. Enter the new (updated) repository password in the Repository Password and the Confirm Password fields.

Make sure to specify the password that has been set in the repository. If the passwords do not match, the Oracle BI Server fails to start, and an error is logged in nqserver.log.

9. Click Apply, then click Activate Changes.
10. Return to the Business Intelligence Overview page and click Restart.