Measures as Dimensions: Banding Approach Help

Value Banding linked to a calculation

I have an interesting problem - how to hook up value bands to fact rows that require a computation. I have a fact table where the measure I'm interested in is a percentage. In order to cope with roll-ups I am storing the actual and the divisor as

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

Monster Dimensions

My customer list is huge (about 70 millionish). We currently have a 60 million row dimension (CUSTOMER) that holds most of our existing customers, and this existing large DIM is currently performing fine for us. Now my clients want to type 2 two

How many measures in a fact table is acceptable?

Hi, I would like to find out what is the maximum number of measures allowed in a fact table? Thanks

Inventory Snapshot - GMROI Calculation

We are developing a solution for our company. We currently have a sales cube and we are in the process of building an inventory cube. We are having a design problem in that we are not sure if we should include some of the measures which currently exist in

internationalist approach to resolve all outstanding issues between Iraq and Kuwait

Bwalun: internationalist approach to resolve all outstanding issues between Iraq and Kuwait Topic 6 has been read once 31/01/2011 Paris will seek to re-integration of Baghdad, the international community Baghdad, Omar Abdel-Latif Said French

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

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

SANITARY AND PHYTOSANITARY MEASURES - New pest rules for containers on horizon, cash-strapped agency tells WTO

Work is underway on standards for “minimizing pest movement by sea containers and conveyances in international trade”, and is at an earlier stage on similar standards for air containers and aircraft, the IPPC told the WTO’s Sanitary and Phytosanitary (SPS

INTL 101: AN INTERDISCIPLINARY APPROACH TO GLOBAL ISSUES

book used by Dr. Sumer, lets say $35 Email: castrobj@vcu.edu

Normalization in DWH environment

Hi All, Recently I came across a question,would like to post it here for the views of the members. What normalization form are the Fact and dimension tables and why (with examples aligning to the Normalization definition) Thanks, Dheeraj

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

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