Filter Vs. Case Statements

Post Reply
User avatar
jim wood
Site Admin
Posts: 3501
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Filter Vs. Case Statements

Post by jim wood » 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

Post Reply