By Saresh-Oracle on Feb 17, 2014
Exalytics Release 1 Patchset 4 is available now.
Exalytics Release 1 Patchset 4 is available now.
Que ) On migrating from one system to other the user can be migrated and allocated to catalog groups but the report jobs won't show up. How can we migrate the report jobs?
Ans) There is no method available to move or migrate the existing reports
jobs to another BI Publisher instance.The BI Publisher document doesn't
provide any such option.We have a catalog utility that can be
used to move the catalog objects like reports, data models etc but not
jobs or job history.
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(18.104.22.168) installed in the same MW home as OBIEE.
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.
Procedures for backing up and recovering VMs in case of a disaster
The Exalytics admin guide is available
For more details your can refer the whitepaper:
OBIEE 22.214.171.124.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics
You may refer Note 1595219.1 -OBIEE 11g 126.96.36.199.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics for more details.
Que) How to remove Analyze option from the report in OBI 188.8.131.52.0 ?
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:
Edit the dashboard.
Click the Tools toolbar button and select Dashboard Properties.
The "Dashboard Properties dialog" is displayed.
Make the property changes that you want and click OK.
Click the Save toolbar button.
Q:How to Automate the Script Generated by Summary Advisor ?
A:'Crontab' is the right approach for such a task.
Que). Can we apply the latest OS/security patches to the exalytics server?
Ans) Yes we can apply the latest OS/Security patches provided that there is no change in the Kernel Version.As per the product management team the Kernel version must not be changed.
Q: Is it certified and supported to install Exalytics Management pack on Exalytics server with OVS ?
A: BI Management pack can certainly be used to manage Exalytics and BI targets.However,It is not supported to install an EM agent on dom0, the monitoring agents have to be installed on the guests.
Please refer http://docs.oracle.com/cd/E24628_01/install.121/e24215/exalytics_mgmt.htm#BABGDIIE
Q:Where can you find more information about Exalytics Disaster Recovery?
Exalytics Disaster Recovery:
Note 1568360.1 -Oracle Exalytics Deployment Guide (Download the whitepaper attached to the Note)
Note 1316073.1 - OBIEE 11g: Recommended Strategies For Disaster Recovery or Backup
Oracle Hyperion EPM
http://docs.oracle.com/cd/E17236_01/epm.1112/epm_high_avail_11121.pdf (Though this is for Hyperion EPM 184.108.40.206, it is applicable to 220.127.116.11 as well)
EPM Disaster Recovery :
Oracle® Enterprise Performance Management System Backup and Recovery Guide :http://docs.oracle.com/cd/E17236_01/epm.1112/epm_backup_recovery_1112200.pdf
Please refer Note 1592007.1 -Oracle Maximum Availability Architecture: Oracle Exalytics Deployment (With Exadata) For High Availability for Exalytics HA configuration.
OBI Caching only speeds up what has been seen before. An In-memory data structure generated by the summary advisor is optimized to provide maximum value by accounting for the expected broad usage and drilldowns. It is possible to adapt the in-memory data to seasonality by running the summary advisor on specific workloads. Moreover, the in-memory data is created in an analytic database providing maximum performance for the large amount of memory available.
Q: Exalytics:Is RTD going to be on the Exalytics box in the future ?
A:RTD is not currently planned to be certified for Exalytics. The Exalytics architecture is not ideal for RTD (RTD requires more processors than memory), and there are no existing or planned optimizations to run RTD on Exalytics.
This Blog is for sharing the latest information regarding Exalytics and OBIEE