Kishore Analytics Solutions

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. NQODBC SQL_STATE: HY000 nQSError: 10058 A general error has occ...
Exploring Advanced Features of Oracle BI Publisher

Overview The Getting Started with Oracle BI Publisher OBE covered the regular features such as creating reports from various data sou...
OBIEE 11g Creating Analyses and Building Dashboards 11.1.1.6.2

Purpose In this tutorial, you will learn how to build, format, and customize Oracle Business Intelligence (BI) analyses and how to crea...
OBIEE11g - Enable Log-Level from Advanced Tab

In the Advanced tab, Add below tag in the prefix and click Apply SQL. SET VARIABLE LOG_LEVEL = 2; Log from Administration ...
IS NULL

In PLSQL to check if a value is null, you must use the "IS NULL" syntax. For example, IF Lvalue IS NULL then ... END IF...
Trunc Function (with dates)

In Oracle/PLSQL, the trunc function returns a date truncated to a specific unit of measure. Syntax The syntax for the trunc functi...
Sysdate function

In Oracle/PLSQL, the sysdate function returns the current system date and time on your local database. Syntax The syntax for the s...
Next_Day Function

In Oracle/PLSQL, the next_day function returns the first weekday that is greater than a date . Syntax The syntax for the next_day...
Merging/Importing Objects from Different Repositories using Oracle BI Administration Tool

Purpose This tutorial covers how to merge/import objects from different repositories using the BI Administration tool. The three-way me...
SQL Query and Answers

Here I am sharing the set of SQL Queries with Answers which I have prepared. Working in OBIEE and in database It is good know about the b...

VIEWERS

Visitors map

Oracle Business Intelligence. Awesome Inc. theme. Powered by Blogger.