No announcements

### Multiple Fact Table Design

identical grains.  Based on your scenario above I would imagine the following fact table design; Trade ...
| 3 Replies | 3759 Views | Created by KiwiInLondon - Thursday, April 12, 2012 1:04 PM | Last reply by KiwiInLondon - Thursday, April 12, 2012 5:24 PM

### SSAS 2008 Multiple Measure Groups/Fact Tables Design Opinions

the dimensions overlap, the more likely you will eventually have meaningful queries (or calculations) that include measures from multiple fact tables.
| 4 Replies | 8862 Views | Created by Tufte - Tuesday, March 31, 2009 3:22 PM | Last reply by DSU007 - Wednesday, April 1, 2009 7:44 PM

### Design Question on multiple fact tables

Hello, I designed a cube for our HR group that worked well. In the fact table there are multiple rows for each employee to show their events as ...
| 2 Replies | 6728 Views | Created by Gumbatman - Tuesday, January 19, 2010 3:02 PM | Last reply by Gumbatman - Tuesday, January 19, 2010 9:19 PM

### Design help on multiple fact tables

I need some guidance on how to design a cube which I think needs multiple fact tables. The main problem I am facing is how to link the fact ...
| 6 Replies | 3043 Views | Created by pretzelb - Thursday, July 4, 2013 6:19 PM | Last reply by Orsolya Gal - MSFT - Tuesday, August 6, 2013 11:02 AM

### Cube design - One cube with multiple fact tables or one cube with one fact table

Hello, What are the factors that lead to below designs.. -one cube with multiple fact tables -one cube for ...
| 1 Replies | 6957 Views | Created by Dattatray Nale - Sunday, March 3, 2013 2:54 PM | Last reply by Zaim Raza - Sunday, March 3, 2013 11:23 PM

### Designing cubes using multiple fact tables

I have a question on cube design: I have 4 fact tables in my DW. All of them share 2 dimensions and they have private dimensions, 1 each. ...
| 5 Replies | 3861 Views | Created by Fazalul Haque - Monday, March 1, 2010 8:22 AM | Last reply by Thomas Ivarsson - Tuesday, March 2, 2010 12:01 PM

### Cube Design - Multiple fact tables against one dimensions.

codeplex) has an example of the date, product and Sales Territory (as well as other dimensions) related to multiple fact tables - specifically Internet Sales and Reseller ...
| 2 Replies | 1817 Views | Created by DanterUK - Thursday, October 6, 2016 7:26 AM | Last reply by Thomas L. LeBlanc (MVP) - Thursday, October 6, 2016 1:21 PM

### SSAS Design - Multiple keys of same dimension in a fact table

Hi, I am developing a BI solution on SQL Server 2008 R2 and i need advice how to handle multiple referances to the same dimension from a fact table! Here ...
| 4 Replies | 11639 Views | Created by Temha - Monday, March 19, 2012 8:43 AM | Last reply by Martin Chaine - Wednesday, September 30, 2015 11:28 AM

### Cube design with multiple fact tables - how to set up a parent/child fact table properly?

to insert 1 or 0 for the "Nb of Orders" measure which depending on the size of your fact table may not be feasible.) You need to consider the number of ...
| 3 Replies | 6080 Views | Created by DanielBos - Wednesday, April 28, 2010 9:14 AM | Last reply by Philip Stephenson - Thursday, April 29, 2010 8:37 AM

### Dashboard Designer Data Source Time Dimension for fact tables with multiple time associations

Unfortunately, we don’t allow that time intelligence data source mapping to work across multiple hierarchies.&nbsp
| 1 Replies | 9047 Views | Created by xhead - Friday, October 9, 2009 4:04 PM | Last reply by xhead - Friday, October 9, 2009 7:01 PM

### Data Warehouse Design for Case/Nested Tables in Market Basket Analysis

warehouse; -apply the association rules on the prepared data warehouse as a source. The problem I have is reconciling the data warehouse fact/dimension table design with ...
| 2 Replies | 12166 Views | Created by Katie Malecka - Sunday, October 11, 2009 10:03 PM | Last reply by jibran jamshad - Tuesday, August 3, 2010 7:45 AM

### Design Question

Guys, Can I ask you a design related question? We are designing a trading system that has two main components backoffice and frontoffice. The ...
| 0 Replies | 5438 Views | Created by HariK - Monday, May 21, 2007 2:49 PM

### a fact table referencing the other fact table

Hi I am designing the data warehouse for a leasing company. This company will have multiple clients and data will stored in dimension ...
| 1 Replies | 8694 Views | Created by DigitalFM - Thursday, December 23, 2010 3:22 PM | Last reply by Kieran Patrick Wood - Friday, December 24, 2010 8:46 AM

### Fact and Dimension tables Design

I've a fact table with 2 measures (total transaction, unique transaction) and multiple FK dimensions. One of the dimensions is the Rejection Reason dimension which ...
| 4 Replies | 4646 Views | Created by Ash_ - Thursday, January 15, 2009 6:15 PM | Last reply by DSU007 - Thursday, January 15, 2009 9:38 PM

### Data warehouse schema top down design guidelines?

. When you start with designing a new cube, will the number of measure groups result in the same number of fact tables? What guidelines ...
| 0 Replies | 1326 Views | Created by shiftbit - Wednesday, September 25, 2013 8:00 PM

### Data model design - Attribute shared by many dimensions

I hope this is the correct forum for this question... I have a fact table that contains phone call data. Two of the dimensions related to this fact are ...
| 0 Replies | 5552 Views | Created by Rockabilly Jim - Monday, April 20, 2009 3:00 PM

### SSMS - 'has detected that an operation is blocking user input.' - Using the view designer

drag tables or views into the designer. The problem occurs when using multiple screens, I run SSMS on the second monitor, but my laptop monitor ...
| 1 Replies | 1530 Views | Created by Arefos - Friday, November 9, 2018 9:01 AM | Last reply by Teige Gao - Monday, November 12, 2018 2:39 AM

### Data model

Hi, I have one dimension table named "EntityCategory" in which one entity belongs to multiple Categories.My Fact table contains measures for the granular ...
| 2 Replies | 2203 Views | Created by bideveloper2011 - Thursday, September 29, 2011 5:26 PM | Last reply by Mr.QuestionMark - Thursday, September 29, 2011 8:48 PM