X

Exalytics In Memory Machine

Recent Posts

Exalytics and OBIEE

Commands To Check Exalytics Version Including Bare Metal, OVM Version and OVM Guest

xBare Metal Releases Release  Release Version  Image Version  OL Version  Kernel Version  How to check version  Expected result  Release1 1.0.0.0 1.0.0.2.0 5.5 2.6.32-100.23.1.el5 imageinfo 1.0.0.2.0 PS1 1.0.0.1 1.0.0.3.0 5.5 2.6.32-100.23.1.el5 imageinfo 1.0.0.3.0 PS2 1.0.0.2 1.0.0.4.0 5.5 2.6.32-100.23.1.el5 imageinfo 1.0.0.4.0 PS3 1.0.0.3 1.0.0.5.0 5.5 2.6.32-100.23.1.el5 /opt/exalytics/bin/exalytics_imageinfo 1.0.0.5.0 PS4 1.0.0.4 1.0.0.6.0 5.8 2.6.32-400.11.1.el5 /opt/exalytics/bin/exalytics_imageinfo 1.0.0.6.0 PS5 1.0.0.5 1.0.0.7.0 5.1 2.6.39-400.128.17.el5 /opt/exalytics/bin/exalytics_imageinfo 1.0.0.7.0 R2 2.0.0.0 2.0.0.0.el5 5.11 2.6.39-400.248.3.el5 /opt/exalytics/bin/exalytics_imageinfo 2.0.0.0.el5   2.0.0.0 2.0.0.0.el6 6.6 2.6.39-400.248.3.el6 /opt/exalytics/bin/exalytics_imageinfo 2.0.0.0.el6 R2.1 2.0.0.1 2.0.0.0.el6 6.7 2.6.39-400.281.1.el6 /opt/exalytics/bin/exalytics_imageinfo 2.0.0.2.el6   OVM Release Release  Release Version  Image Version  OL Version  Kernel Version  How to check version  Expected result  PS2 1.0.0.2 2.0.1.1.0 OVS 3.0.3 kernel-ovs-2.6.32.21-45.6 imageinfo 2.0.1.1.0 cat /etc/redhat-release Oracle VM server release 3.0.3 PS3 1.0.0.3 2.0.1.2.0 OVS 3.2.4   imageinfo 2.0.1.2.0 cat /etc/redhat-release Oracle VM server release 3.2.4 PS4 1.0.0.4 2.0.1.3.0 OVS 3.2.7 kernel-uek-2.6.39-300.32.6.el5uek imageinfo 2.0.1.3.0 cat /etc/redhat-release Oracle VM server release 3.2.7 PS5 1.0.0.5 2.0.1.4.0 OVS 3.2.8 kernel-uek-2.6.39-400.214.3.el5uek imageinfo 2.0.1.4.0 cat /etc/redhat-release Oracle VM server release 3.2.8 R2  2.0.0.0 2.2.0.0.0.ovs-3.2.9 OVS 3.2.9 kernel-uek-2.6.39-400.215.9.el5uek imageinfo 2.2.0.0.0.ovs-3.2.9 cat /etc/redhat-release Oracle VM server release 3.2.9 R2 PS1 2.0.0.1 2.2.0.1.0.ovs-3.3.3 OVS 3.3.3 kernel-uek-3.8.13-68.3.3.el6uek imageinfo 2.2.0.1.0.ovs-3.3.3 cat /etc/redhat-release Oracle VM server release 3.3.3 OVM Guest PS4 1.0.0.4 2.0.1.3.0 5.6 kernel-uek-2.6.32-200.21.2.el5uek uname -rm 2.6.32-200.21.2.el5uek x86_64 PS5 1.0.0.5 2.0.1.4.0 5.8 kernel-uek-2.6.39-400.215.8.el5uek uname -rm 2.6.39-400.215.8.el5uek x86_64 R2  2.0.0.0 2.2.0.0.0.el5 5.11 kernel-uek-2.6.39-400.248.3.el5uek uname -rm 2.6.39-400.248.3.el5uek x86_64   2.0.0.0 2.2.0.0.0.el6 6.6 kernel-uek-2.6.39-400.248.3.el6uek uname -rm 2.6.39-400.248.3.el6uek x86_64 R2 PS1 2.0.0.1 2.2.0.1.0.el5 5.11 kernel-uek-2.6.39-400.248.3.el5uek uname -rm 2.6.39-400.248.3.el5uek x86_64   2.0.0.1 2.2.0.1.0.el6 6.6 kernel-uek-2.6.39-400.248.3.el6uek uname -rm 2.6.39-400.248.3.el6uek x86_64

