Action links on a hierarchy level passes through the value correctly but on clicking apply on the de

EmmanuelMash

Hi Legends

I have a summary analysis with a level based hierarchy. On the lowest level shown below, i setup an action link. This level is passing through a store number for example if one is to click this level, it passes through the selected store to the detail report prompt which has a presentation variable to store the passed value, lets call it pv_store. In the detail analysis I also filtered by the same variable as shown below:

figure 1

Figure 2

Figure 3

On clicking the above the action link passes the 367 to the next analysis correctly but does not find any results and this is not because there are no results but because the displayed text is not what is being sent in the query.

Figure 4

When you click apply this is what you get:

Figure 5

Any Idea how I can pass this value without generating that xml. I think if I can pass the correct value without the xml then it will filter correctly. From the list of values, if i search for 367 and click apply I find the correct data. Also if I use the levels on their own as columns then everything works correctly. The only problem is when I use the hierarchy.

OBIEE VERSION: 11.1.1.7.150120 (Build 150111.1659 64-bit)

Data Source : Oracle  DB

Regards
Emmanuel

Martin van Donselaar

I'm not sure If I understand the problem correctly but if you want to pass the value to another analysis through an action link then you should have a 'store is prompted' condition in the receiving analysis.

That will filter the analysis on the value that you click on in the analysis that has the action link.

EmmanuelMash

The passing through is working correctly. But the xml that gets generated is the problem as its making the report not return any data

Martin van Donselaar

Can you explain why you need to use a presentation variable in stead of an 'Is Prompted' condition?

Have you tried to use the 'Is prompted' condition?

Did you get the same result?