AnsweredAssumed Answered

How to run a portlet on top of a materialized view

Question asked by RK_L on Jul 10, 2014
Latest reply on Jul 11, 2014 by navzjoshi00

Hello, my portlet query is very complex with lots of INNER and OUTER JOINS and its pulling a lot of data which takes up forever to run.

I would like to run my portlet on top of a materialized view to fasten the processing time.

Since I never did this before, I am looking for some guidance from senior members.

Here are some of the @SELECT statements. How would I access these thru a view and how complex is this process?

 

SELECT

@SELECT:DIM:USER_DEF:IMPLIED:PROJECT:Project_CODE:Project_CODE@

,@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:Project_ID_Browser:Project_ID_Browser@

,@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:Resource_Filter: Resource_Filter@

 

If you could provide an example, it would be great.

Outcomes