Time dimension confusion
Hi, first post here so I hope someone can advise on this. I'm looking to remodel time dimensions to somehow combine monthly 'periods' and weekly 'periods'. The aim being similar to a fiscal calendar where each week is allocated into a month period (e.g.

Dimension loading sources
Hi all, It's about datawarehouse dimension loading : should i load dimension from a master data management referential or from the truth of my business application. In the first case, dimension will be cleaner than in the second case but it will not

Remedy for a Bridge Table?
Hi folks, I'm looking to get rid of my bridge table. (yes I know why whould I want to do that?) Reason being that I am using Mondrian and as far as I can tell bridge tables don't fit. My Situation: I have many facts and many Participants each

fast changing dimension
I'm debating how to model a teacher work force where most often a teacher works for one school authority. The issue is where a teacher works for multiple school authorities. A substitute teacher for example could work for a different school authority ever

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

many to many relationship between dimension level
I need help to design dimension model. Detail of Dimension are as following: Dimension : Student, School Fact : Grade 1. Class_Year 2. School 3. Area 4. City Analysis Requirement are to drill up /down by above given hierarchy there is : M:1

Specify acceptable Snowflaking scenarios
Can someone please specify acceptable snowflaking scenarios. - Thanks in advance bi_at_nj

Static Facts on Dimension Table?
I have basic dimensional modeling question. I would like to know if anyone can cite issues with putting a static fact on a dimension table vs. putting it on a fact table. The example I'll use is that of an 'asset' dimension table and a 'month-end'

Surrogate Key causing incorrect results
Hi Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:- I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications

Advice on relationships between Type 2 SCDs ?
Hi All, I am constructing a new warehouse schema containing a number of dimensions which need to be modeled as type 2 SCDs. This is all fine and I have surrogate IDs which are being used as the FK in the facts. The challenge I have is that a number of

Indicator Dimension or Fact Table
Sorry, this is a long explanation but I wanted to document the entire “case”. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a

How do you handle weighting when you have multiple mulitvalued dimensions?
I've been reading The Data Warehouse Toolkit (2 ed.) and I can't seem to find a section that discusses how to handle weighting when more than one multivalued dimension is included in the design. I work with healthcare claims; we're in the process of

Joining facts through conforming dimensions
I've seen some overlap in some posts but I don't want to hijack someone elses thread to attempt to get clarification for my scenario. I also didn't want to simply make the title "Joining Fact Tables" because I know the immediate response would b

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

Date Dimension
Hi All, I understood Kimball way of implementation Date Dimension table. In a way, the lowest granularity date represent each record, with the following month, quarter and year attribute. However, what happen if the lowest grain of certain fact are at