xBare Metal Releases Release  Release Version  Image Version  OL Version  Kernel Version  How to check version  Expected result  Release1 1.0.0.0 1.0.0.2.0 5.5 2.6.32-100.23.1.el5 imageinfo 1.0.0.2.0 PS1 1.0.0.1 1....

Exalytics and OBIEE

Exalytics DBIM Related Queries

1.Is high availability  supported for Oracle database in-memory (DBIM) feature? If not, what is the workaround, when demanding for HA (active-active) for exalytics ? ==>Not for DBIM for Exalytics. This is a restricted license for which no other DB options are allowed. If one must have HA, they can use DBEE+DBIM (the general option, not the Exalytics license) together with RAC. 2.Price list showing exalytics DBIM option as NUP based only? How many NUPs should factor size it (for license) for OBIEE (let’s say 8 CPU) on exalytics ? ==>DBIM for Exalytics follows the same rules as Exalytics In-Memory Software, OBIS-FE, etc. - minimum 20NUP per customer, irrespective of the number of cores or machines. a) The general use option follows DB rules, so 1 processor license or a minimum of 25NUP per 2 cores. The minimum for an Exalytics machine is  (i) 72 cores per machine for bare metal; (ii) 8 cores per machine for Capacity on Demand; or (iii) a practical minimum of 8 cores per machine for OVM (the theoretical minimum is 2 cores, but this is not enough to be any practical use). For CoD, keep in mind that the customer cannot use disabled cores for anything at all; OVM does come with some challenges of its own, but would likely be the more cost-effective use of the hardware. 3.Is there any other software license required to install DBIM on exalytics ? i.e. any Oracle enterprise license etc? ==>Exalytics In-Memory Software and either OBIS-FE or OBIS-EE (note; OBIS = BI Suite, not BI Server!), with DBIM for Exalytics. If the customer wants HA, they will need DBEE+ the general use DBIM option + RAC.

1.Is high availability  supported for Oracle database in-memory (DBIM) feature? If not, what is the workaround, when demanding for HA (active-active) for exalytics ? ==>Not for DBIM for Exalytics. This...

Exalytics and OBIEE

Exalytics with Oracle DBIM

Q.Is Oracle DBIM available on Exalytics with Processor licensing matrix? ==>DBIM for Exalytics (Engineered Systems price list) is only available in NUP metric and includes restricted use DBEE. The DBIM general use option (Technology Price List) is available in both processor and NUP metric and requires matching lecense metric & qty of DBEE. Q.What is the minimum number of processors that should be licensed  for DBIM? ==>DBIM for Exalytics NUP licensing is not tied to any number of cores; the minimum is 20 NUP per customer (same as Exalytics In-Memory Software, BI Foundation Suite, etc.). The general use option follow DB rules (not BI) so this is 1 license per 2 cores, and a minimum of 25 NUP per Oracle processor. For processor licenses, Exalytics X6-4 can be licensed: in full: all physical cores (72 cores) using Capacity on Demand to disable cores not (initially) needed: a minimum of 8 cores (4 processor licenses) per machine, which can be increased at the customer's discretion in steps of 4 cores (1 per socket). using OVM: theoretically, a minimum of 2 cores (1 license) per machine, however the practical minimum in this case is also 8 cores. Anything smaller is not really enough for productio

