Stack Overflow
Stack Overflow

Questions tagged [kimball]

20 questions
3
votes
2 answers

Joining date dimension multiple times? - Kimball's book on Data warehouse and Dimension Modeling

I'm reading Ralph Kimball's book on Data warehouse and Dimension Modeling and in chapter 6, there is this part about dimension role playing. Sometimes you discover other dates associated with each transaction, such as the requested ship date for…
SabUrb
  • 31
  • 1
2
votes
1 answer

When to rename Date foreign keys?

A lot of times in "The Datawarehouse Toolkit" the authors switch their date foreign key name: Sometimes they use "Date Key (FK)" Other times they name it after the fact e.g. "Invoice Date Key (FK)" Why and when should this occur? When there are…
Peterson Davis
  • 119
  • 1
  • 7
2
votes
0 answers

Dimension model (recursive / hierarchical) for Data Warehouse

I'm having difficulty connecting a dimension table (recursive/hierarchical) to a fact table as there are concerns/issues to deal with: The dimension table belongs to a parent-child relationship structure From the original table, it keeps…
zysirhc
  • 37
  • 7
1
vote
1 answer

Calendar Dimension in Datawarehouse Modeling

In my datawarehouse model , I have Dim_Date containing a list of dates. I have a fact table Employee_Leaves containing the list of leaves taken by employees. My fact table has two dates Fk_Leave_Start_Date & Fk_Leave_End_Date . I modeled like this :…
userrr
  • 197
  • 7
1
vote
1 answer

Can a Dimension Table contain Multiple Data Sets

I am working with factual data that contains over 30+ attributes that can be used as dimension. These attributes are basically one dimensional -> ID, VALUE, SORTORDER. The source data from the source system also comes from a single table called…
LordRofticus
  • 181
  • 1
  • 2
  • 13
1
vote
1 answer

Is AdventureworksDW's FactInternetSales an accumulating snapshot table?

I always wonder if the FactInternetSale table of the AdventureworksDW is a accumulating snapshot table. It has a ShipDateKey in it. According to the AdventureWorks OLTP documentation, it says that the ShipDate of the SalesOrderHeader is the date…
Pblade
  • 133
  • 1
  • 9
1
vote
2 answers

Combining additive and semi-additive facts in a single report

I'm working on a quarterly report. The report should look something like this: col Calculation Source table Start_Balance Sum at start of time period Account_balance Sell Transactions Sum of all sell values between the two time…
Anton
  • 581
  • 1
  • 5
  • 23
1
vote
2 answers

Can we make data marts at the analysis side in kimball approach?

I followed kimball approach but the problem is I didn't make data marts before star schema. Now my question is can I make data marts in SSAS or is it mandatory to make these marts before schema in kimball approach? More Information: I am building a…
zara rana
  • 59
  • 6
0
votes
2 answers

Oracle partition / archive strategy for type 2 dimension table

I have a really wide table in Oracle that's at type 2 dimension. Records have from_dates and to_dates with the latest 'current' records having a high end date of 31st Dec 9999. There are currently two partitions on the table, one for the 'current'…
Reindeer
  • 575
  • 1
  • 4
  • 11
0
votes
1 answer

How to deal with numeric attribute in dimension?

I have a model where in my Project dimension, I have an attribute (AgreedReturn), which is a fixed number. I included it in my model, all good. My problem now, is that I have a requirement where users want a SUM of that attribute. This is very…
Chicago1988
  • 970
  • 3
  • 14
  • 35
0
votes
1 answer

Bridge table for many-to-many relationship

I'm confused about what the strucutre of the the bridge table. star schema book is stucturing the bridge table with a group_key example, if i have fact_orders ( order_sk , order_nk, amount, group_key) dim_sales_person ( sales_person_SK,…
Daniel
  • 1
  • 1
0
votes
1 answer

Is this the correct way to have multiple fact table?

Currently, i am in the process of designing a schema for storing product information which in the end will be used for analyzing the price changes, availability of the product itself. The granularity of the analysis can varied, whether its on item…
Rafael Aditama
  • 15
  • 4
0
votes
2 answers

Model scd by using role-playing?

I have this model, but I am unable to find if its “correct”, and what is the technical name for it. I am using Power BI, and for example, I have a Clients table: In my model (cube) I have it twice; I will have tables: Client and Client Current Data…
Chicago1988
  • 970
  • 3
  • 14
  • 35
0
votes
1 answer

Modelling customer onboarding in fact or dimension table?

I'm modelling the customer onboarding pipeline as an accumulating snapshot fact table. I'm considering the Joy Mundy's design tip to model this as a long-lived business process where I have a set of milestones which are updated as customers move…
josescuderoh
  • 65
  • 10
0
votes
3 answers

Star schema - splitting dimensions into multiple smaller dimensions

I have been working in dashboarding for a long time and have always been using the traditional kimball star schema to build my reporting and dashboarding on. The architecture team at work have been working on automating the dimensional star schema.…
user3195568
  • 131
  • 1
  • 1
  • 4
1
2