Re: Query Optimization

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Audrey Ng (odd26uk_at_yahoo.co.uk)
Date: 04/01/04 

Date: Thu, 01 Apr 2004 08:13:37 -0800

Hi Deepak,

Here's an entry you have once suggested earlier on...is that the same
thing what you have just suggested?

From: Deepak Puri
Date Posted: 11/26/2002 11:29:00 PM

Can't you make this a base rather than a calculated measure
(in which case, aggregation would speed up retrieval of that measure)?
If there are fact table columns, C1 and C2, corresponding to [DAD
Measures].[Raw Conservable Days] and [DAD Measures].[ALC LOS], then the
measure column could be defined in SQL as: case when C1>C2 then C1-C2
else 0 end. The sum aggregation type would apply to this measure...

If so, can you please provide me a step-by-step instructions as I have
no idea what is being asked =(
My knowledge in this kind of stuff is so limited...

Thanks,

Audrey

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!