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