04 TESTING RPD

                                          0.4 Hands on 4 testing RPD
                         0.4.1 Checking repository for consistency

It is useful to check entire RPD, mainly it will check below points
           1. All logical columns are mapped directly or indirectly to one or more physical
               columns.
           2. All logical dimension tables have a logical key.
           3. All logical tables have a logical join relationship to another logical table.
           4. There are at least two logical tables in the business model: a logical fact table and a logical                         dimension table. Both can map to the same physical table.
           5. There are no circular logical join relationships.
           6. A presentation catalog exists for the business model
Consistency Check Manager
          1. Displays consistency check messages
                a. Errors: Must be fixed to make the repository consistent
                 b.Warnings: Condition that may or may not be an error
                    We must make sure there are no errors and if possible debug warnings.
                Note: Till 11.1.1.5 version it used to display best practices in 11.1.1.6 it is internally                                    taken care
          Process:
               Do by using any one way

        















Servers in OBIEE 11G:
1. Oracle BI server:
                  1. It is a main server.
                  2. It controls all data security rules.
                  3. RPD will be loaded in this server .
2. Oracle BI presentation server:
                  1. It is used to develop reports, dashboards, key performance indicator (KPI),
                      score cards etc…
3. Oracle BI Java host:
                  1. It is used to display charts (graphs.)
4. Oracle BI scheduler:
                  1. It is used to schedule reports (Agents).
5. Oracle BI cluster controller:
                  1. It is useful to integrate ‘n’ number of servers.
6. Web logic:
                  1. It is web server useful to access reports and dashboards globally.
                      Above 1 to 5 servers are integrate in OPMNCTL (oracle process management network                             control).

               0.4.2 Loading repository
                          In loading repository into oracle BI server we have below six steps.
              1. Close RPD.
              2. Start the web logic server alone or all OBI severs.
              3. Configure RPD in EM (Enterprise manager).
              4. Start or restart oracle BI server.
              5. Confirm RPD loaded or not by checking log file.
              6. Confirm RPD loaded or not by developing report.

Step 1 : Close RPD
           1. It is not mandatory in OBIEE 11g, where as in 10g it is mandatory.
           2. In 10g RPD opened and if we load RPD in Oracle BI Server then we can not
               open RPD in online mode with write permissions (it opens only read only mode)
Process:
            Go to file menu of Administration tool ->click on close.
Step 2: Start the web logic server alone or All OBI severs
            Go to path BI11g/user_projects/domains/bifoundation_domain/startweblogic.cmd

OR





         Start ->all programs ->oracle business intelligence ->start BI services.
                         Provide user name : web logic.
                         Password:RRitec123.(RRitec is optional)
Note: After installation first time if we start then only it will ask user name and password
Step 3 : Configure RPD in EM (Enterprise manager)
           Open internet explorer type: http://localhost:7001/em
                                                      Provide user name: web logic
                                                      Pass word: RRitec123.
            1. Click on login.
            2. Click on business intelligence ->core application ->Deployment>repository
               ->lock and edit configuration ->close ->click on repository file browse->Select
               RRITEC.rpd ->open ->Repository password:RRitec123->Confirm
               password:RRitec123->Click on apply.
          3. Click on activate changes

Step 4: Start or Restart oracle BI server
          Method 1: Using EM
             1. Click on capacity management ->availability
             2. Select BI servers->Click on restart selected ->yes -> after sometime close.
           Method 2: Using Command prompt
            1. Start -> Run -> cmd
            2. Type cd E:/BI11g/instances/instances1/bin àenter.
            3. To see all the commands of opmnctl type opmnctl ->Enter.
            4. To stop the oracle BI server type
              opmnctl stopproc ias-component=coreapplication_obis1
           5. To start the oracle bi server replace stopproc in above command with startproc

Step 5 :Confirm RPD loaded or not by checking log file
           1. Go to below path
        BI11g\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
           2. Open Nq server.log file observe our rpd name in the bottom of the notepad
Step 6 :Confirm RPD loaded or not by developing a report
         1. Open Intrenet Explorer
         2. Type URL http://localhost:7001/analytics press enter
             User id: web logic.
             Password: RRitec123.
        3. Click on new ->analysis -> select subject area supplier sales
        4. From subject area pane double click on year, dollars columns
        5. Click on results.
Note1:
        1. Whenever we click in activate changes in backend RPD Xerox copy will be created in repository                 folder. this process is called as version control of RPD
        2. In Nqsconfig.ini file RPD name will be modified.
        3. we can find Nqsconfig.ini file in below path
           E: /bi11g/instances/instance1/config/oracle BI server component/coreapplication_obis1.

                      0.4.3 Log level
       1. Oracle BI Server provides a facility for logging query activity at the individual user level
       2. Log levels are available from 0 to 7.
       3. In production we use ‘0’ i.e., No log level .This process is useful to improve the performance of                   environment by reducing log creation work of oracle BI server.
       4. In development and testing environments we use log level ‘2’.
       5. The query log file is named Nq query.log and is located in the directory
           Bi11g/instances/instance1/diagnostics/logs/oracle-bi servercomponent/coreapplication                     obis1.
                                               Log level 1 vs log level 2

Log level 1	Log level 2
1. User name, session id & required id for each query.	1. All items for level 1,plus those mentioned below.
2. Sql for the request using business model names.	2. Repository name, business model name, presentation catalog name.
3. Query status (success, failure, termination or timeout.)	3. Sql for the request using physical data source syntax.Queries issued against the cache.
4. Elapsed times for query compilation, execution, query cache & backend database processing.	4. Number of rows returned from physical database
	5. Number of rows returned to client or report