Aggregates with Distinct

Maverick at 18h27
05
Jun
2010
Aggregates with Distinct

Hi all, I am currently wroking on a Star Schema [with few dimensions and one fact :-)] but ran into some issues regarding Unduplicated Aggregates.
Let me explain:
we have the following dimensions :
Ofices
Staff
Services
Time

Fact:
Total Customers Served [Unduplicated]
Total Services pro

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Aggregate Tables usage
We are building a datawarehouse and it has been proposed to contain both detail and aggregate tables, with the aggregate tables at the month level and detail at the daily level. I do understand that aggregate tables are done to gain at the performance
Multi-valued dimension with distinct attributes
In the health care data analysis DW, the grain of one of my fact tables is the episode of care. How can I include procedure codes performed on an episode ? if I create a multi-valued dimension for it and used bridge tables to model this, it will end up
Counting coverages over time
Hi All, I work for a non-profit mental health org. Many of our clients get benefits from the county. These benefits last a year and then a new one is requested. They have different categories of benefit (2X1, 3A1, 3B1). I need to count the number of
Understanding Materialized Views as aggregate tables
Hello I have to provide a count and I am using a materialized view in sql 2008 as an aggregate table. My issue is understanding how the count will work. I need a count by 3 different categories (Product, Type, and TypeName). So....should that field be
Dimension Hierarchy - Facts by various levels
Hello, I am working on a new project (with Oracle OBIEE) where most data needs to be seen by a terminal(game or cahsier). The terminals are located in different venues in various cities and states. Some terminals may just be at a city or a state level
Forums from same category
Informations

5 Replies For the topic :
"Aggregates with Distinct"

This topic has been viewed 1293 times.

Last message :
05/06/2010 at 18h27 by "Maverick"