Hi list

I have a dimLabTest, dimPatient, dimDoctor and dimTime that relate to factLabResult and factImprovementPayment. the facts are all key except for for their measures ImprovementLevel, ImprovementDate and ImprovementPaymentAmount, and LabResult. The keys are compound for Doctor and Patient. labtest (just its name) is a one column key, Date is a one column key from a server time dimension. Other measures in factImprovmentPayment are improvement factor (1-4), improvment payment (in $),  representing incentives paid to the doctor based on decreases in blood pressure, decreases in lipids etc and this part of the model works fine.

My problem is with factLabResult because i cannot get to see the labresultvalue in the cube...its there in the dimension, and i can see it in ExploreData in the DSV, but it is only expressesd as 'CountOfLabResult', but i cannot see the name or value of the lab results. If i create new dimension from column, labresult appears in the measure group in cube designer but only as CountOfLabResults (no values), but if i try to set aggregation to none, i get an error that semi additive measures are not allowed in standard edition. At the end of the day, i want to be able to examine the corrleation between the improvement of patients with their lab result values. So i have the four dimensions and two facts.

Any idea why i cannot surface labresults?

thanks very much for your help, and thanks extra for the great videos

drew

"There in the dimension" was my fingers working faster than my brain....i should have said it is there in the fact....the schema is this

subno              char 7
persno             char 2
pcpid               char 12
panelid           char 5

measureName  varchar 50
measureResult varchar 20
measureDate   varchar 25
once i took a step back (thanks for asking the right question)  the reason measureResult doesnt work became blindingly clear , so i did this to check my answer... 

select

max(measureresult), measurename from factdiabetesmeasures group by measurename

98                SystolicBPCurPd
99                DiastolicBPPriorPd
Consult      NephroScreenPriorPd
92               AICScreenPriorPd
99               DiastolicBPCurPd
Trig-High   LDLCurPd
92.00         A1CCurrentPd
Microalb    NephroCurPd
98               SystolicBPPriorPd
Trig-High   LDLPriorPd

and realized that you can't do much in the way of varchar measures with result values like Consult, Trig-High and Microalbumin mixed up with 92s and 98s even if (or should i say especially if) they are varchars!  I will clean up the data tomorrow and ask the clinicians if i can drop the rows out with Consult, Trig-High and Microalbumin instead of numbers and convert the measure column to long or decimal and try it again. Thanks so much for the second pair of eyes....i feel like an idiot, but im just learning to dance

btw, if my epiphany is NOT the answer, please correct my error! thanks again

drew

thanks a ton Craig...works like a clock now!

i am enhancing the cube working with the clinicians to establish the descrtizations you mentioned.