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.
Filter Vs. Case Statements
- jim wood
- Site Admin
- Posts: 3650
- 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
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2