Multivalued Dimension or Multiple facts w/conformed dimensions

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

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

Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table

I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to

Data Marts, Conformed dimensions and Data Warehouse

Hello, Can you please assist me in understanding the following. I am new to data warehouse. I'm using microsoft products to build my enterprise DW/BI 1. Do I build data marts for my enterprise DW/BI or do I iteratively build a data warehouse? I

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

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

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

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

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

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

Multiple Theme/Skin Selection 4 Members

There are some forums that allow you to use more then one template, the user can choose which look they want, we should do that with our sites!

Multiple clickable portions on a Image.

Multiple clickable portions on a Image. Using HTML make Mutliple portions on a image clickable Hello Everyone This is a very simple tutorial to make multiple clickable areas on your image. Enter this code into your HTML Page. Code:<img