Tag Archives: Oracle

Can we install and run ODI where weblogic part is in separate domain on Exalytics?

Que ) Can we install and run ODI  where weblogic part is in separate domain on Exalytics?

Ans) ODI is only supported using the BI Applications(11.1.1.7) installed in the same MW home as OBIEE.

Setting Up and Running Summary Advisor on an Exalytics Machine (Oracle-by-Example)

If you are running Oracle BI on an Exalytics machine, you can use Summary Advisor to identify the aggregates that will increase query performance. Summary Advisor intelligently recommends an optimal list of aggregate tables based on query patterns that will achieve maximum query performance gain while meeting specific resource constraints. Summary Advisor then generates an aggregate creation script that can be run to create the recommended aggregate tables. Aggregate tables reduce query times by storing precomputed results for queries that include rolled-up data. This tutorial covers steps to set up, configure, and run Summary Advisor on an Exalytics machine using TimesTen database as a target for storing aggregates.

You can find the Oracle By Example (OBE) in the Oracle Learning Library (OLL). The content in OLL is available to all customers, partners, and employees.

Disaster Recovery – VMs

Procedures for backing up and recovering VMs in case of a disaster

The Exalytics admin guide is available here: http://docs.oracle.com/cd/E41246_01/bi.1/e39709/toc.htm.

For more details your can refer the whitepaper:

http://www.oracle.com/technetwork/server-storage/vm/ovm3-backup-recovery-1997244.pdf

OBIEE 11.1.1.7.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics

OBIEE 11.1.1.7.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics

You may refer Note 1595219.1 -OBIEE 11g 11.1.1.7.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics for more details.

Additional information:

  • You can directly apply OBIEE 11.1.1.7.131017  on the top of OBIEE 11.1.1.7.0 without applying the OBIEE 11.1.1.7.0 patch.
  • Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 introduces support for Microsoft Internet Explorer 10
  • Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 integrates support for Oracle BI Mobile App Designer into Oracle BI Presentation Services. The Home page displays a new Create Mobile App option and a link to the Mobile Apps Library; the New menu now also includes a Mobile App option. Note that to use these new options, you must also install the Oracle BI Mobile App Designer. Oracle BI Mobile App Designer is available in a separate patch (17220944) available from My Oracle Support. Apply the Mobile App Designer patch after installing Oracle BI EE Suite Bundle Patch 11.1.1.7.131017. Note that if you have previously installed Oracle BI Mobile App Designer on the BI system, then you do not have to re-apply Mobile App Designer patch 17220944. However, you will have to make a configuration change to re-enable the new Mobile App options.
  • Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 improves functionality for exporting data from analyses, dashboards, and other Oracle BI Presentation Catalog objects into Microsoft Excel.

How to remove Analyze option from the report in OBI 11.1.1.7.0 ?

Que) How to remove Analyze option from the report in OBI 11.1.1.7.0 ?

Ans)

You can change the properties of a dashboard and its pages. Specifically, you can:

  • Change the style and description of the dashboard

  • Add hidden named prompts to the dashboard and to its pages

  • Specify which links (Analyze, Edit, Refresh, Print, Export, Add to Briefing Book, and Copy) are to be included with analyses at the dashboard level. Note that you can set these links at the dashboard page level and the analysis level, which override the links that you set at the dashboard level. 

  • Rename, hide, reorder, set permissions for, and delete pages.

  • Specify which accounts can save shared customizations and which accounts can assign default customizations for pages, and set account permissions.

  • Specify whether the Add to Briefing Book option is to be included in the Page Options menu for pages.

To change the properties of a dashboard and its pages:

  1. Edit the dashboard. 

  2. Click the Tools toolbar button and select Dashboard Properties.

    The "Dashboard Properties dialog" is displayed.

  3. Make the property changes that you want and click OK.

  4. Click the Save toolbar button.