Q.Is Oracle DBIM available on Exalytics with Processor licensing matrix? ==>DBIM for Exalytics (Engineered Systems price list) is only available in NUP metric and includes restricted use DBEE. The DBIM...

OBIEE:Difference between High Availability and Scale Out

What is the difference between High Availability and Scale out?Ans: High Availability :High availability refers to the ability of users to access a system without loss of service. Deploying a high availability system minimizes the time when the system is down, or unavailable and maximizes the time when it is running, or available. Scalaing: Scaling is the process of increasing or decreasing the capacity of the system by changing the number of processes available to service requests from Oracle Business Intelligence clients. Scaling out a system provides additional capacity, while scaling in a system reduces capacity. Scaling is also a critical part of configuring a deployment for high availability.Scaling the Oracle Business Intelligence environment applies principally to resource-intensive system processes and Java components. When you deploy more processes, Oracle Business Intelligence can handle more requests while staying responsive to requests.Vertical scaling involves adding more Oracle Business Intelligence components to the same computer, to make increased use of the hardware resources on that computer. For example, Oracle Business Intelligence can be vertically scaled by increasing the number of system components servicing requests on a given computer and results in increased use of the hardware resources on a given computer.Horizontal scaling involves adding more computers to the environment. For example, Oracle Business Intelligence is horizontally scaled by distributing the processing of requests across multiple computers.High Availability: http://docs.oracle.com/cd/E14571_01/core.1111/e10106/intro.htm#i1005660Scaling: http://docs.oracle.com/cd/E25054_01/bi.1111/e10541/cluster.htm#BGBIBGGI

What is the difference between High Availability and Scale out? Ans: High Availability :High availability refers to the ability of users to access a system without loss of service. Deploying a high...

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 ExalyticsYou 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 10Oracle 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.

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...

OBIEE: How to deploy samplesales lite rpd?

We have seen lot of customers asking how to deploy samplesales rpd. Here are the steps to deploy samplesales rpd on your machine: A default OBIEE 11g installation includes the SampleAppLite RPD file and web catalog.To deploy sample rpd, follow the steps below:Step1:Login into EM entering ->http://machinename:7001/em (e.g: http://localhost:7001/em)Step2:Once you logged into EM, Go to Business Intelligence from left side pane and select 'core application'. Select repository from right side pane.Go to 'Deployment' tab -> select 'Repository' tab -> click on 'Lock and Edit' option. Step3:Once you click 'Lock and Edit Configuration' you will get the confirmation message . Click 'Close' with the screen.Step4:So In the next screen you are having the options to select repository and catalog which you want to deploy. After you selected the rpd and catalog click apply and click Activate Changes. (ingore catalog in this case)ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obisn/repositoryStep5:Choose the repository from the location and enter the repository password and change the catalog name which you need to change.Note: Do not forget to click 'Apply' button to save the changes .After the repository is uploaded, it is given a version number suffix (for example, SampleApp_bi001.rpd). After that Click 'Activate Changes'Step6:Once you click 'Activate Changes' , Activation process will be startedAfter this process is over, It will show the confirmation window. Just click 'Close'Step7:Once the changes has been activated, It will ask for the 'Restart to apply recent changes'. Click 'Restart to apply changes'Step8:Once you click 'Restart to apply recent changes' It will come to the below screen. Click 'Restart' to restart all the BI Services. Once the services is successfully restarted, The repository is updated.See if you are able to login to Analytics now

We have seen lot of customers asking how to deploy samplesales rpd. Here are the steps to deploy samplesales rpd on your machine:  A default OBIEE 11g installation includes the SampleAppLite RPD file...

How To Create New Report From Scratch Within Excel Using Smart View?

