Environment Setup

May 2, 2010

Once prototype step is over. Physical environment setup needs to be done for development, QA and Production. Based on requirement analysis one can define the tools required for the BO solution, server details, server size, database to be used to store the data. Its always better to have separate environment for QA, Production and development [...]

Read the full article →

Prototyping

May 2, 2010

Many times this step can be skipped if Organization is ready to implement the data warehouse and clear about why they need a data warehouse. Following points can help you to successful execution of this step. 1. Get the most talented and experience people in this step as there past experience in data warehouse design [...]

Read the full article →

Requirement Gathering and Analysis

May 2, 2010

The requirement gathering part is partially done in problem analysis phase. The document created in first step would help you to get started in this page. This is tough phase and is very critical to the success of your data warehouse development. Clear requirement and thorough analysis is must for success of any data warehouse [...]

Read the full article →

Problem Analysis and Definition

May 2, 2010

Problem definition and analysis is the important phase of any development project. A good problem analysis and definition leads to a good solution. While defining problems asking questions is a good practice to go to deep into problems this help further while designing approaches to solve the problem. Following questions might help you get started [...]

Read the full article →

Data Warehouse Project Life Cycle

May 2, 2010

Executing a data warehouse project is not different than executing any other development project. However one needs to be very structured and methodical in order to execute a project and making it a big success. Data warehouse project manager needs to be technical and business person who understand technical details along with organizations business. Following [...]

Read the full article →

SAP Business Objects Universe Development Life Cycle

May 1, 2010

1. Prepare and Analyze Before you touch the Universe Designer Well, Most of the designers make this mistake and they jump directly on designer. But this might end up you in future Universe Maintenance problems. Understanding the data source on top which universe to be developed is very important. The Universe designer must understand the [...]

Read the full article →

What is SAP Business Objects Universe

May 1, 2010

The Business Objects Universe is a semantic data model or layer between users and database ( that stores organization data ). In Business Objects terminology its a semantic layer which contains Objects ( dimension, detail and measure), Classes and which depicts Organization data store using Business Terminology to ease reporting.

Read the full article →

SAP Business Objects Certification

May 1, 2010

From Today, April 30, 2010 Business Objects Certified Professional(BOCP) certification is aligned as per SAP Certification policy and has now become SAP Certified Application Associate. Here are the exam code. C_BOCR_08: SAP Certified Application Associate – Crystal Reports 2008 C_BOE_30: SAP Certified Application Associate – SAP BusinessObjects Enterprise XI 3.x C_BOWI_30: SAP Certified Application Associate [...]

Read the full article →

Semantic Data Model

April 29, 2010

Semantic Data Model or layer. Semantic Data Model differ application to application used for reporting. Most the Business Intelligence tools have their own standards to design a semantic layer which will be used for reporting purpose. Semantic Data Model represents the physical data model in business terminologies, so that it can be used by business [...]

Read the full article →

Physical Data Model

April 29, 2010

Physical Data Model is the actual model which will be created in the database to store the data. It is the most detailed data model in Data Warehouse data modeling. It includes Tables names All column names of the table along with data type and size Primary keys, Foreign Keys of a table Constraints e.g. [...]

Read the full article →