Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Drill down returns no results in Analysis

Received Response
11
Views
5
Comments
Adam_K
Adam_K Rank 3 - Community Apprentice
edited Aug 13, 2024 7:24PM in Oracle Analytics Cloud and Server

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

Answers

  • Adam_K
    Adam_K Rank 3 - Community Apprentice

    When results are returned, the URL looks like:

    "analytics/saw.dll?Dashboard&PortalPath=..."

    When no results are returned, the PortalPath of the URL is cut off and the URL looks like:

    "analytics/saw.dll?Dashboard"

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Could you show some screenshots of the key elements of the solution please so we can see exactly what you currently have?

    Key elements :- placing of the action link, configuration of the action link.

    You can / should hide any detail that is sensitive for general consumption.

  • Adam_K
    Adam_K Rank 3 - Community Apprentice

    Hi Robert,

    Sure. Hopefully this will help you:

    The home page looks like this:

    Home Page.PNG

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

    Action Link Properties.PNG

    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:

    Manager Prompt.PNG

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

    Drill Down - No Results.PNG

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

    Drill Down - Results_V1.PNG

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

    Drill Down - Results_V2.PNG

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

    Thanks,

    Adam

  • Adam_K
    Adam_K Rank 3 - Community Apprentice

    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

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Know the feeling - glad you got there!