Showing posts with label WLS. Show all posts
Showing posts with label WLS. Show all posts

Monday, 14 September 2015

Upgrading the Oracle BI Repository and Catalog

To upgrade the Sample Sales repository and presentation catalog, perform the following steps by using the Upgrade Assistant. Please note that the WebLogic Administration Server and the Managed Server in the 11g environment must remain running during the upgrade process.

1. Navigate to the ORACLE_HOME\bin directory of the Oracle Fusion Middleware installation. In this example, the directory path is D:\bi\Oracle_BI1\bin.


2. Double-click ua.bat to open Upgrade Assistant in the graphical user interface mode. Refer screen shot:


3. On the Welcome screen, click Next.

4. On the Specify Operation screen, select Upgrade Oracle BI RPD and Presentation Catalog and click Next.



5. On the Specify Source Details screen, select Upgrade Repository (RPD).



6. Click Browse next to the RPD File field.

7. Browse to the location of the 10g version of the Sample Sales repository and click Open. In this example, the path is D:\SampleSales\samplesales.rpd.



 8. Enter the Administrator User Name and Administrator Password for the 10g samplesales repository. In this    example, the username and password are both Administrator.



9. Enter new password for rpd which doesn't match with the previous 10g rpd password.



10. Select Upgrade Catalog.



11. Browse to the location of the 10g version of the Sample Sales presentation catalog and click Open. In this example  the path is D:\SampleSales\Sample_Sales_V1.3_Webcat\samplesales.


12. The path to the Sample Sales presentation catalog is added to the Catalog Directory field. The path to  the deliveries directory is automatically added to the Catalog Deliveries Directory field.



13.Enter the weblogic admin server details. Port number, user name and password. 


14. Click Next to continue. On the Examining Components screen, wait until you see a succeeded message. During the examination process, Upgrade Assistant checks whether the source directory exists, the source directory is readable, and contains a file for upgrade.



15. Click Next to continue. On the Upgrade Summary screen, review the summary of the upgrade to be performed.


16. Click Next to continue. When the upgrade completes the status changes to succeeded.



17. Click Next to continue. n the Upgrade Success screen, review information related to the upgrade task and  click Close.



             In this way have upgraded rpd and catalog to 11g. Comment if it is helpful and keep visiting  for new posts.

Thanks....!!

Wednesday, 9 July 2014

Agents, KPI, Scorecards, Writeback, OCI and ODBC

     Agents:
ü  Agents deliver targeted analytics to users based on a combination of schedule and trigger event. Delivery can be by a variety of routes, for example to Dashboard Alerts or to email.
ü  Agents enable you to automate your business processes.
ü  You can use them to provide event-driven alerting, scheduled content publishing, and conditional event-driven action execution.
ü  You can choose:
1.      A schedule that the Agent runs on
2.      A data condition that determines what the Agent does
3.      An analysis that can be distributed
4.      Actions that can be automatically executed depending on whether the data condition is met
ü  Agents can dynamically detect information-based problems and opportunities, determine the appropriate individuals to notify, and deliver information to them through a wide range of devices (email, phones, and so on).

KPI and Scorecards:
KPI:
      A KPI is a measurement of a particular business process which is compared against specific goals and objectives of an organization. KPI’s are typically tracked over time as a way to monitor performance and drive business decisions to help improve upon that performance. KPI does typically have both a goal and a status that reflects performance relative to the goal.
      KPI in OBIEE 11g can be used an analysis dashboard to allow a user to view KPI performance and drill into the details to understand why a KPI value may be off target. KPI’s can also be used to automatically trigger alerts to specific users using OBIEE’s agent mechanism when KPI target values reach critical status levels.
      OBIEE KPI’s also can be configured with another new feature – Action Links – which allow the user to initiate a action based on the status of the KPI. The action link can reference another analysis, send an email, kick off a workflow, or any other process to assist in making the KPI the basis for “actionable intelligence”.

Scorecards:
      Scorecards help organizations define overall goals to improve corporate profitability or increase customer satisfaction, for example and break those goals down into a series of objectives that will enable them to meet the goals. Each of these objectives and initiatives is associated with one or more of an organization’s KPIs, so progress toward each objective can be measured.

Fragmentation in OBIEE:
ü  We use fragmentation when we have fact or dimensional data in one or more different tables or data is split in different data sources. Then each logical table source represents one data segment.
ü  You can split the query against a table or another. Very often, the table is fragmented according to the most important dimension in a star schema the time dimension.
For example, clients, in the first table are clients from A to M, in the second from M to Z.
ü  You have three sort of fragmentation:
§  Fact-based / Dimension-based fragmentation
§  Content-based / Value-based fragmentation
§  Level-based fragmentation / aggregate navigation

