INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

How to use "IF" SQL Statements to build custom reports in the Connector module

Entry Type: Informational

Product: Sage MAS Intelligence

Application: SMI Connector 

Version Reported: 7.40 

Subject:

How to use "IF" SQL Statements to build custom reports in the Connector module.

Possible Resolution:

Sage MAS Intelligence supports the following:

• Supports MS Excel IF statements so they can be set up as an expression in the container (need to use named ranges etc)

• Supports standard SQL statements (CASE WHEN THEN ELSE END)

• If you want to use an "IF" statement in a Container Expression, the Expression's type must be an Excel Formula and not a SQL Expression and Excel Syntax is required.
  

Related Articles:

How to access resources and help for designing Sage MAS Intelligence reports