This article describes the steps to create a new report from scratch within Excel using Smart View: Connect to OBIEE instance using Smart View as mentioned in https://blogs.oracle.com/ExalyticsOBIEE/entry/integrating_obiee_with_microsoft_office Click on Tab OBIEE ->View Designer Pane.The 'View Designer' pane will display a layout similar to the 'Criteria' Pager in Analytics.Here you can selecting from any subject area in the BI Catalog and drag and drop the dimensions and measures you want into respected rows,columns and Measures section. Add filters if required. This report can then be manipulated either as an Excel pivot table or an OBIEE pivot table. Calculated Field can be added through 'Options->Fomulas'. Now create Charts or Graph if required through 'Options->PivotCharts'.You can do any modification that you want using 'Options' tab. Save the Excel document to your personal folder or you can upload to the BI Presentation Catalog using the Publish View button. Open the report in the Analysis Editor, just like any other analysis in the catalog.  NOTE:Only SmartView 32-bit is supported with OBIEE 11.1.1.7.x.SmartView 64-bit is not supported since it requires MS Office 2010, which is not certified with OBIEE 11.1.1.7.x

This article describes the steps to create a new report from scratch within Excel using Smart View:Connect to OBIEE instance using Smart View as mentioned...

Integrating OBIEE with Microsoft Office Using Oracle Hyperion Smart View For Office

This article describes the steps to integrate OBIEE with Microsoft Office using Oracle Hyperion Smart View For Office. Download Smart View using any one of the option below: Option 1:From the Oracle BI EE "Home page"->In the Get Started section, click the Download BI Desktop Tools link, then select 'Smart View for MS Office' Option 2:From EPM Downloads.http://www.oracle.com/technetwork/middleware/epm/downloads/smart-view-1112x-1939038.html Option 3:Download Patch 16909989 -SMART VIEW PATCH TO PICK UP OBIEE 11.1.1.7.1 DLLS. (Patch) from MOS. Install Smart View as per the instructions provided in the readme file. Open Microsoft Office Excel, you will find the 'Smart View' Add-In displayed in the Excel Tab as shown below: Click on Panel->Private Connection->New Connection. Select Oracle BI EE as the new Connection provider. In the URL Field Enter : http://hostname:port/analytics/jbips Enter username and password the the instance specified in step 6. Save the private Connection. The Connection will now be shown under the 'Private Connection'. Note: You may be prompted again to Enter the username and password as in step 7. Now you should be able to browse the BI Catalog and select a Smart View reportReferences:http://docs.oracle.com/cd/E40530_01/epm.11123/smart_view_user.pdf

This article describes the steps to integrate OBIEE with Microsoft Office using Oracle Hyperion Smart View For Office. Download Smart View using any one of the option below: Option 1:From the Oracle BI...

Oracle Exalytics Patchset 3 Software is Now Available

