Filter Vs. Case Statements
Posted: Tue Mar 09, 2010 8:39 am
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.
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.