Oracle Data Integrator installation and Configuration 11.1.1.6 version

Oracle Data Integrator installation and Configuration: Connecting Master and Work Repositories

Extract the ODI Zip files, then open Disk1

 Open Command prompt, change the path to setup.exe folder, execute the setup with jreLoc as shown below(Notw: If setup not recognise jre in the located place install JRE then do the same again)

                                                           
                                                                   Installation started

               
                      Skip Repository Configuration in the below step, we can confiure Repositories later

             
                    JDBC URL: SQL Server name, port number and Database details as shown below

                                 JDBC URL: SQL Server name, port number and Database details

Click on Test Connection

                             Open ODI studio from Satrt --> Programs --> Oracle --> ODI Studio
                                                           Create Login Name to login

  First time Click on " + " button to create. 

(Note: To Edit the login, click on pencil button after the "+" button)

                          Select the Drivers as SQL server Datadirect Driver, then enter URL
                Click on Search button at the end of the text box, it will give sample format of URL
                             (General format: SQL Server name, Prot number, and Database)

In the Work Repository, Select Work Repository tab and click on seach button it will shows work repositories to connect to the Master Repository

                                                                                                                  Cheers,

                                                                                                                  mady

Installation and Configuration of Data Relationship Management 11.x

Configuration:

Once installation completes, In the last step we get an option to Launch Console.

Otherwise we can from Start --> Programs --> Oracle EPM System --> Data Relationship Management -->Web Console

Go to Repository --> Select Repository Configuration

 Here i am using SQL Server as RDBMS, So i am selecting SQL Server. If you are using Oracle Select and give Server details as shown below.

In the User Settings, Console automatically mention user name just we need to give password.

In the Reposiory Settings, Console mention Database Name and Data and log paths also.

Note: we can change User Id and Database name in the following step. Whatever name we are giving here, Console will create that User id and Database in the SQL Server. No need to create a Database manully.

Application Administrator Creation, Console give User name as ADMIN, we need to give password.
Note: In the password, we need to mention Caps, numbers..etc (Strong Password then Console will aceept the password)

 Confiramation Wizard, Click next to create Repository.

 Create Repository Done, We can check in the SQL Server.

 Click Finish to complete Repository Configuration.

 Application Cretaion will come, to Create application. Mention Server Details then Save Configuration.

                                                                                                                                                                                                                                                                                                                      Cheers,

                                                                                                                                                  mady

How to open easconsole.jnlp file for EAS Console in Hyperion 11.x

How to open easconsole.jnlp file for EAS Console in Hyperion 11.x

Once Hyperion Installation and Configuration done, first when we try to easconsole, easconsole.jnlp file will be open. 

Go to this path, find java.ws (java web starter)

C:\Oracle\Middleware\EPMSystem11R1\common\JRE\Sun\1.6.0\bin

Click Run and install java on the Machine.

you will get easconsole as shown below.

Another Method:
To open easconsole, we can use workspace also. Open Web Analysis from workspace, it will automatically install java on the machine.

Thanks,
Mady

FDM-Essbase Adapter Issue in Hyperion 11.1.2.x

Hyperion FDM – Essbase Adapter issue:Connection failed

1. We need to install Essbase Client on the FDM server.
2. We need to update the path Environment variable
   C:\Oracle\Middleware\EPMSystem11R1\bin-32;C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin;C:\Oracle\Middleware\EPMSystem11R1\Products\Essbase\EssbaseClient-32\bin;(Ensure this is in single line)
3. Check ARBORPATH and ESSBASEPATH in the Environmental variables.

ARBORPATH: C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0
ESSBASEPATH: C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0

Extract files to here: 

ES11x-G4-K:C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents

upsEX11xG4K:C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin

Now Goto FDM --> Import

Go to this path

          C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents

Register Adapter

File --> Register Adapter

Go to this path

C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin

                                         In the Second Tab: Hyperion Essbase Integration Setup;

                               Enter Essbase application and database name and select Logon Method 

Now In the Dimensions Tab, you can see Target Essbase application Dimensions as shwon below

                                                                                                                  

Thanks,

Mady

BEA-000365 Server sta te changed to FORCE_SHUTTING_DOWN In Oracle Business Intelligence

<BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

If you have change password or At the starting of BI Services, some times In the Command prompt we will get an option to enter password for weblogic credentials to start the OBIEE Services. By mistake we type wrong password it will store in the following path

We need to change username and password in the following file: boot.properties

C:\Oracle\obieehome\user_projects\domains\bifoundation_domain\servers\bi_server1\security

 Username and password may be in encrypted format as shown below, delete this and enter correct username and password then restart the service

Do the same in the following boot.properties file also. C:\Oracle\obieehome\user_projects\domains\bifoundation_domain\servers\AdminServer\security

Now Start BI Services from Start --> Programs --> Oracle Business Intelligence

Oracle Business Intelligence Console will automatically popup, once services up and running

Shared services Recovery in Hyperion 11.1.1.3 version

Shared services Recovery in Hyperion 11.1.1.3 version

Hyperion Foundation OpenLDAP Service is not stated as shown below:

Hyperion Foundation Shared services – web Application is not started as shown below:

Go to this path as shown below:

Execute the following command to get back the shared services up and running

D:\Hyperion\products\Foundation\openLDAP\bdb\bin>db_recover -v -h D:\Hyperion\products\Foundation\openLDAP\var\openldap-data

Now, Start Foundation services, it will starts without any error messages.

Thanks,
mady

How to Connect to the Smart View from Excel Sheet in Hyperion 11.1.2.2 version

How to Connect to the Smart View from Excel Sheet:

Install Smart view using Hyperion workspace. In the workspace, Tools à Install à SmartView

Open Excel Worksheet:

Xxxxxxxxx: Server name

In the next popup window, it will ask for username and password to connect to the server.

Double click on the forms

Thanks,
mady