Oracle Exalytics Patchset 3 Software is Now Available The fourth major release of Exalytics software and associated certifications is  now available for use with Exalytics X2-4 and X3-4 engineered systems.  What’s New The new patchset includes a full software version stripe for Exalytics that has been tested together and is delivered as one Engineered System.  Exalytics customers can now access significant enhancements across the whole complement of Exalytics software.   New Software improvements of Oracle Business Intelligence Foundation Suite 11.1.1.7. This release has more than 200 enhancements across the suite and many features targeted exclusively for Exalytics, such as extremely fast ‘hot-data’ recommendations from the database cardinality estimate feature, and BI Publisher high-volume bursting that can enable the generation of an extremely large number of personalized reports and documents for business users in time periods that were previously not achievable. In addition, Essbase, a component of Oracle Business Intelligence Foundation Suite, benefits from Flash memory and expanded main memory available with Exalytics X3-4 or with hardware upgrades for Exalytics X2-4. Multiple cubes can run concurrently with up to 25X improvement in load times and 9X improvement in calculation times when compared to the previous release running on Exalytics X2-4 without Flash storage. New release of TimesTen In-Memory Database 11.2.2.5 enhancements and new functionality for Exalytics, including a new TimesTen import utility for analyzing data in the Oracle Database and importing to TimesTen in Exalytics with recommendations for optimal data types, columnar compression, and indexes, enhanced parallel inserts for compressed tables and data loading time reduction. These capabilities speed up data load times. In-memory join optimizations in TimesTen result in up to 3x improvement over regular workloads in BI Applications, for instance. New Software Certification of EID 3.0. Exalytics now supports the new, major release of Oracle Endeca Information Discovery, which enables rapid insights into structured and unstructured data including social media, websites, content management systems, raw text from documents, email, and more. By correlating this data to the structured data in data warehouses and enterprise applications, users will be able to more accurately manage data and meaning form unstructured sources, ultimately driving better business decisions and innovations. New release of BI Applications 11.1.1.7.1.  This major release features new content across all the BI Applications, two new analytic applications—Student Information Analytics and Indirect Spend Planning—and new use of Oracle Data Integrator and GoldenGate.  New Software Certification of EPM 11.1.2.3 Exalytics now supports the latest version of Oracle Hyperion EPM.  In addition to taking advantage of all of the new user experience, integrations and functional enhancements Exalytics now supports 11.1.2.3 versions of Hyperion Planning, Hyperion Profitability and Cost Management and connections to Hyperion Financial Management. Support for Hyperion Planning 11.1.2.1: Hyperion Planning customers with EPM 11.1.2.1 deployments can now take advantage of Exalytics without needing to upgrade to EPM release 11.1.2.2 or 11.1.2.3. With an existing deployment of Hyperion Planning 11.1.2.1, customers can now leverage the performance and scalability of Essbase deployed on Exalytics.  This certification will open up a much broader set of opportunities for up-selling Exalytics into the Hyperion Planning installed base. NEW Exalytics In-Memory Software.  Software optimizations specific to Exalytics, and not available on generic hardware or other Engineered Systems, are now packaged as part of a new priced item, Exalytics In-Memory Analytics.  This new line item provides rights to use Summary Advisor, Essbase Flash optimizations, BI Publisher enhanced bursting for Exalytics, TimesTen for Exalytics unique features, and other capabilities unique to Exalytics In-Memory Machine. Note: Hyperion Financial Management (HFM), of course, is not supported on Exalytics yet.What’s new is a direct connection from Exalytics via ADM driver to HFM 11.1.2.3 for enabling OBI based analytics.  Hyperion Planning, Hyperion Profitability and Cost Management, and Oracle Financial Management Analytics are all increasingly popular on Exalytics.Documentation Library: http://docs.oracle.com/cd/E41246_01/index.htm

Oracle Exalytics Patchset 3 Software is Now Available The fourth major release of Exalytics software and associated certifications is  now available for use with Exalytics X2-4 and X3-4engineered...

Exalytics: Loading Data From Oracle To TimesTen

