Impromptu

Cognos Impromptu was IBM's client-based business intelligence tool: it empowered business users to execute ad-hoc querying and create complex, frame-based reports without writing SQL.

Impromptu, originally from Cognos and later integrated into the IBM Series 7 suite, was a powerful client-based BI tool: it enabled business users to perform dynamic data access and create complex reports (grouped lists, crosstabs, charts) using an Information Catalog layer. This object-oriented architecture abstracted database complexity, allowing non-technical users to build reports with features like prompts and filters. Note: Impromptu is a legacy product; IBM officially withdrew support for version 7.5 on April 30, 2023, and the recommended successor is IBM Cognos Analytics.

https://www.ibm.com/support/pages/cognos-impromptu-74-product-documentation