Same attribute in multiple dimensions or Create new dimension?

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

Conformed Dimension Processing Multiple Data Marts

Rookie question. We have 8 conformed dimensions and we are on our 4th data mart using some of these 8 conformed dimensions. We build the conformed dimensions once every night because the client wants to complete full refresh only. The client has

What to do when a single attribute rolls up to multiple categories?

I'm working with healthcare claims data, and developing a new data warehouse. A single pharmacy claim line will have a drug identifier called a NDC (national drug code). A single NDC may belong to one or more drug categories. Given the one-to-many

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

Hierarchy within single dimension or two dimensions

I am unsure of the best way to model a specific business scenario and was looking for some input. I will explain it in terms of a common example, the Product dimension. Let's say that every "product" is assigned to a specific

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

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

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

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

Multiple Polls

Hey guys, I think that we should be able to post multiple polls in one thread. I think that this would help and it would be very usefull for the suggestions to my forum. I would have people send me all of their suggestions and everymonth I could

NEW CONTEST : Create a video for Forumotion and Twilight !

NEW CONTEST : Create a video for Forumotion and Twilight ! Forumotion New Contest for Twilight Eclipse Like every major event, Forumotion has a pleasure to organize a new competition to highlight your creative talents! 1- Competition rules:

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