multiple hierarchy : single dimension vs multiple

Using a dimension in multiple fact tables with different grain and support SCD

Hello users, i've a question about using a dimension in fact tables with different granularity and at the same time retain support for SCD. My scenario: I have one Dimension called Apartment. This Dimension cosists of the following related

Dimension with two hierarchies

I need to design a dimension with two hierarchies 1. Location -> Building -> Room -> Cabin 2. Location ->Building I need the hierarchy 1 to be referenced in one FACT table and hierarchy 2 in other FACT. But my ETL tool allows only the dimension ke

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

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

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

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

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

How to manage multiple languages

Hi there! I have been using Media Companion quite successfully to manage my movie collection. However, I am having some problems managing non-english movies. I have several Italian language movies (in a separate directory from the English movies). In

Multiple layouts

On some other forum hosts there are things where you can choose multiple themes and have a theme switcher at the bottom of the page. I think that we should have that and have a html page layout. such as whenever you create a new html page, you will have

Multiple Smilie Codes

Because different people use different kinds, this suggestion is that single smilies can have several codes. For example: Our friend has several forms. There are Code::) :-) (: (-: And so on and so forth. So, instead

SINGLE PARENT (NASA MALAYO,INIWANAN,LUMISAN ANG PARTNER)

To all single parents out there,this one is for us. My wife is working abroad. Ako nanay/tatay ng 2 kids namin. Mahirap lalo na pag may karamdaman mga bata. Tiis -tiis lang lalo na pag tag-li**g.Avail sa mga contacts sa mtc or od.Hehehehee!

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

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!