Modeling multiple multivalued dimensions and other design questions...

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

How do you handle weighting when you have multiple mulitvalued dimensions?

I've been reading The Data Warehouse Toolkit (2 ed.) and I can't seem to find a section that discusses how to handle weighting when more than one multivalued dimension is included in the design. I work with healthcare claims; we're in the process of

multiple hierarchy : single dimension vs multiple

Hi Need to analysis sale revenue by store. We have two separate hierarchy for geographic location 1. Country / County / Council / Store name 2. Country / Region / Area / Store name Need valuable suggestion for how to design dimension for above to

Multi-valued dimension with distinct attributes

In the health care data analysis DW, the grain of one of my fact tables is the episode of care. How can I include procedure codes performed on an episode ? if I create a multi-valued dimension for it and used bridge tables to model this, it will end up

Slowly Changing Dimensions - Design Review (Need More Clarification)

Hello, Suppose I have following Fact and Dim table CustomerDim CustomerKey CustomerID CustomerNumber CustomerName CreditLimit - Slowly Changing, wants history IsAnnualMember - Slowly Changing, can be different from year to year or

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

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

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Dimension Modeling Design challenge - Help Needed

Guys, Help me out identifying whats wrong with my model. I am able to get to the right data, but size of the fact table is arguably high and not gladly acceptable. Let me show you the picture (tip of the iceberg) Data table in transaction db is

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

wEdETykE Design

In ordinea in care le-am creat: 1. 2. 3. 4. 5. 6. 7. 8. Acestea sunt unele dintre creatiile mele.

hall of stupid questions.

where do i find zarevok's sword? do you get battle points from raids? anyone else feel free to ask questions. and thank you before hand to those that answer our questions.

[Only Topic] Questions about Reviews

Hello members! If you have questions related to reviews/reviewing, feel free to post it here! We'll try to answer as fast as possible Also, the old thread of 'Questions about Reviews' is located here, so you can also find answers there. Thanks