Home Discussions Questions & Answers API Parameter for Dynamic View Expansion

API Parameter for Dynamic View Expansion

Avatar photoCustomer October 12, 2020 at 3:22 pm

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support October 14, 2020 at 7:34 am  

      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’.

    • Avatar photoCustomer October 14, 2020 at 1:35 pm  

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

    • Support October 16, 2020 at 3:49 pm  

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: