0

How to pass run time parameters to MV

OBI Direct DB SQL is being converted to Incorta. it has subqueries and Presentation variable(s) referred in each subquery. Oracle OBI sql generates the data based on the variables passed. In Incorta, need MV because it uses nonoptimized tables but how to call the variable(runtime parameter) in MV to generate the required data set?  Any pointers would be appreciated. Thanks Anurag Malik Amit Kothari

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Incorta Materialized View is executed as part of the data refresh.   When you convert a OBI report to Incorta, the SQL that has the runtime presentation variable will need to analyzed and push to the data model design. 

    Incorta supports the presentation variable, which can be passed to the dashboard by using it in these locations:

    - Dashboard Applied Filter

    - Insight Filter

    - Measure Filter

    - Default Value to a Prompt

    - A formula defined in the insight

    - Dashboard Title

    - Column Heading

    In some case, the presentation variable maybe used in a business schema formula when they are having the same name.

    With this in mind, the column that are used in the OBI presentation variable will have to be accessible in the model and the grain of the data may have to address the requirement.

    Like
Like Follow
  • 3 wk agoLast active
  • 1Replies
  • 30Views
  • 3 Following

Product Announcement

Incorta 5 is now Generally Available