An IAL needs to be far larger than the 4000-character SQL statement limit the client UI enforces (a genuinely complex Business Reporter source needs closer to 32,000 characters) — is there a way around this limit, short of splitting the IAL into many smaller ones and joining them back together?

All FAQ questions / Reporting and analytics

Answer

The 4000-character limit is only enforced by the client UI, not by the actual database/deployment layer — you can edit the IAL's underlying file directly (outside the client) with the full, larger SQL statement (up to roughly 32,000 characters) and deploy it that way, bypassing the UI's input-length restriction. This is a workaround for the UI's own limitation rather than a real platform ceiling on IAL statement size.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Reporting and analytics questions