Should I use a degenerate dimension or create a junk dimension?

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

Textual fact or Junk dimension?

Hello, I have been following the forum for a while now and I must say that many doubts about dimensional modeling have gone thank to you all. However I am facing now the modeling of a cube and I am somewhat stuck on what is the best

two facts that relate via degenerate dimension

Hi, I have a order line fact which look like this: Order Line Fact ------------- Order Line Key (SK) Order Line number (DD) Order Number (DD) Some measure (fact) Now some time later I have another fact which would reference the Order Number

use of degenerate dimension to physically join two logically related fact tables

I am looking for a sanity check on a design decision. Here is the scenario: The business domain is insurance, specifically life and annuity. I have two fact tables - factPolicyTransaction and factCommissionTransaction. Policy transactions,

Junk Dimension Naming

What do you call your junk dimensions? Do you use "junk" in the dimension name? Junk implies garbage so I don't like using it. Most dimensions are easily named since they represent a single person, place, thing, concept, or event. Junk

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

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)

Hello, Within Ralph his new book he describes recommanded situations for snowflaking a dimension. His example is a large customer (visitor) dimension. (page 337, 338 and figure 10-6). I find the artical good, but there is missing one part of this

Overlapping Dates in a dimension

Hi, I am wondering if someone could advise me on how to deal with this design problem. I have a promotion dimension keyed to a sales fact table. Initially, we thought that only one promotion could be active at one time for a sale, but it is actually th

How to Create your very own FUBU!

I was always intrigue with type of question on how to create your very own FUBU? Much better if anyone from the master would share their tips and tricks in fulfilling your dreams of having a partner for tonight.

MDX(or something else) for getting history based on last dimension characteristic for SCD.

Hi everyone, I am implementing a cube and I run into a problem with slowly changing dimensions(SCD type 2). I guess it might be resolved somehow with MDX or somehow else, maybe you guys can help me to resolve it. The problem: I have SCD, say Policy wit

[NEW CONTEST] Create Forumotion Wallpapers!

Dear members To always make you happy and thank you for your loyalty, Forumotion offers you a unique contest with many credits to win! ☆ You're an artist ? You like to create ? ☆ You want to participate in Forumotion community ?