There are three primary use cases for Exalytics/OBIEE/TimesTen: 1.    Normal BI use case 2.    DataMart use case 3.   Operational Data Store (ODS) use case In terms of how TimesTen is used (1) is the most common case (maybe 70-80% of customers) and (2) and (3) are very similar to each other. For (1), only aggregates are stored in TimesTen. These aggregates are recommended by the BI software based on the various reports and dashboards that have been configured there, the queries that BI generates as a result of them and the way the data is organised in the backend database. BI generates scripts to compute these aggregates and to load them into TimesTen. This is all completely controlled and managed by the BI software. We should not be getting involved in any recommendations relating to data loading for this aspect (since it is all under the control of BI and is closely coupled with who BI is setup and used). Any 'advice' for customers in this area is the job of BI SCs, BI consulting and maybe BI support.  For (2) and (3) a subset of the backend database DataMart / ODS is typically loaded into TimesTen. This usually consists of one or more very large 'fact' tables plus a larger number of significantly smaller (but still often large in absolute terms) 'dimension' tables. The decision as to which tables need to be moved into TimesTen and what subset of the data is needed is still really driven by BI considerations and has to be carefully evaluated on a case by case basis. We should not get involved in that aspect; that is firmly the province of BI SCs / consultants to assist the customer with. Once the customer already nows the exact set of tables etc. that they want to move into TimesTen then we can potentially provide some advice, though again it should be in conjunction with the BI folk to ensure we are all aligned on the best option(s) for a given use case. For initial data loading (initial population): If the backend DB is non-Oracle then potential options are: 1.    Manual; create compatible TT schemas and create tables in TT, unload data from backend DB in a format that ttBulkCp can read, load data into TimesTen using ttBulkCp. 2.    Use OBIEE. This has some limited data loading capabilities. 3.    Use Oracle Data Integrator (if the backend DB is supported). This requires a license so it is not a free option. 4.    Use Oracle Datawarehouse Administration Console (DAC). This also requires a licence so is not a free option. If the backend database is Oracle 10gR2 or later then there is an additional option: 5.    Use ttImportFromOracle to perform type mapping, data compression etc. and generate TT compatible DDL files to create the tables in Oracle. Use the (new) parallel data load feature of ttImportFromOracle (as from TT 11.2.2.5.0) to load data to TT tables quickly and with high throughput. For Oracle DB backends in general (5) would be the recommendation (since it is free and flexible) but customers may of course choose any of these options. For incremental refresh loads: Typically, once the initial population has been done then from time to time (might be hourly but more often daily or less frequently) there is a need to add new data to the TT datamart / ODS. Usually this is simply adding new data but sometimes it may also require updating existing data. Due to the limited capacity of memory there will also need to be a mechanism to periodically purge 'old' data. This is a more complex area and as of today we do not have any really good solutions (but they are begin worked on). Post 11.2.2.5.0 we hope to have some better options (but that is internal information not for external consumption at present). The two main challenges here are: 1.    All queries that originate from BI use table level locking for performance reasons. Thus they are incompatible leith any concurrent DML against the tables being queried. 2.    What does it mean anyway, in business terms, to run report and queries against data  that is changing (given that TimesTen does not support the same query consistency models as e.g. Oracle DB).  So today options for incremental refresh require either: a)    Some BI application downtime to allow the TT tables to be refreshed. This maybe can be selective if there are different sets of tables that can be refreshed together. b)   Some form of double buffering whereby two copies of all relevant tables are maintained in TT. App runs against copy 1 while copy 2 is refreshed then app switches to copy 2. Later copy 1 can be refreshed and app switched back to copy 1 afterwards. Bi can support this but the memory requirements in TimesTen often make it impractical. The 'tools' that can be used for this are pretty much the same as for initial loading… For non-Oracle backend DBs: 1.    Manual; Unload data from backend DB in a format that ttBulkCp can read, load data into TimesTen using ttBulkCp. If anything other than INSERT is needed then may need top use staging tables and PL/SQL processing in TimesTen etc. 2.    Use Oracle Data Integrator (if the backend DB is supported). This requires a license so it is not a free option. 3.    Use Oracle Datawarehouse Administration Console (DAC). DAC is free and supported for customers with license of any of the BI Applications. If the backend database is Oracle 10gR2 or later then there is an additional option: 4.    Use the ttLoadFromOracle building to load data directly into the TT tables, or into staging tables for further processing using e.g. PL/SQL. The LoadData.sql script generated by ttImportFromOracle could be used as a basis to construct suitable scripts.

There are three primary use cases for Exalytics/OBIEE/TimesTen: 1.    Normal BI use case 2.    DataMart use case 3.   Operational Data Store (ODS) use case Interms of how TimesTen is used (1) is the most...

Exalytics Backup and Recovery

OracleExalytics is an engineeredsystem that comprises a number of hardware and software component. The core software components include: OBIEE Timesten Weblogic Server Essabse Optional components: Endeca Hyperion Planning Golden Gate Oracle Data Integrator DAC This blog provides information to perform backup and recovery on the Exalytics Machine. The backup procedure for OBIEE and Timesten is described in Exalytics Installation and Administration Guide The references for backup procedures for other components can be found below: Weblogic Server Oracle Fusion Middleware Administrator's Guide 11g Release 1 (11.1.1)->15.5.1 Backup and Recovery Recommendations for Oracle WebLogic Server Essbase: Note  589433.1 -Backup Methods for Essbase Databases Note 583342.1 -Restore an Essbase Application From Backup Endeca: Note 1536707.1 -General Backup And Restore Procedures For An Endeca Information Discovery Deployment Hyperion Planning:Note 1195635.1 -How to Backup And Recover a Hyperion Planning Application Golden GateNote 1465044.1 -Oracle GoldenGate ( OGG ) Recovery Techniques Main Note Oracle Data Integrator (ODI)Oracle Fusion Middleware Administrator's Guide 11g Release 1 (11.1.1)->15.5.9 Backup and Recovery Recommendations for Oracle Data Integrator Informatica/DAC: Note 1332271.1 -How to restore Informatica admin console and informatica services as the infrep database crashed and moved to a different database host     Linux:Note 735969.1 -Linux Directories/Filesystems to Backup to Recover from Catastrophic System Failure

OracleExalytics is an engineered system that comprises a number of hardware and software component. The core software components include: OBIEE Timesten Weblogic Server Essabse Optional components: Endeca Hyper...

How To Pass Presentation Variable To the Title View Using Dashboard Prompt?

Presentation variable does not pass correctly in title viewwhen all values are selected in the dashboard prompt. For eg, when all values are selected,the title is displayedas @{xxxxx} When you select a value from the dashboard prompt , thetitle is reflected correctly with the selected value in dashboard prompt. This issue can be reproduced at will using any version ofOBIEE. The test case using OBIEE 11.1.1.7 is demonstrated below:  Steps: Section 1: Create the report:1.1.Create an analysis using sample sales lite rpd withfollowing criteria:Time: Per Name YearProduct: BrandOffices: DepartmentBase Facts: Revenue Add a Filter ->Product: Brand and make it 'Is prompted' (we will be making Brand as the presentation variable)1.2.Click on Result and Edit the Title1.3.In the 'subtitle' field , Enter the name of presentation variable, say @{Brand}1.4.Save the report as 'Presentation var'Section 2: Create the Dashboard prompt.2.1 Create a New Dashboard Prompt (New->Dashboard Prompt)2.2 Add a Column Prompt: Product ->Brand2.3 Expand the Options and Set a variable to 'Presentation variable' and Enter 'Brand' in the field below.2.4Save the dashboard prompt as 'PVprompt'Section 3: Create the Dashboard Page3.1 Create a new board and name it as :PVDashboard3.2 Drag and drop the Dashboard Prompt created from Section 2 into the dashboard page3.3 Drag and drop the report created from Section 1 to the dashboard page3.4 Save the Dashboard page and run it.3.5 When there is no value selected in the dashboard prompt, the subtitle is displayed as '@{Brand}' 3.6 When you select a value for Dashboard prompt : say 'BizTech', it is displayed correctly as BizTech as shown below:To fix this issue, Do the following:Edit the Title view from Results tab and add a default value for All selection for eg, 'All Brand' in this case: @{Brand}{All Brand}and Save the title.Save the Dashboard PVDashboard,and Run it .Now the Presentation Variable is displayed correctly when you dont select any value for the Dashboard prompt.

Presentation variable does not pass correctly in title view when all values are selected in the dashboard prompt. For eg, when all values are selected,the title is displayed as @{xxxxx} When you select...

OBIEE 11g:Excel Connectivity Using ODBC Drivers