Write back
:
ü  It provides users of a dashboard page or an analysis with the ability to modify the data that they see in the table view. 
ü  It is the ability in OBIEE to allow the user to enter a value or values directly into a report and have those values written into the database.
ü  Values are written back to an actual physical table in the database.
ü  Only if the user has the “Write back to database privilege”, then the write back fields in the reports will editable.

Difference between OCI and ODBC:
ODBC: Open Database Connectivity, which is known as Universal Data Connector.
Accessing data in a heterogeneous environment of relational and non- relational database management systems. 
Accessing data in a heterogeneous environment of relational and non- relational database management systems. 

OCI: Oracle Call Interface Normally connects to Oracle Source. Hence, both can connect to Oracle Sources.
Oracle Call Interface (OCI) is an application programming interface (API) that lets you creates applications that use function calls to access an Oracle database and control all phases of SQL statement execution. OCI supports the data types, calling conventions, syntax, and semantics of C and C++.


Tuesday, 8 July 2014

RPD Layers

Three Layers of RPD:

RPD (Repository) is divided into 3 layers

1. Physical Layer: This layer is used for
ü  Importing data
ü  Creating Aliases
ü  Building physical joins
ü  Setting up connection pool and its properties
ü  Enabling/ Disabling cache for individual table

2. BMM (Business Model & Mapping) Layer: This layer is used for
ü  Writing the business logic
ü  Creating Logical columns and tables
ü  Creating hierarchy
ü  Creating LBM (level based measures)
ü  Creating shares
ü  Creating Time series functions
ü  Creating Fragmentation on tables
ü  Creating filters on repository

3. Presentation Layer: This layer is used for
ü  Arranging the data for users view (Folder Structure)
ü  Creating Presentation hierarchy
ü  Creating Implicit Fact column
ü  Implementing Column level security

In short three layers of RDP consist of following functions:


PRESENTATION LAYER
User Roles And Preferences
Simplified Views
Logical SQL Interface
BMM LAYER
Dimensions
Hierarchies
Measures
Calculations
Aggregation Rules
Time Series Functions
PHYSICAL LAYER
Map Physical data
Connections
Schema
Aliases, Joins


Wednesday, 25 June 2014

OBIEE 11g Architecture

OBIEE 11g Architecture


Domains in OBIEE:

Web Logic Server Domain:
·         J2EE App Server used across the board for all 11g BI applications
·         Contains :
a.       Managed Server : Set of J2EE Applications used for “functioning” the BIEE system
b.      Admin Server : Set of J2EE Applications used for “administering” of BIEE system

Oracle Process Manager and Notification Server (OPMN) domain
·           Used to start/Stop system components (BI Server, BI Pres Server, BI Scheduler, BI cluster controller)
·           Can be accessed from CMD or from EM page(GUI)

 Admin Server Components:

WLS Admin Console
•            Admin GUI for WLS, Security and J2EE Components

 Fusion Middleware-EM Control (FMW-EM)
•            Admin GUI to Manage the BI Domain
•            JMX Beans
•            Java components that provide programmatic access for managing a BI domain.

Managed Server Components:

•      BI Plug-in: Sends web http requests to BI Presentation Services
•      BI Security: Integrates BI Server and FMW sec platform (using web service calls)
•      BI Action Services: Dedicated web services for Action framework
•      BI Web Service SOA: Provides Web services for objects in the BIEE Presentation          Catalog, to invoke analysis, agents, and conditions.
•      BI Office: Provides the integration between Oracle Business Intelligence and Microsoft Office products

BIEE Domain System Components:

 •     BI Server
 Provides capabilities to query and access data as well as services for accessing and managing the RPD file (BIEE Metadata).

•     BI Presentation Services
             Provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.

            •     BI Scheduler     
                        Provides framework for scheduling and delivering reports to users

            •     BI Java host
            Enables BI Presentation Services to support various components like Java tasks for BI Scheduler, BI Publisher, and Graph generation.

•     BI Cluster Controller
 Used for distributing requests to BI server and ensure load balancing

Important Files in OBIEE:
•            Repository file (e.g. SampleSales.rpd)
•            Config Files (nQconfig.ini, instanceconfig.xml,)
•            Log Files (nqserver.log, nqquery.log, nqscheduler.log, sawlog0.log etc)
•            Presentation catalog