Thursday, December 23, 2010

Run two .rpd files

The steps as follow as

1) edit web.xml located in $ORACLEBI/web/app/WEB-INF and change the port
9710
to a new port let's say 9711


2) in $ORACLEBI/web , using DOS command line compile analytics.war (make a backup)
jar -cf analytics.war -C app .
If successful

3) Go to the OBIEE o4cj console and deploy the new analytics.war and set a different Context Root like "analytics_new" or "analytics1"

that's pretty much it, the new presentation service will be in

http:/localhost:9704/analytics_new
or
http:/localhost:9704/analytics1

Wednesday, December 22, 2010

Reset -oc4jadmin - Password


To manage an instance of Oracle Application Server, you must log in to the Application Server Control Console using the current Administrator (oc4jadmin) password.

Problem

If you forget or do not know the oc4jadmin password, then you cannot monitor or administer the application server or its components with the Application Server Control Console.

Solution

Reset the oc4jadmin password using the following procedure while you are logged in as the user who installed the Oracle Application Server instance:

Stop OC4J and the Application Server Control.

Enter the following command in the Oracle home of the application server instance:

  • (UNIX) ORACLE_HOME/opmn/bin/opmnctl stopproc ias-component=OC4J
  • (Windows) ORACLE_HOME\opmn\bin\opmnctl stopproc ias-component=OC4J

Locate and open the following file in a text editor:

  • (UNIX)ORACLE_HOME/j2ee/home/config/system-jazn-data.xml
  • (Windows)ORACLE_HOME\j2ee\home\config\system-jazn-data.xml

Locate the line that defines the credentials property for the oc4jadmin user.

The following example shows the section of system-jazn-data.xml with the encrypted credentials entry in boldface type:

jazn.com

.

.

.

oc4jadmin

OC4J Administrator

OC4J Administrator

{903}4L50lHJWIFGwLgHXTub7eYK9e0AnWLUH

Replace the existing encrypted password with the new password.

Be sure to prefix the password with an exclamation point (!). For example:

!mynewpassword123

The password for the oc4jadmin user should conform to following guidelines:

Must contain at least five characters, but not more than 30 characters.

  • Must begin with an alphabetic character. It cannot begin with a number, the underscore (_), the dollar sign ($), or the number sign (#).
  • At least one of the characters must be a number.
  • Can contain only the following characters; numbers, letters, and the following special characters: US dollar sign ($), number sign (#), or underscore (_).
  • Cannot contain any Oracle reserved words, such as VARCHAR.

Delete cached password data by deleting the contents of the following directory:

ORACLE_HOME/j2ee/oc4jinstance/persistence/ascontrol/ascontrol/securestore/

Start OC4J and the Application Server Control.

After the restart, the Application Server Control will use your new Administrator (oc4jadmin) password, which will be stored in encrypted format within the system-jazn-data.xml file.

Saturday, April 25, 2009

Project Proposal

  1. Select a Company
    1. Name
    2. Scope

  2. Gather the requirement to complete each stage. Prepare Requirement Design
    1. Physical Sources
    2. Facts and Dimensions
    3. Hierarchies
    4. Subject Areas
    5. Answers
    6. Dashboards 
  1. Functional Design
    1. Type of Business
    2. Need for OBIEE
    3. No. of Departments
    4. Existing system / Data Sources
    5. How the data moving from OLTP to OLAP
    6. What reports
    7. What Dashboards 
  1. Technical Design
    1. Data sources / Database
    2. Facts and Dimension tables

                                                              i.      At least two fact tables

                                                            ii.      At least three dimension tables

    1. Columns in each table, keys, etc.
    2. Dimension modeling / Hierarchy
    3. Field naming convention
    4. Subject Areas
    5. Reports

                                                              i.      Each report specifications

                                                            ii.      Columns

                                                          iii.      Filters

    1. Dashboards
    2. Pages
    3. Reports of each page 
  1. Develop RPD (Final RPD need to be submitted)
  2. Develop Answers/Reports
  3. Develop Dashboard and Pages
  4. Presentation

Wednesday, February 25, 2009

Repository Creation.

Repository Creation. (.RPD Creation)

STOP the SERVERS

BI Admin
BI Presentations

START – PROGRAM FILES - OBIEE –
START Administration – Create New File (RPD)

Import data’s from Database - DSN or OCI (Oracle Connection Integrator)

Physical Layer - Joins
BMM - Business Model & Mapping – Drill/Down
Presentation Layer.

NSQ Configuration

C:\OracleBI\server\Config

Set default which we created only just (.rpd)

Rename the Catalog file

C:\OracleBIData\web

Start Service – BI Admin – BI Presentation - System will generate Catalog file

START – Program files – OBIEE – Presentation Services