Filter Vs. Case Statements

Post Reply
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Filter Vs. Case Statements

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply