2 facts or 1 fact - Revenue and time billed

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

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

SCD Type 2 dimension and fact table being the same table

I am designing a dimensional model for employee data in a data warehouse. Right now I only register the basic information about the employee, like job title, department, language, FTE, etc. I have chosen to use an SCD Type 2 dimension since I want to keep

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

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

Iraq: Oil and Gas Legislation, Revenue Sharing, and U.S. Policy (PDF)

http://docs.google.com/viewer?a=v&q=cache:7u4JXPk1SQMJ:ftp.fas.org/sgp/crs/mideast/RL34064.pdf+iraq+hydrocarbon+law+march+2+2010&hl=en&gl=us&pid=bl&srcid=ADGEESgqqFk7BGxcdU8PuNeB1-D_gBiJagyvksRAXruzmBBDL8sBbG-J3bWu73KFAG_JK02XKXz4LT-nQ

Google AdSense Revenue Sharing

how can i create additional field to my forum database which contain user's google_ad_client. and how can i use it in the viewtopic_body template? Code: <script type="text/javascript"><!-- google_ad_client =

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

Real time datawarehouse replacing operational reporting

Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW and

[WALLPAPERS CONTEST] Time to vote for the best one!

Dear users! First of all thanks to all participants! We had 150 wallpapers submitted, which is by far our must successful contest! It's now time to vote for the best wallpapers. Only 5 will win! Ready? All you have to do is to pick your favorite

Funny comedy joke time!

We all could use a laugh now and again, so here's where to find one when you need one. If you have something funny from your fave comic that you want to share, post it here. I'll get the ball rolling with one of my favorites, the late great Bill

What's the current time in your country?

well this is simple Just tell us what's the current time on your country everytime you log or so on It's 9:15 pm here.