BusinessObjects Topics

Search This Blog

BusinessObjects Topics
Showing posts with label Data warehouse. Show all posts
Showing posts with label Data warehouse. Show all posts

Wednesday, March 2, 2011

BusinessObjects Topics • View topic - Degenerate dimension

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

Read more »

Monday, February 7, 2011

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 »

Wednesday, September 8, 2010

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 »

Friday, February 12, 2010

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 »

Sunday, September 14, 2008

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 »

Friday, September 12, 2008

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 »

Wednesday, July 23, 2008

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 »

Sunday, July 20, 2008

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 »

Saturday, July 19, 2008

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 »

Tags

Oracle Data warehouse Business Objects Business Objects XI R2 Business Objects XI 3 PLSQL BOBJ BI News Business Objects FAQs bo DataModeling Concepts Databases Server Administration BOCP-BOE Business Intelligence (BI) MS SQL Sever Database Universe Designer Certification Designer REPOSITORY SAP BI SAP Education Supervisor BO Reporter/ functions BO XI 4.0 BOXI 3.1 Business Objects Designer Downloads Fan / Chasm Trap Functions Integration and Certification Loops MS SQL Sever Administration OLAP QaaWS SAP Business Objects SAP BusinessObjects Business Intelligence 4.0 Star Schema Universe Design Web Intelligence WebIntelligence