Measures as special dimension table

Time Dimension vs Measures in Minutes

Hi All, I would like to design the time in a multidimensional model. The classic calendar date dimension (day, week, month, year) should be applied here. Besides that, I have a fine grain: the minute. More specifically, let's suppose I have 10.000

fact table as a dimension? Is that bad?

I'm working on my first business process in a dimensional model for a call center. The process we've selected is Quality Assurance; the grain of the fact table is one record for each Quality Category. Another fact we'll be creating is a contact point fact

Guidelines for FACT Table Design for High-Transaction Volume and High # of Measures ...

Hi All - This inquiry could actually be two questions, but the requirement is really presentation of row-wise high volume transactional data in a column-wise (columnar) FACT table. Here is a sample transactional data set: Interval Date TimeUni

Measures as Dimensions: Banding Approach Help

I have a standard fact table with a number measures; several of which are in the form of time (e.g., minutes) and others in the form of integers. The fact table and related dimensions are exposed to users via BusinessObjects XI v2 Web Intelligence. One of

Dimension with multivalue attributes

I can't seem to wrap my brain around this one, need some help. Data model is simplified for the example given here: fact: Interview dimension: applicant The grain is obviously interviews, however the users want to be able to report interview

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

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

Special for SLT

SLT PEO TV introduces SVOD with HBO Subscription Video on Demand (SVOD) is a novel feature introduced on SLT PEO TV platform. SVOD service was launched in December 2010 and now is available for SLT PEO TV subscribers offering Blockbuster English movies

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

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

100 reasons why Madeleine was not abducted

http://blogs.news.sky.com/discussions/show.html?plckForumPage=ForumDiscussion&plckDiscussionId=Cat:746f9309-1bb1-4b07-ad11-647f5ba16800Forum:4237bf3e-0948-444d-a452-46289a2fd1f7Discussion:53085ce6-d0e9-4517-9607-a2eb2b4b9b84 class=Discussion_PostTi

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

Volume and Weight in Same Fact Table

Is it appropriate to include two facts that are not of the same type? In my example, I may need to have both Volume (Gallons) and Weight (Pounds) in the same fact table. I am building a DW around products that we recycle, these products can be Oil or