Sunday, 1 January 2017

obiee 12c services not starting

Error: while starting the obiee 12c services, weblogic server failed starting giving some domain reading error. I found the error is because of the pluggable database is not open. Find the below error screen shot
C:\Users\vinodp\Desktop\c1.PNG
test for pluggable database error while execute query in sqlplus
C:\Users\vinodp\Desktop\Capture.PNG
Sol:
  1. Stop all services
  2. Alter the pluggable database for open queries
Ex: Alter pluggable database pdborcl open;
Syntax: Alter pluggable database opne;
  1. Restart the obiee services

Saturday, 31 December 2016

Oracle Discoverer Query to find out Workbook, last run and number of time executed query

Oracle Discoverer Query to find out Workbook, last run and number of time executed query

SELECT A.* , B.TOTCOUNT FROM
(SELECT CASE WHEN  QS_DOC_OWNER IS NULL THEN 'E' ELSE QS_DOC_OWNER END  AS USERNAME , QS_DOC_NAME, QS_DOC_DETAILS, QS_CREATED_DATE LAST_USED, QS_NUM_ROWS
FROM MPEADEVL.EUL5_QPP_STATS
WHERE QS_ID IN(
  SELECT  MAX(QS.QS_ID)
    FROM MPEADEVL.EUL5_QPP_STATS QS, MPEADEVL.EUL5_DOCUMENTS DC
    WHERE QS.QS_DOC_NAME=DC.DOC_NAME
    GROUP BY QS_DOC_OWNER, QS.QS_DOC_NAME, QS.QS_DOC_DETAILS)
ORDER BY LAST_USED DESC) A,
(SELECT CASE WHEN  QS_DOC_OWNER IS NULL THEN 'E' ELSE QS_DOC_OWNER END AS USERNAME, QS_DOC_NAME, QS_DOC_DETAILS, COUNT(*) TOTCOUNT
FROM MPEADEVL.EUL5_QPP_STATS QS, MPEADEVL.EUL5_DOCUMENTS DC
    WHERE QS.QS_DOC_NAME=DC.DOC_NAME
    GROUP BY QS.QS_DOC_OWNER, QS.QS_DOC_NAME, QS.QS_DOC_DETAILS) B
WHERE A.QS_DOC_NAME=B.QS_DOC_NAME AND A.QS_DOC_DETAILS=B.QS_DOC_DETAILS AND A.USERNAME=B.USERNAME;

RPD deployment in OBIEE 12c


  1. Open the command prompt go to the below path
Oracle_Home\user_projects\domains\bi\bitools\bin
  1. Enter the below command
Data-model-cmd.cmd uploadrpd -I .rpd -W -U -P -SI
I : specifies name of the repository (give complete path)
W :  specifies the repository’s password.
U :  specifies a valid user’s name to be used for OBIEE authentication
P : specifies the password corresponding to the user’s name that you specified for U.
SI : specifies the name of the service instance.

Friday, 12 August 2016

OBIEE Action Link

Overview
This tutorial shows you how to build and use actions to provide guided navigation, link to external web content, and invoke web services. You learn how to guide user navigation in dashboards and analyses using actions and action links, to access external web content in the context of your BI analysis, to use conditions and agents with actions to automate initiation of business processes, and to invoke a Web Service using actions and action links.
In this tutorial, you focus on a subset of the available types of actions you can use to drive functionality and navigation within your Oracle BI analyses and dashboards.
Enabling BI Navigation
In this topic you add an inline action link to a column in an analysis which navigates to another analysis in Oracle BI. Because the action link is set as a property of the column itself, the action is available from Table, Pivot Table, Graph, and Map views. After testing the inline action link and saving the analysis, you save the action link as a named action link in the Presentation Catalog.
To automate BI navigation and create a named action link, you perform the following steps:
  • Log in to Oracle BI EE and create an analysis
  • Add an action link to the analysis
  • Test the action link
  • Save the action in the Presentation Catalog

OBIEE Agents

Agents automates the process of delivering reports and dashboards
Configure Email settings:
  1. Login to Fusion Middleware Control Enterprise manager (http://yourservername:7001:/em) using Admin user credentials
  2. Navigate to Mail tab (Business Intelligence > coreapplication > Deployment>Mail

    https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2dB6Fd2lbK98Nh6OMjDB8XJ6U39Zm0bI4ebLCVInMDW2fXtBeLr8lin-Yj0f3MPXocZTZTFJGB08LpxhzKZUxHxPTyfugkJ5OX9bFMbKEArtdeKD1MFNTTCm6gyGnIJEfKO_I-3qroFIY/s1600/123.png
  3. Click Lock and Edit Configuration to enable changes to be made.
  4. Complete the elements with the following information.


• SMTP Server – SMTP server of your email
• Port – Port of the SMTP server (e.g. 25)
• Display name of sender – Any name(e.g.Oracle Business Intelligence)
• Email address of sender – Sender’s email address
• Username – Same as the sender’s email
• Password – password of your email
• Confirm password – confirm the same password as above
• Number of retries upon failure – any number
• Maximum recipients
• Addressing method To, Blind Copy Recipient (Bcc) – if you want to receive a BCC, select it.
  1. ctivate Changes.
  2. Return to the Business Intelligence Overview page and click Restart.

OBIEE Cache Management


Cache Management
Overview: Oracle BI Server to maintain a local, disk-based cache of query result sets (query cache). The query cache enables the Oracle BI Server to satisfy many subsequent query requests without accessing back-end data sources, thereby increasing query performance.
Advantages
  1. Performance Improvement
  2. Less network traffic
Limitations
  1. Chance to get stale data
  2. Hard disk memory
  3. Cache maintenance
Architecture


Enabling Cache
  1. Log in to Fusion Middleware Control
  1. From the target navigation pane, open Business Intelligence and select coreapplication.
  2. Select Capacity management again Performance


OBIEE Security -Part 3 - Data Level Security

Data Level Security:
Data Level security controls rights to view data. Row level security is implemented by the BI server on the background automatically allowing users to see data or rows to which they are authorized to.
You can choose to set up row-level security in the repository, or in the database. Implementing row-level security in the repository provides many benefits, including the following:
  • All users share the same database connection pool for better performance
  • All users share cache for better performance
  • You can define and maintain security rules that apply across many federated data sources
Setting up Data Level Security:
  1. A aususer created and assigned BICONSUMER group
  1. Create a User_country table
CREATE TABLE USER_COUNTRY
  ( USERNAME VARCHAR2(20),
COUNTRY VARCHAR2(25)
  )
  1. Insert sample data
insert into user_country(username, country ) values ('WEBLOGIC', 'USA');
insert into user_country(username, country ) values ('USER1', 'IND');
insert into user_country(username, country ) values ('SAMPLEUSER', 'AUS');
insert into user_country(username, country ) values ('AUSUSER', 'AUS');