On-Line Analytical Processing, a class of systems designed for fast calculation, reporting and analysis of aggregate figures.

learn more… | top users | synonyms

3
votes
1answer
291 views

Connect tables in a cube based on historical data

So this may be the wrong place, and may seem pretty basic, but I'm new to building up cubes, so please forgive me. Imagine a setup described by the following: CREATE TABLE [dbo].[Orders] ( ...
5
votes
1answer
302 views

How to report on sparse areas of sparse fact table

A source system tracks student attendance for a school district by reporting absence events. Attendance on any particular day can be determined by examining three datasets: school calendar, student ...
7
votes
1answer
2k views

Medians, Modes, Percentiles and OLAP

I'm newbie trying to wrap my head around OLAP, and I have a few questions. Question 1: Can an OLAP cube store medians, modes, percentiles? Question 2: Can an user-written MDX query return a summary ...
3
votes
3answers
2k views

How does an OLAP cube database differ from an RDBMS?

Is a cube database, simply an RDBMS—such as PostgreSQL or MySQL—configured for OLAP via a star or snowflake schema? Or is a cube database different from an RDBMS, and if so how?
3
votes
2answers
344 views

looking for a lighter alternative to cognos express [closed]

I have a client that has about 10 staff. They want to add business intelligence services to an existing MySql database. It is a database containing purchasing and readership data for publications ...
1
vote
1answer
1k views

Design of fact table(s) and dimensions tables for data warehouse

Hi i'm newbie in Datawarehousing, how would you model this in a Data Warehouse: i wish design the Data Warehouse which give the answers of statistics relating to a baseball league For players in ...
4
votes
2answers
752 views

Combining retail sales and payment OLAP cubes

I'm using SQL Server 2005 Standard Edition Analysis Services (SSAS). I'm trying to build cubes from a retail OLTP database that can answer these kinds of questions: List down all products that were ...