Fact Table Grain at a Sub-Atomic Level

Multi level grainulity in Fact table

Hi , I have strange scenario . The fact table needs to be loaded in different Multi Level Grainluity ,this typical scenario was handled in ETL with complex coding. Advantages of so, 1) The report was directly taken from single table and had no

One Fact table having records at different granularity level

Hello, My question is just validation for an approach that we followed for one of our client requirements. Based on the requirement the FACT table should be constrcuted by the records from 2 Source table A and B. The structure of the table is as

Handling fact tables with different grain in Business Objects

Hi, i'm new to BI and Business Objects tools in particular. We have a fairly simple "Sales" datamodel - only 4 stars. the problem we're facing is the "SalesPlan" data. "SalesPlan" is defined on two different levels and more

multiple 'fact' tables - daily detail and monthly allocations

I am sure this has been asked but I could not find a direct answer. We have an EDW with a transaction level fact table including pertinent financial detail. For the purposes of this question there are multiple transactions per client, and multiple clients

Help in declaring grain and identifying dimensions

Requirements: 3 Reports ----------------------- Source Systems: 3 Project DBs 1st Report : Portfolio Summary Details The project monthly details report will display project information i.e. summary actual costs from the Vendor History file

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Extinction Level Event - 3/11/11 Elites First Group Ark

Well this is enough to give me the permanent shakes starting this morning. http://www.youtube.com/watch?v=kWhFv22nB_k&feature=more_related

Level Up bar

Nature of the Creation: Level Up bar Size (In Pixels): n/a With or Without Animation: No Main Colors: Blue Pictures & Links: None Text to Insert : The levels Font (Provide Download Link): None Font Color: White Link to My Forumotion

Random Facts October

They grow up so fast! RF: The staff is organising a birthday party for the forum, but don't tell anyone!

Migraines and thyroid

An interesting article on the role of an even slightly underperforming thyroid on migraines. http://headaches.about.com/od/comorbidconditions/a/thyroid_comorb.htm Has anyone here had a doctor investigate their thyroid? I've never had anyone bring