OBIA Full Guide

Do you interest in Oracle Business Intelligence Application ?
The Complete Prebuilt BI suite include Prebuilt Datawarehouse, Prebuilt ETL, Prebuilt Data Model (RPD), Prebuilt Report and Dashboard.
You will interest this pack of Document
http://www.oracle.com/technetwork/middleware/bi-foundation/documentation/index.html
There are many things interesting.

OBIEE Bug Guage report with IE

OBIEE Bug when create Guage Dial report on IE.
When you set the Guage Needle Color, you can't click OK to exit properties page.
But you can use Firefox instead of IE.



Dial Guage with IE



obiee content cannot be displayed in the iframe

The problem "obiee content cannot be displayed in the iframe" when you insert OBIEE object in SharePoint Web Portal.

obiee content cannot be displayed in the iframe

• Open instanceconfig.xml file in

OBI_HOME\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\

• Update the instanceconfig.xml file to add the "security" tag 

Security Tag

• Edit the "web.xml" file in

OBI_HOME\oracleBI1\bifoundation\web\app\WEB-INF\

Path

• Insert this syntax

Insert syntax

• Then you need to restart the Services

Oracle ODI Bug

Oracle ODI Bug 14226490: ODI-23040 DURING PROJECT IMPORT

I face the problem when import ODI project (from Develop) to Production environment
And the error show error ODI-23040
Then I logged this case on Metalink, and they replied me : ODI Bug 14226490: ODI-23040 DURING PROJECT IMPORT
-*-

ODI-23040

Oracle Exalytics In-Memory Machine

Oracle Exalytics In-Memory Machine #Official Oracle web site
More detail please visit Oracle web site Oracle Exalytics

Summary Overview

• Best-in-class enterprise BI platform, in-memory analytics software, and hardware optimized to work together
• Advanced data visualization and exploration to quickly provide actionable insight from large amounts of data
• Fastest solution for business intelligence, modeling, forecasting, and planning applications
• Access to all Oracle and non-Oracle enterprise data sources
• No limits on your users, your data, or your applications

Picture from  http://www.theregister.co.uk/2011/10/03/oracle_launches_exalytics_bi_appliance/ 

Features	Benefits
Engineered System—hardware and software  designed to work together	Reduces operational cost risk with fully tested and  stack-optimized hardware and software  from firmware to application
Oracle Business Intelligence Foundation with  hardware-specific optimizations	Provides fastest performance for relational and  MOLAP business intelligence applications,  EPM applications, and large-scale mobile deployments
Analytic In-Memory Database with Adaptive In-Memory  Caching and Columnar Compression	Stores data in main memory; response  time is dramatically faster with no network  latency or disk I/O
Optimized InfiniBand connectivity to  Oracle Exadata	Delivers lightning-fast performance to the  world's fastest database machine
Advanced data visualization	Instantly identifies outliers and patterns in large,  complex data sets through speed-of-thought visual exploration
Plug-and-play architecture	Requires no migration or architecture change

Planning Certificate Sample Exam

Planning Certificate Sample Exam
For this question, Why we cannot see BR?

A is correct
B is wrong , because BR not fix with Cube
C is wrong , what's location ?
D is correct
E is correct
F is wrong

Planning Certificate Guide

Cognos Reporting Studio error HAL ERROR

Knowledge from IBM Web Site
Problem will show the error like these

Error on Chrome

Error on Firefox

How to Solve Problem

Resolving the problem (Credit from IBM Web Site)

Check the ActiveX controls settings in your browser. If ActiveX controls are enabled, you may need to re register the associated dll files.

Steps:

1. In your browser go to Tools - Internet Options
2. In the Security tab click on Custom Level
3. Under Settings navigate to the ActiveX controls and plug-ins
4. Check the setting 'Script ActiveX controls marked safe for scripting' and make sure that is enable.
5. If it is disable, change the settings to Enable. Click OK to save changes.
6. Click OK to close the Internet Options window
7. Restart your browser and test.

If the settings for ActiveX are set to Enable, re register the associated dll file:

1. Locate the msxml3.dll. By default is located in \system32\msxml3.dll
2. From the machine go to Start -Run.
3. Type cmd and press Enter.
4. Navigate to the msxml3.dll location.
5. Type the following command: regsvr32 msxml3.dll and press enter.
6. You will get a windows message that the dll has been registered.
7. Test Report Studio.

For further information on Web Browser Configuration, please refer to the Cognos 8 Administration and Security Guide. See Related URL

For more information http://www-01.ibm.com/support/docview.wss?uid=swg21343169

Note, If you still can't use report studio , you need to add Cognos Server IP to "Do not use proxy" and trust site.

Building the Physical Layer of a Repository

Building the Physical Layer of a Repository
Physical Layer - Are objects in the Physical layer, such as connection pools, folders, tables, columns, and keys

• Contains objects representing the physical data sources to which Oracle BI Server submits queries
• May contain multiple data sources
• Is typically the first layer built in a repository

Physical Layer on right side

Physical Layer Component

Key Column

Defines relationships between tables

• Primary key
• Uniquely identifies a single row of data
• Consists of a column or set of columns
• Is identified by a key icon
• Foreign key
• Refers to the primary key columns in another table
• Is composed of a column or set of columns

Key Column

Hyperion Planning Certificate Test Guide

Hyperion Planning Certificate Test Guide.
This Green answer ,came from "The guide TestKxxx book", but I think something wrong .
Our team tried to exam 2-3 times but all the time failed.
For this question , I think should be 'B' , if you need to Cross tab report you need to create separate dimension ?

Planning Certificate Guide