Fact table with non-numeric measure

Textual fact or Junk dimension?

Hello, I have been following the forum for a while now and I must say that many doubts about dimensional modeling have gone thank to you all. However I am facing now the modeling of a cube and I am somewhat stuck on what is the best

Aggregated Measure

Gurus, I have relational database where there is only one measure that is at an aggregated level whereas Dimensions are at lower level of granularity. Let me give you an

Fact table design - Showing something that did not occur

Hi everyone, I got a question about how to handle a situation with a user need. I have created a fact table factClassesStudentAttended. Those classes are for paramedic. The user wanted to know wich student took what classes and what was the

Indexing option on numeric fact referred to in DW Toolkit 2nd edition

In the 2nd edition of THE DATA WAREHOUSE TOOLKIT, Chapter 9, page 208 at the end of the first paragraph, there is a reference to an indexing option on a numeric fact pioneered by SYBASE IQ product which has become a standard indexing option in competing

Derived Fact table with additional measures / foreign keys ... ?

Hi, Let's say we have a fact table: FactReceipt which contains all our receipting transactions that occur during the month, we may have 5 receipts of different types during one month for one contract. Now let's say we build another fact table that

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

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, 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

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Questionnaire for medical record entries

Good afternoon, I am currently working on a data warehouse in the health care sector and I currently facing this problem: The aim of this warehouse is to have an overview of a cancer therapy. So, I have created the following fact table

Table View disscusion

I couldn't find if this was being discussed elsewhere but i thought i would start a thread to discuss the things we would like to see in the table view. I know it's still a work in progress but i thought i would put up a few requests that Billy may or may

Bridge table for patient diagnosis

Hi ngalemmo or fourm members, Can I get advice on how to create a bridge table for patient diagnosis? To keep it simple, I have a patient, facilities, and doctor dimensions and one fact table. For a specific patient, I need to show all diagnosis in a

How Do I make an Announcement Like Forumotion Does?

http://help.forumotion.com/updates-and-new-features-f1/tuesday-tip-display-your-categories-as-tabs-t66614.htm How Do I make a Page Like that, written with 'Announcement' and all and use it for my forum? I have seen even Webartz doing the same