Action link not working in Direct database request(OBIEE 11g)

Question

My Requirement is

From direct db request .. i  need to navigate to detail report and it should be display the results(detail report results) based on the value,which user click's on the summary report.

Summary report(geneareted from Direct database request) columns:

year,week,state,total sales,

i)i had provided action link on state column

Detailed report (is genearted from the analysis) columns are

year,week,state,city,total sales

when i am clicking on particular state in the summary report  it is navigating to summary report  but it's not filtered based upon state value provided in the  detailed report and

it is showing the all the data in the summary report.

Is action link works on direct database request or not?

If any one having any ideas pls share me ..

Thanks in advance.

Robert Angel · Answer

Hi,

if two reports share the same subject area and the target report is filtered 'IsPrompted' then it should catch the prompt from the source.

if the situation is not as straight forward then you may have to find a way to bind the variable(s) (using presentation variables typically) and place an associated filter on your target, referencing it using the syntax {MyVariableNameHere}{DefaultValueHere} - this can get more complex if you need to pass numerous values.

Hope this helps,

Robert.

Gianni Ceresa · Answer

The action link works ! You said it yourself ...

7f401ba3-8aa5-4c11-a8a6-5dff16af5aef wrote:...when i am clicking on particular state in the summary report it is navigating to summary report ...

One question for you: how do you think OBIEE is supposed to know that "State" coming from a Direct Database Request is the same as "State" coming from a subject area?

It's the job of the RPD to provides the metadata required to know that a column is the same in 2 different analysis and so an action link can send the values from one to another.

Writing a Direct Database Request you bypass the RPD, so you can't expect to get any RPD metadata related to the columns of your result.