Monthly Archives: February 2016

Bill Inmon and Ralph Kimball methodology

Bill Inmon’s paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse. In the data warehouse, information is stored in 3rd normal form. Inmon’s approach, also called top-down, is to have “one version of the truth“, a… Read More »

Relational Vs Dimensional Model

Relational model The relational model is used in transactional systems where many transactions are executed, most of them concurrently. A transaction inserts, updates or in any other way processes data in a database. In many occasions a transaction is an integral part of the business process. As an example, a bank transaction is a business… Read More »

DDL, DML, DCL and TCL

DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: CREATE – to create objects in the database ALTER – alters the structure of the database DROP – delete objects from the database TRUNCATE – remove all records from a table, including all spaces allocated for the records… Read More »

HAVING VS WHERE

Though the HAVING clause specifies a condition that is similar to the purpose of a WHERE clause, the two clauses are not interchangeable. Listed below are some differences to help distinguish between the two: 1. The WHERE clause specifies the criteria which individual records must meet to be selcted by a query. It can be… Read More »

Procedure Vs. Function

PROCEDURE: CREATE OR REPLACE procedure_name(arg1 data_type, …) AS BEGIN …. END procedure_name; Example: CREATE OR REPLACE PROCEDURE ADD_EVALUATION ( evaluation_id IN NUMBER , employee_id IN NUMBER , evaluation_date IN DATE , job_id IN VARCHAR2 , manager_id IN NUMBER , department_id IN NUMBER ) AS BEGIN NULL; END ADD_EVALUATION; FUNCTION: CREATE OR REPLACE FUNCTION calculate_score (… Read More »

Stored Procedure based Universe in BO

Stored Procedure Universe A stored procedure can be a used in a UNV universe and provides some performance improvement.  The feature itself has many restrictions that should be considered before designing a universe with them.  This is an explanation of this feature and some of the benefits and limits of its use. Since version XI3.1… Read More »

BIAR file in Business Objects 4.x

BIAR files are no longer used in BI4.x for the same purpose as we used them in Xi3.1. In BI4.x BIAR files can only be generated by UMT tool and can only be imported into next version of the product. We need to log into the CMS and use Promotion Manager which used to be called… Read More »

Data Flow for User Login in BI Launchpad

Data Flow in SAP BusinessObjects  4.0   SAP BusinessObjects Business Intelligence platform can be thought of as a series of conceptual tiers. 1. Client tier 2. Web tier 3. Management tier 4. Storage tier 5. Processing tier 6. Data tier   Steps shows the interaction of platform components when a user logs on to BI… Read More »

BO 4.0 WEBI –New Features

BO 4.0 WEBI –New Features BO 4.0 provides a lot of exciting new features. Here we will take a look into the important new features of Web Intelligence Reports. Web Intelligence Reports: The Infoview portal which contained WEBI reports has now been renamed to BI Launch Pad. On logging in, a screen like below is visible… Read More »

List of values in Business Objects

List of values in Business Objects A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. List of Values is a powerful feature that allows users to select from a pick list… Read More »