Oracle Analytics Cloud and Server

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

OBI Dashboard analysis hangs

Received Response
13
Views
6
Comments
3713479
3713479 Rank 4 - Community Specialist

The analysis includes the filter below and produces expected results when launched outside the dashboard.

When launched within a Dashboard page, the analysis hangs.

I have also tried using date ranges that are not defined in the database with the same results.

The DBA is not available to assist with activity logs so I wanted to submit this question for any insights from the user community.

Thank you.

Activity Date is between  @{PV-START-DATE }{01/01/2018} and @{PV-END-DATE}{03/31/2018}

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    3713479 wrote:When launched within a Dashboard page, the analysis hangs.

    Have you checked what the prompts on that page pass to the variable?!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @3713479 did you give up on this?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Does that "helpful" mean the question is answered? Or still an issue?!

  • 3713479
    3713479 Rank 4 - Community Specialist

    I am still troubleshooting this issue.

    The logs provided by the DBA indicate that the request is not being forwarded to the server.

    I infer this due to the absence of entries generated by the OracleBIServerComponentt that show diagnostic messages with timestamps that are normally generated based on earlier logs I have reviewed.

    The only entry in the log is the compilation of the filtering logic into SQL query format.

  • 3713479
    3713479 Rank 4 - Community Specialist

    I created a new dashboard and added the same analysis that was triggering a 'hang' condition in the other dashboard.

    The analysis launched successfully in the new dashboard.

    I am not sure what triggered the 'hang' condition in the other dashboard, but one factor may have been that the presentation variables were not populated as suggested by Christian.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok thanks