Aggregated Measure

kellog1 at 21h37
23
Dec
2010
Aggregated Measure

Gurus,
I have relational database where there is only one measure that is at an aggregated level whereas Dimensions are at lower level of granularity. Let me give you an example...


ProjectNumber CurrentAmount
5501900000 2000000.00

ProjectNumber Code
5501900000 310
5501900000 124
5501900000 200

Can somebody shed some light on designing a fact table for the above scenario.

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
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
Aggregated Date Dimension
In my dimensional model, I have a Date dimension that plays many different roles in multiple fact tables. I will also have a fact table that store metrics aggregated at the Month level and one that stores metrics aggregated at the Quarter level. How
Conformance of Dimension for facts aggregated at different levels
I am a newbie to Data Modeling. I am modeling a warehouse for Global reporting solution for a business operating in 3 countries. 2 business processes involved are "Sales" and "shipment Expenses" The input is sumarized excel files
Loading Data Aggregated to Date into Fact Table
I have following source table: Source Table ID App_Version Os_Version Date 9123305 2.5.2.60 Windows NT 5.1 2/15/2009 9123306 2.5.2.60 Windows NT 5.1 2/15/2009 9123307 2.5.2.60 Windows NT
Fact table with non-numeric measure
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with
Forums from same category
Informations

7 Replies For the topic :
"Aggregated Measure "

This topic has been viewed 591 times.

Last message :
23/12/2010 at 21h37 by "kellog1"