Page 1 of 1

Filter Vs. Case Statements

Posted: Tue Mar 09, 2010 8:39 am
by jim wood
Guys,

For those other lucky people developing an RPD you need to bare in mind that the filter function (Example below) generates more efficient SQL than a case statement.

Example:

FILTER(CMI_Finance."Fact - Actual Base Measures".ACHIEVED_MARGIN USING CMI_Finance."Dim - CMI FPC".FPC_DESC = 'Full Price')

Jim.