Thursday Oct 17, 2013

OBI already has a caching mechanism in presentation layer and BI server layer. How is the new in-memory caching better for performance?

Question:

OBI already has a caching mechanism in presentation layer and BI server layer. How is the new in-memory caching better for performance?

Answer:

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.

Wednesday Sep 18, 2013

Exalytics:Is RTD going to be on the Exalytics box in the future ?

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.

Friday Sep 13, 2013

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/repository

Step5:
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 started
After 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


Wednesday Sep 04, 2013

Is Upgrading the Linux Kernel on Exalytics Supported?

Question:

Is Upgrading the Linux Kernel on Exalytics Supported?

Answer:

This is is not supported. Only the kernel on the certification matrix is supported at this time.


Is Hardware Management Pack available for Exalytics now?

Question:

Is HMP available for Exalytics now?

Answer:

Yes. You should be fine installing HMP on Exalytics.

Installing HMP is pretty easy. You can download the shell script from Patch 16384749: Oracle HMP 2.2.5 for Oracle Linux 5 and Red Hat Enterprise Linux 5, 64-bit. Then unzip the zip file run install.bin.

Can you run Informatica on an Exalytics box?

Question: 

Can you run Informatica on an Exalytics box?

 Answer:

It's not supported to install anything other than the Exalytics software on the hardware.

Is customer allowed to change IP address of Exalytics box by himself?

Question:

Is customer allowed to change IP address of Exalytics box by himself?

Answer:

Changing the IP address or host name of an Exalytics machine is not officially supported, or recommended.Weblogic, EM has dependency on the IP address and may not function properly after the IP address is changed. You may have to reinstall the entire apps after you have changed the IP address.

Weblogic, and the OBIEE install do have some dependency on the networking configuration but typically that is the hostname, rather than the IP. So, this means that it should be possible to change the IP address of the host, but NOT the hostname. However, if the network was not setup properly and in Enterprise Manger you see references to IP addresses rather than the hostname then there may be a problem such as that described above

In order to change the IP address, we would recommend that the procedure is carried out by someone familiar with network configuration, they could either use the exalytics network config script or directly edit the various network config files appropriate to the network port that the IP is being changed on.

Tuesday Aug 27, 2013

Is it possible to upgrade directly from Exalytics PS1 to PS3 without PS2

Q: Is it possible to upgrade directly from Exalytics PS1 to PS3 directly without having PS2 in place?

 A: No, To move to PS3, you should be on PS2. 

If you dont have PS2 installed before applying PS3, please apply PS2 patch and then apply PS3 patches.

Friday Aug 16, 2013

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:
  1. Connect to OBIEE instance using Smart View as mentioned in https://blogs.oracle.com/ExalyticsOBIEE/entry/integrating_obiee_with_microsoft_office
  2. 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.

    View Designer
  3. Add filters if required.

    Add Filters
  4. This report can then be manipulated either as an Excel pivot table or an OBIEE pivot table.

    Report
  5. Calculated Field can be added through 'Options->Fomulas'.

    Calculated Field

    Calc Field Report

  6. Now create Charts or Graph if required through 'Options->PivotCharts'.You can do any modification that you want using 'Options' tab.

    Pivot Chart

    Excel Chart

  7. Save the Excel document to your personal folder or you can upload to the BI Presentation Catalog using the Publish View button.

    Save

  8. Open the report in the Analysis Editor, just like any other analysis in the catalog.

    9
 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

Wednesday Aug 14, 2013

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.

  1. 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'
      Download
    • 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.
  2. Install Smart View as per the instructions provided in the readme file.
  3. Open Microsoft Office Excel, you will find the 'Smart View' Add-In displayed in the Excel Tab as shown below:
    Add-In
  4. Click on Panel->Private Connection->New Connection.
  5. Select Oracle BI EE as the new Connection provider.
    OBIEE Connection
  6. In the URL Field Enter : http://hostname:port/analytics/jbips
    URL
  7. Enter username and password the the instance specified in step 6.
    Login
  8. Save the private Connection.
    Save connection
  9. 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.
    Connection displayed in panel
  10. Now you should be able to browse the BI Catalog and select a Smart View report

References:

http://docs.oracle.com/cd/E40530_01/epm.11123/smart_view_user.pdf

Wednesday Jul 17, 2013

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

Thursday May 30, 2013

Is Exachk available for Exalytics?

Is Exachck available for Exalytics?

Answer: No, Exachk is not available for Exalytics.If the customer is using OBIEE Management Pack for Enterprise Manager Cloud Control 12c, then he/she can compare, search and see the history of configuration changes across time and environments.

How to do it if Customer is not using OBIEE Management Pack for Enterprise Manager Cloud Control 12c?

 Answer:Customer will have to install EM cloud control 12c Release 2 and on the top of that they should install OBIEE pack
Download link for EM cloud control 12c
Documentation for Managing OBIEE


Thursday May 16, 2013

Is Essbase Server 11.1.2.3 certified for Exalytics machine?

According to Exalytics certification matrix (oracle-exalytics-1x-1875875.xls), the Exalytics hardware is certified only for Essbase Server 11.1.2.2.101. Is Essbase Server version 11.1.2.3 certified with Exalytics?

 Answer:

If you are deploying the Essbase 11.1.2.3 from EPM deployment mechanism (HIT), then it is already certified. The certification matrix will be updated accordingly soon.

Monday May 13, 2013

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.

Friday May 10, 2013

Exalytics Backup and Recovery

Oracle Exalytics is an engineered system that comprises a number of hardware and software component.

The core software components include:

  1. OBIEE
  2. Timesten
  3. Weblogic Server
  4. Essabse

Optional components:

  1. Endeca
  2. Hyperion Planning
  3. Golden Gate
  4. Oracle Data Integrator
  5. 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 Gate

Note 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

About

This Blog is for sharing the latest information regarding Exalytics and OBIEE

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today