Multi-Source Report Pre and Post Statements

Report Pre and Post SQL statements can be applied and executed against multiple databases used as a data source for reports. This includes both in-memory and connect live Intelligent Cubes. The Pre and Post SQL statements do not have to be placed in a particular order in the overall query as they operate independently from one another.

The example below shows an instance of how pre and post statements at both the report level and database instance level are applied and executed against multiple sources.

For examples of the syntax required for these statements, see the Report Pre Statement and Report Post Statement sections.