Multi-valued dimension with distinct attributes

Multivalue attributes

I am working on a model for use by the fund raising unit of our university. They want to be able to do some CRM type reporting on our alumni / donor data. In creating a constituent dimension I have found that there are a large number of attributes tha

Multivalued Dimension or Multiple facts w/conformed dimensions

I am trying to model for insurance industry, with data as follows: We have data at different levels: Policy level with related facts. ((Premium , face amount, mode etc) Policy Fund level (combination with related fact values.) Policy Rider level

Multivalued Dimension, bridge table, and constraints using SQL Server 2005

I'm developing a healthcare claims data mart. The diagnoses fields in the claims data are being implemented as a multivalued dimension, which consequently requires a bridge table between FactClaims and DimDiagnosis. The bridge table contains two

Same attribute in multiple dimensions or Create new dimension?

Hi all - I'm struggling with this concept. I have 2 dimensions: Customer and Products. Both share a common single attribute that I'll just call "Owner" for now. If a customer purchased a product, the owner would be the same for both. I

Modeling multiple multivalued dimensions and other design questions

Hello, all. This is my first time working on a dimensional model and I have some questions regarding multivalue dimensions. I am modeling our Remedy trouble ticket process and was settling on the grain being each individual ticket. The problems come in

Multi valued dimension attributes, weighting factor and cognos

Hi, we have several attributes in our product and customer dimension which might by multi valued. We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein. Can anybody reference a best practice

Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s

Hello, We are in the process of designing a DW for Games and have run into a business problem : Business users want to add attributes to a dimension and decide its level in the hierarchy on the fly. The new attributes should be availabe in reports

Multi Disc Movies and Multi Disc TV Shows

What is the proper way to handle a movie that has multiple DVD's? And what is the proper way to handle Season Compilations of TV shows?

India has a multi-party systemIndia has a multi-party system

India has a multi-party system with a predominance of small regional parties. Political parties that wish to contest local, state or national elections are required to be registered by the Election Commission of India (EC). In order to gain recognition

Exchange rate should be RE-valued to something like 1.43 bolivars / US$

Published: Wednesday, July 08, 2009 Bylined to: Arthur Shaw [size=21]Exchange rate should be RE-valued to something like 1.43 bolivars / US$[/size] VHeadline commentarist Arthur Shaw writes: The Venezuelan currency pegged at one dollar for 2.15

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from

Multi quoting

Would it be possible to be able to quote multiple posts when you reply a topic? Invision and vBulletin both have that feature and it comes in very handy sometimes.

Lanka Hospitals (LHCL) highly under valued

As per the quarter ended from 30.09.2010 reports Earnings 64,301,732 Expected growth in earnings for quarter ended 31.12.2010 65% Expected earnings 106,097,858 No. of shares in issue