BusinessObjects Topics • View topic - Degenerate dimension

BusinessObjects Topics • View topic - Degenerate dimension Vi...

Read more »

Benefits of a Data Warehouse

Benefits of a Data Wareho...

Read more »

What is META DATA?

what is META DATAvisit our new blog www.businessobjects-sapbo.blogspot....

Read more »

What is OLAP?

What is OLAP Visit our new site www.businessobjects-sapbo.blogspot....

Read more »

Inmon vs. Kimball - An Analysis

Mr. William (Bill) Inmon is known as the “Father of Data Warehousing”, entitled for coining the term “Data Warehouse” in 1991. He defined a model to support “single version of the truth” and championed the concept for more than a decade. He also created “Corporate Information Factory” in collaboration with Ms. Claudia Imhoff. Mr. Inmon is known to have published 40+ books and 600+ articles.Mr. Ralph Kimball is known as the...

Read more »

Evolution of the BO XI platform – from XI R2 to XI 3.1 SP2

Where were we with XI R2:• Change to Crystal service-oriented platform (Crystal 10 architecture)• Ability to plug Crystal Reports, Web Intelligence, Desktop Intelligence, OLAP Intelligence, Dashboard Manager, Performance Manager directly into the framework• Single repository, security, system management, publishing, portal• Infoview (Replaced...

Read more »

Data warehouse Concepts

Central Data warehouseA Central Data Warehouse is a repository of company data where a database is created from operational data extracts. This database adheres to a single, consistent enterprise data model to ensure consistency in decision making support across the company.Active Metadata WarehouseAn Active Metadata Warehouse is a repository of Metadata to help speed up data reporting and analyses from an active data warehouse....

Read more »

ODS Vs. Data Warehouse

ODS Vs. Data WarehouseOperational Data store- Data Focused Integration From Transaction Processing Focused Systems - Age Of The Data is Current, Near Term (Today, Last Week’s)- Primary Use: Day-To-Day Decisions Tactical Reporting Current Operational Results - Frequency Of Load: Twice Daily , Daily, WeeklyDatawarehouse- Subject Oriented,Integrated,Non-Volatile,Time Variant- Age of the Data is Historic (Last Month, Qtrly,...

Read more »

Differences between OLTP and OLAP databases.

Differences between OLTP and OLAP databases.Relational Database (OLTP) Data is atomized Data is current Processes many records at a timeProcess oriented Designed for highly structured repetitive processing Dimensional Database (OLAP)Data is summarizedData is historicalProcesses one record at a timeSubject orientedDesigned for highly unstructured analytical process...

Read more »

Operational data store (ODS)

Operational data storeA subject-oriented system that is optimized for looking up one or two records at a time for decision making. An operational data store is a hybrid form of data warehouse that contains timely, current, integrated information. The data typically is of a higher level granularity than the transaction. You can use an operational data store for clerical, day-to-day decision making. This data can serve as the common...

Read more »

Data Mart

What is Data mart? A subset of data warehouse that is stored in a smaller database and that is oriented toward a specific purpose or data subject rather than for enterprise-wide strategic planning. A data mart can contain operational data, summarized data, spatial data, or metadata. Typically, you use a dimensional data model to build a data ma...

Read more »

The Star Schema

A good dimensional data warehouse has a simple database structure. Technically, a simple structure means faster queries. In a dimensional data warehouse, the implementation relational database has two types of tables, the fact table and the dimension table. The fact table consists of the facts (or measures) of the business. Dimension tables...

Read more »

Data warehouse Concepts - Day 2

dimension table:A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes. LookUp tableA LookUp table is the one which is used when updating a warehouse. When the lookup is placed on the target table (fact table / warehouse) based upon the primary key of the target, it just updates the table by allowing only new records or updated...

Read more »

Data warehouse Concepts - Day 1

Data warehouse :A Data warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated. This makes it much easier and more efficient to run queries over data that originally came from different sources". Another definition for data warehouse is: " A data warehouse is a logical collection of information gathered from many...

Read more »