Drill down returns no results in Analysis

Question

Hi There,

I'm using Oracle Business Intelligence 12.2.1.0.0 and I'm having issues with results not showing when I drill down.

For the home page of my dashboard, you can select the manager you want to view and this will show their performance. When you select your manager, this creates a variable with that manager's name.

I've set up an action link so that when you click on the manager, you can drill down and see the people who work to that manager. On this page there's another variable which has a default value of the manager variable from the home page.

When I drill down, the variable prompt is populated correctly. However, no results show. The table builds as if the results are there but they're just blank/null.

When I go to the drill down page manually and type in the manager name, the results show. The table layout is the exact same as when I drill down, except this time I have results.

Does anyone have any idea why this would happen? And how do I fix my drill down to show me the results without having to manually navigate to the page?

Thanks,

Adam

Robert Angel · Answer

Know the feeling - glad you got there!

Adam_K · Answer

OK, looking back at the screenshots I sent you, I've noticed that when drilling down, the 'Target' measure was being excluded. This is what drives the 2nd analysis. I've protected my filter so that all of the 'Types' are included and I'm now getting results. Thanks for your help, I really appreciate it! @Robert Angel

Adam_K · Answer

Hi Robert,

Sure. Hopefully this will help you:

The home page looks like this:

When you click on the Agent ID, you can drill to the managers view via the Action Link. The Action Link properties are:

When you use the Action Link to drill to the manager's view, the AGENT_ID variable from the home page is used to set the Manager ID as per below:

This MANAGER_ID variable is used to determine the results of the analysis and returns the below (notice the 2nd analysis has no results):

Now when I go to the page manually, the default Manager ID value is used and it returns this:

After I enter the same Manager ID used above, I get the below (notice the 2nd analysis now has results):

If you need any more info, please let me know.

Thanks,

Adam