Does the Active Warehouse project support the notion of "Helper Tables"? In other words, many-to-many relationships between important dimensions.
http://www.dbmsmag.com/9808d05.html http://www.intelligententerprise.com/010810/412warehouse1_1.jhtml For my particular example. - I have a table of patients. - I have a table of visits for those patients, each visit having a primary diagnosis. - I have another table of patient diagnoses keyed off the visits table in which those patients have between 1 (the primary diagnosis in the table of visit is duplicated here) to as many as 30 diagnoses ascribed to them. Each diagnosis is an additional row in this table. So, that is: Patients >-- Visits >-- Diagnoses I want to ask the question: "how many patients came in for a visit who were diagnosed with A as primary symptom and also had B diagnosed at the time of visitation?" Helper tables seems to be the way to go, but I'm not sure how to do the weighted_value column nor how to leverage the Active Warehouse components for this. Any suggestions on how to proceed to model such that I'm not counting the same patient twice regardless of number of visits or number of diagnoses recorded for a visit? Regards, Michael _______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
