Kishore Analytics Solutions

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...
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...
OBIEE 11g - Display user name and time of the report run and the time zone in OBIEE reports

Way to display current date and time and other useful information in OBIEE Is to use the narrative or static text view and display them b...
Defining Source Data Structures In OWB from a SQL Server

Note: I have used Oracle Warehouse Builder 11.2.0.1 Start the Design Center Start button -> All Programs -> Oracle 11g In...
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...
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...
Getting Started with Oracle BI Publisher 11g

Overview Oracle BI Publisher is a strategic enterprise reporting product from Oracle that provides the ability to create and manage hig...
AND Condition

The SQL "AND" condition allows you to create an SQL statement based on 2 or more conditions being met. It can be used in any va...
OBIEE 11g performance Settings BI Server

OBIEE 11g performance Settings BI Server OBIEE 11g performance Settings Oracle BI Server Component Tuning Guide F...
[OBIEE11g] - Table view Date Column controlled by Two Date Prompts

This page shows how you can setup up 2 dashboard prompts to restrict your data to show between a start date and an end date. To accomplis...

VIEWERS

Visitors map

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