Home › Discussions › Questions & Answers › API for Polaris Reporting Workbench Import

5 replies

  • Support Enginatics

    You should use the procedure **`xxen_api.import_reporting_workbench`**.

  • Avatar photoCustomer

    This process also involves view expansion. Which parameter controls whether views are expanded into the imported SQL?

  • Support Enginatics

    The parameter is `p_expand_view_sqls`. It accepts values like ‘none’, ‘all’, or ‘custom’. ‘Custom’ means only views starting with XX% or custom application short names will be expanded.

  • Avatar photoCustomer

    Are there any views that are always expanded regardless of the setting?

  • Support Enginatics

    Yes, any view which references Polaris RWB objects starting with XXRX%, such as views using `xxrx_util_pkg.get_parameter_char_value()`, will be expanded regardless of the `p_expand_view_sqls` setting.

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