Combining Facts

Combining Factless Facts and Bridges - sensible or not?

We are working in a MS SQL Server 2005 environment using SSIS to populate our DW DB and SSAS to build our OLAP database from that DW DB. It is not a huge database in the scheme of things - 28 million payments, 6 million customers, 2 million membership

Multiple facts in a fact table

One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact. This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity. There is a column type dimension that then tells us

Textual Facts in the fact table

Its a new financial 'capital markets' dimensional reporting model (for IPO - raise money for an issuer by issuing new equity common stock securities) that's in design stage. There are some textual attributes of the grain of several fact tables for which

Facts with different grain from different sources but related

Hi, I have a situation which I am trying to resolve but not able to Technologies Using : SQL Server and Analytics Services (SSAS) Background I have a flat file which is from the enterprise peoplesoft system and has the followings GL Account,

Multiple one to many facts

Trying to figure out how to model this with multiple one to many facts. I'm new to modeling so bear with me if this is simple. I think a picture speaks a thousand words so here is this: There's a few dimensions as well but those are easy

Have You Scrutinized The Facts About Juicing, Healthy Diet, Juicing For Better Health

By David Wellsford We are all very aware today the benefits of good nutrition, and the vitamins, and minerals that are necessary for our health. What do we know about juicing, healthy diet, juicing for better health? What does juicing mean? Making

16 Amazing Science Facts

1. Fingernails grow four times faster than toenails 2. Right handed people live, on average, nine years longer than left-handed people 3. If you rub an onion on your foot within 30 60 minutes you will be able to taste it this is because it

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

Primary Key of Dimension and Fact Tables

I've seen several people give presentations which purport to represent the Kimball Method and I've seen this done two ways. What is the current position on what should be the primary key of a dimension table? I was under the impression that we

your interesting facts

so basically you put interesting facts about yourself such as something really good or really bad you have done,something really good or really bad that has happened to you, or just something you want to share about yourself.you can also put any

10 Random Unknown Facts

Lets all get to know each other a little better! Write ten facts about yourself that others probably don't know, and lets get to know the person BEHIND the YouTube name! 1. Im very insecure about myself in real life. Whenever I appear confident it is