Multiple Many-To-Many relationships

Advice on relationships between Type 2 SCDs ?

Hi All, I am constructing a new warehouse schema containing a number of dimensions which need to be modeled as type 2 SCDs. This is all fine and I have surrogate IDs which are being used as the FK in the facts. The challenge I have is that a number of

Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables

Its a new capital markets data warehouse in design stage. I have deal_deatils_fact - 1 row per deal with all measures at deal level - dealID (Degenerative DIemsnion - DD) deal_tranche_fact - 1 row per deal per tranche with all measures at the

Dimensional Modelling when the core concept has Many to Many relationships (or am I trying to fit a square peg into a round hole)

I am currently building a product to help do analysis of content management systems. The product is feeling very much like a DataWarehouse/datamart system, and I'm trying to apply dimensional modelling techniques to the model. After reading the first fe

Trivial ques-Resolving a Many-to-Many (m:n) Relationship..why reqd

Hi, This is a very basic cinfusion which I am having. I have a scenario where the 2 entities are having many to many relationship,I see that it is must to resolve these relationships. Example : A Fax number directory Entity 1: Person

Multiple fiscal calendars

We are an aggregator. We sell and ship our own products and act as distributors for a number of other entities. We would like to give our distributees access to our internal BI reports dealing with invoicing and shipping. They each have the potential to

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

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 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

Multiple Memberships IP Warning system.

Most sites have a ip scanner system on them that will flag up the members that have the same ip address and tell the admin's the ip and the names of the users. Right now the only way to see the ip and the ones that have more then one account is when th

Linking or Merging Similar dimensions from Different Source Systems

We've got a situation with the DW we're building where we have 2 seperate systems that we are wanting to bring the data together for cross analysis 1) The first system is the main operational system ie a contact management application that records

Multiple Choice Profile Section Creation has no "Add new"

Create a profile field with multiple choice and you may find there is no "add new" or "delete" option. I want to create: Mage Warrior Thief But can only create: Mage This needs fixing.