Developers perspective of SAP HANA how HANA can reduce the development complexity and big bang for the buck :  In-memory Faster access to data which is predominantly stored in-memory rather than on disk with the use of buffers with limited space for only very frequently accessed data as is with traditional databases… Columnar stored tables… Read More »

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 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 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 »

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: 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 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 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 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 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 »