Actual and Plan Facts at different granularity

Can a conformed dimension have a varying granularity?

Hi, Am I doing this right? It seems wrong. I have a dimension table that is to be used by multiple fact tables. It is a drug & regimen flattened dimension. A regimen is a set of various drugs. Three of the fact tables come from different source

Facts Tables linking to different granularity of a Conformed Dimension

Hi Sorry this may seem like a simple question. My scenario is I have two facts tables that link to different levels in a Conformed Product Dimension. Example: Fact 1 --> Product Fact 2 --> Product Category I could create a separate Produc

Actual vs Plan on different grain

Hello I have to prepare model for new datamart and I encountered following problem: I have a snapshot(weekly snapshots) fact table like this one: date_id branch_id prod_id segment_id amt plan and hierarchies like this one: dimension product

Conformed Dimension Processing Multiple Data Marts

Rookie question. We have 8 conformed dimensions and we are on our 4th data mart using some of these 8 conformed dimensions. We build the conformed dimensions once every night because the client wants to complete full refresh only. The client has

How does dimension hierarcy affect granularity?

Hi, I hope you can help with this problem, and I hope I can explain it well enough! I have a few different source systems which have drug data at different levels. E.g. One has a tree structure where drugs are grouped into sets for prescribing.

Question On Conformed Dimension design

After reading Kimball's section on Conformed dimensions and making some changes in my project, I have question related to design. I have a "Person" dimension that is used in 4 different fact tables. I am creating a fifth fact table for Claim Payment

How to manage Conformed dimensions

Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this

Fact modeling: Investment Plan, flat vs dimensional?

Hi all, I'm working on a project where I'm bringing in information around investment plans for universities. An investment plan is created yearly and has the following elements: Investment Plan 2011: - Estimated Students Current Year (2011) - No o

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Nixon implemented the Philadelphia Plan

Nixon implemented the Philadelphia Plan, the first significant federal affirmative action program in 1970.[125] Nixon also endorsed the Equal Rights Amendment after it passed both houses of Congress in 1972 and went to the states for ratification as a

OSLO BOMBED, PEOPLE KILLED IN YOUTH CAMP ATTACK

BBC News: 22 July 2011 Last updated at 17:13 GMT Oslo: Bomb blast near Norway prime minister's office A massive bomb blast has hit government buildings in the Norwegian capital Oslo, killing at least two people and injuring 15 others. PM Jens

Dimensions Advent Calendar.... Ho Ho Ho.

I thought it could be a good idea for the following 24 days, to open together on each day a door of our.... DIMENSIONS ADVENT CALENDAR. So feel free to post and open a door, if you would like too... I will be brave to open the first. I´m

Should we ship to other forum software?

The title says it all, do you think webartz needs to ship to a different forum software, either phpbb3 or mybb (more preferred) ? the other open source forum systems are more popular these days and i guess it would help us gain members who hate

Actual and Plan Facts at different granularity - one conformed dimension?