Home › Discussions › Questions & Answers › API for Discoverer Folder Consolidation

API for Discoverer Folder Consolidation

Avatar photoCustomer Questions & Answers 5 replies

We prefer importing Discoverer based on folder combinations rather than individual worksheets for consolidation. Is there an API for this folder import type?

5 replies

  • Support Enginatics

    Yes, you use the PLSQL procedure **`xxen_api.import_discoverer_folders`**. This option consolidates different workbooks that access the same folders into single Blitz Reports.

  • Avatar photoCustomer

    When importing folders, how do I control whether underlying database view SQLs are imported as subqueries or just referenced?

  • Support Enginatics

    You control this using the `p_expand_custom_view_sqls` parameter. Options include ‘All’ (for full expansion), ‘Custom’ (for views starting with XX% or custom application short names), or ‘none’.

  • Avatar photoCustomer

    What is the benefit of expanding views into subqueries?

  • Support Enginatics

    Expansion simplifies maintenance, as the SQL can be modified directly in the Blitz Report form instead of requiring database view recompilation.

  • You must be logged in to reply to this post.