This blog describe the method to connect Excel to BI Server using ODBC.  For this you dont need to use the Analytics. You can use Excel to create the report by connecting to BI server using ODBC Datasource. Two steps to achieve this are: Create a system DSN Create the report using Microsoft Query. Step 1: Create  the system DSN 1.Go to Control Panel->Administrative Tools->DataSources (ODBC)->System DSN 2. Select Oracle BI Server and Click Add 3.Click on Finish and enter a name for your DSN and enterthe BIServer name and click finish Now your BI Server DSN Configuration is done. Step 2. Create the report using Microsoft Query. 1. Open the Excel and Click on MicrosoftExcel->Data->From Data Sources->From Microsoft Query 2. Select the DSN name you created above and enterthe credentials to log in to BI Server. 3. A new screen to choose column will appear. 4. Drill down on the dimensions and select the requiredtables as shown below: 5. If you get a message like below, click on OK 6. Clicking OK will take you to the screen shown below: 7. Click on Add Tables icon from the menu. This will allow youto select the tables that you want in your report.  For example, 7.1. In this case we are using Sample Sales lite rpd and we will add the fact table Base Facts (click on Add) 7.2. Base fact will be added to Microsoft query. DragActual Unit Price from ‘query from …’ section to the Result pane header.               (Notethe difference in screenshot from step 6) 8. Close the window for ‘Microsoft Query’. Now ‘Import Data’wizard will open. 9. Select the type of table you wanted. (In this example we have used the pivottable report)         a.Drag Product to Drop Row Field Here        b.Time to Drop columns Field Here        c.Actual unit price to Drop Data Items here.        d.The report will be generated in excel like below:

This blog describe the method to connect Excel to BI Server using ODBC.  For this you dont need to use the Analytics. You can use Excel to create the report by connecting to BI server using...

Exalytics: Steps To Upgrade JDK and JROCKIT

The Oracle Fusion Middleware Installation and Administration Guide for Oracle Exalytics In-Memory Machine, suggests Java Development Kit (JDK) 6 Update 29 for Linux 64-bit.  However, more recent Oracle Support security alerts have suggested that customers upgrade to JDK 1.6.0 update 33, or higher.  This blog describes how JDK and JROCKIT are used in an Exalytics environment and also includes steps to upgrade the JDK on Oracle Exalytics. JDK is used internally in three places on an Oracle Exalytics machine: The first is to support Weblogic, where on Exalytics, you use JRockit. Weblogic is used by many Oracle products and the process / procedures for updating the JDK are detailed in the appropriate documentation, but the specific steps for JRockit can be found at Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server 11g Release 1 (10.3.6). The second is to support the Exalytics installation process which uses ANT. This is a one time use of the JDK, and the Exalytics product documentation specifies which version should be downloaded to support ANT.  The version specified corresponds to the test versions used by Oracle Exalytics Product Management. This JDK is used only during the installation process and is not used afterwards. This JDK can be removed after completion of the Oracle Exalytics installation. The third is to support a specific system component, i.e. Java Host, which is a component of BI used for a number of different operations. It's important to note that the Java Host is never accessed by desktop, browser or web-services. It is only ever accessed by the Presentation Server (OBIPS), using server to server Remote Procedure Calls (RPC). The JDK can be updated manually if required and the steps to do so are broadly described as follows: Stop all OBIEE related services. Download the JDK and copy this into the ORACLE_HOME directory for OBIEE (for example /u01/app/oracle/product/fmw/Oracle_BI1). Rename $ORACLE_HOME/jdk as $ORACLE_HOME/jdk.OLD. Run the JDK installer (which unzips the distribution into a directory jdk<version>. Rename the directory $ORACLE_HOME/jdk<version> as $ORACLE_HOME/jdk to ensure all existing configuration references do not break. Restart the services. For details on which versions of JDK, (or other components), are certified with Oracle Exalytics, please see Note 1505616.2 -Information Center: Certification Information For Oracle Exalytics. NOTE: The same upgrade steps would apply whether you are updating to a JDK 1.6 release or a JDK 1.7 version. Happy Upgrading :) Thanks, Sareesh Oracle Exalytics/OBIEE

The Oracle Fusion Middleware Installation and Administration Guide for Oracle Exalytics In-Memory Machine, suggests Java Development Kit (JDK) 6 Update 29 for Linux 64-bit. However, more recent Oracle...