Current and Historic Dimensions (one table or two?)

1 Dimension used multiple times in 1 fact table?

Hello, I have a dimension used to store several types of 'bands' like monthly income bands, available income bands, risk bands, settlement bands etc. If I leave out all the lineage columns this is what the dimension looks like: DimBandID BandType

Dimensions in fact table

Hello, I'm working definining a dimensional model in a bank. We have Teradata as DB and MicroStrategy as BI tool. We have many fact tables and most of the fact table lowest level is the "Contract" dimension. We have many other dimensions that

Slowly Changing Dimension table

Hello, I have scenario where we are creating a Dimension Table and Fact Table from the same Source Table which contains both descriptive and numeric data I want to model the Dimension table as a Slowly changing Dimension Type 2 (create new

how many dimensions is too many

If I have a fact table with too many dimensions --- over 30, does that mean I've created dimensions when they could have been attributes to another dimension table or possibly that I am trying to capture too many business processes within one fact table.

KPI Goals and Percentages as Dimensions or Store as Facts?

We are using PPS Monitoring for our Dashboards and we are creating our KPIs within PPS and SSAS. Our client would like to create a dimension with these KPI goals and percentages for each goal per department and measures or add to the fact table. Now

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

Legitimacy of the current government .. Another political controversy

Legitimacy of the current government .. Another political controversy Sudanese Mohammed of Baghdad: the debate is still raging between the political blocs on the current form of government Some considered it a caretaker administration and the other see

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Arbil Meeting historic moment for Iraq’s development” - Barzani

Arbil Meeting historic moment for Iraq’s development” - Barzani November 8, 2010 - 02:09:33 ARBIL / Aswat al-Iraq: The President of Kurdistan Region, Massoud Barzani, has said in the opening of Arbil’s Meeting of the Leaders of Iraq’s

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

What's the current time in your country?

well this is simple Just tell us what's the current time on your country everytime you log or so on It's 9:15 pm here.

Adding to the current descriptions of forums

Hello all, id like to suggest that we ( here at the SF ) add something sich as "No support here" to the descriptions of the GD ( General Discussions ) section, as it would minimize the level of "support" in the incorrect

Volume and Weight in Same Fact Table

Is it appropriate to include two facts that are not of the same type? In my example, I may need to have both Volume (Gallons) and Weight (Pounds) in the same fact table. I am building a DW around products that we recycle, these products can be Oil or