Home › Discussions › Questions & Answers › API Parameter for Dynamic View Expansion

API Parameter for Dynamic View Expansion

Avatar photoCustomer Questions & Answers 3 replies

When importing Discoverer folders or Polaris RWB reports, we prefer to embed the underlying database view SQL directly into the Blitz Report definition. Which API parameter controls this feature?

3 replies

  • Support Enginatics

    For Discoverer folder import, the parameter is `p_expand_custom_view_sqls`. For Polaris RWB, it is `p_expand_view_sqls`. Both accept options like ‘All’, ‘Custom’, or ‘none’.

  • What is the benefit of expanding views into subqueries, and what does the ‘Custom’ option entail?

  • Support Enginatics

    Expansion simplifies maintenance, as the SQL can be modified directly in Blitz Report without requiring database view recompilation. ‘Custom’ means that only the SQLs of views starting with ‘XX%’ or those matching custom application short names (like ADS_%) are expanded during the import.

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