Overlapping facts

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,

Facts or Dimension Attributes?

My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th

Conformance of Dimension for facts aggregated at different levels

I am a newbie to Data Modeling. I am modeling a warehouse for Global reporting solution for a business operating in 3 countries. 2 business processes involved are "Sales" and "shipment Expenses" The input is sumarized excel files

Overlapping Dates in a dimension

Hi, I am wondering if someone could advise me on how to deal with this design problem. I have a promotion dimension keyed to a sales fact table. Initially, we thought that only one promotion could be active at one time for a sale, but it is actually th

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

DBC: Saurophaganax VS Yanchuanosaurus

Well guys, I was looking around my extinct creaturs lab and while taking a walk through my private prehistoric Zoo i saw two pretty strong looking dinos, one was my all mighty Female Saurophaganax while the other was my fierce Yanchuanosaurus, i cant help

KPI Goals and Percentages as Dimensions or Store as Facts?

We are using PPS Monitoring for our Dashboards and we are creating our KPIs within PPS and SSAS. Our client would like to create a dimension with these KPI goals and percentages for each goal per department and measures or add to the fact table. Now

Eating in the shower

Does anyone else like to eat food while you're in the shower? I do this every now and again. It's usualy something simple like pizza pockets and other microwave snacks. I think I tried it with a sandwich once. It's a bit silly and a tad tricky but with a