many to many relationship between dimension level

Dimension Hierarchy - Facts by various levels

Hello, I am working on a new project (with Oracle OBIEE) where most data needs to be seen by a terminal(game or cahsier). The terminals are located in different venues in various cities and states. Some terminals may just be at a city or a state level

How to design a one to many relationship

I have a student quarterly registration fact table. Every student has academic programs (majors) associated with him/her and each student can have up to 5 of them. And each major can start and end at different times and has multiple parameters including

Facts at different levels of hierarchy

Let's say I have an empoyee dimension consisting of the usual attributes describing a person, but also these two: Department and Company. Let's also say I have budget numbers for the three levels (Employee, Department, and Company). I would think tha

Need to join dimension tables

Hi, I have a requirement to build canned reports in WEBI XI R3. The requirements are such that most of the reports are on the dimension tables and needs dimension tables to be joined. From a starschema prospective we cannot join dimension tables. My

Many to many relationship question

Hi all. I know the common standard practice for many to many relationships is to use a bridge table, and I've done that already in my model. But I've come across a situation where I'm thinking of using a group table related directly with the fact. Let'

Extinction Level Event - 3/11/11 Elites First Group Ark

Well this is enough to give me the permanent shakes starting this morning. http://www.youtube.com/watch?v=kWhFv22nB_k&feature=more_related

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

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

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

Editboard's responsabilities on the Juridical level

In are a general way, which the responsibilities for Editboard on the legal level? The responsibility of the hosters remains limited today. Nevertheless, certain rules exist and it is advisable to conform to it... First of all, it must be noted tha

Bridge Table and Customer Hierarchy

Does anyone know of a good detailed reference that discusses populating and maintaining customer hierarchy type bridge tables? The only decent resource I've found is the "The Data Warehouse ETL Tool Kit", but it only briefly shows an example on

An evening with Guy Garvey!

A separate event from the Elbow and Halle event - an evening with Guy Garvey. Monday 6th July. http://www.quaytickets.com/WhatsOn/mif/EventDetail.aspx?EventId=2911 Tickets £3 each

Migraines and thyroid

An interesting article on the role of an even slightly underperforming thyroid on migraines. http://headaches.about.com/od/comorbidconditions/a/thyroid_comorb.htm Has anyone here had a doctor investigate their thyroid? I've never had anyone bring