Combining Factless Facts and Bridges - sensible or not?

Combining Facts

We have 2 entities in our logical model for authorizations. One for inpatient authorizations and another for service authorizations. They are both children of the parent authorization entity. We are considering combining them into a single

Factless Sales table

Hi, I was wondering if there is anything wrong with having a factless sales table? Basically all I am required to do is to count up the total number of sales that occurred each month grouped by product type. So basically all I have in my fact table

Looking for advise on loading keys into factless fact tables

Please consider the following options and recommend an approach. Thanks in advance. Option 1 PERSON_KEY DEGREE_KEY LANGUAGES_SPOKEN_KEY ROLE_TITLE_KEY P1 D1 L1 R1 P1 D2 L2 R2 P1 D1 L3 R3 P1 D2 L3 R4 Option

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from

Advice on factless table use

I have a situation where i have modeled a process relating to invoicing such that there is a fact table of invoice line items and some dimensions such as date and recipient of the item to name a couple. The situation i am encountering however i

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

Interesting science facts - 50 amazing science facts

1. Word "Science" derives from Latin word scientia meaning knowledge. 2. Human need approximately 12 hours in order to entirely digest the food. 3. Brain cells are the longest living cells in our body, they can last for an entire lifetime. 4. Som

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

Multi valued dimension attributes, weighting factor and cognos

Hi, we have several attributes in our product and customer dimension which might by multi valued. We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein. Can anybody reference a best practice

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

Random Facts October

They grow up so fast! RF: The staff is organising a birthday party for the forum, but don't tell anyone!

Conformed Dimension Processing Multiple Data Marts

Rookie question. We have 8 conformed dimensions and we are on our 4th data mart using some of these 8 conformed dimensions. We build the conformed dimensions once every night because the client wants to complete full refresh only. The client has

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