OBI Dashboard analysis hangs

3713479

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}

[Deleted User]

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]

@3713479 did you give up on this?

[Deleted User]

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

3713479

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

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]

Ok thanks