OBI filter on prior analysis ignored

Question

Would like some ideas on troubleshooting the scenario below where  dashboard page # 3 returns zero rows...thank you.

Page # 3 filters on several columns plus the following...

Customer ID is present in analysis query from  page # 1

Customer ID is not present in  analysis query  from   page # 2

The log file produced from  page # 3 shows that the query in  page 1 is called.

The query from  page 2 is absent from the log for  page # 3.

Message was edited by: 3713479

The underlying problem is that the analyses for each dashboard page are not sharing the same date ranges.  When there is a dependency on the results of an earlier analysis, that analysis is run with date ranges not defined for that page even though the scope is set at the page level.

3713479 · Answer

Thank you  for your suggestions...

I am using version 11.1 & the analyses are from the same subject area.

Note that his discussion thread is related to an earlier discussion thread where the filters are based on earlier analyses.

The objective is to identify customers who opened an account during a calendar window that includes the reporting quarter and the six months preceding the quarter.  A second criteria is  that the account remained open for a portion of the quarterly reporting period.

Since this approach was working successfully when the analyses were relying on date ranges that were embedded in each analysis, I did not anticipate problems in adding the analyses to a dashboard and allowing the user to specify the dates for each page of the dashboard and clicking on "Apply" to launch the analysis.

Note that I have defined the date prompts with default values.

Page 1 - filters to extract customers who opened an account during the window six months preceding the quarter as well as the three month period comprising the quarter.

Page 2 -  customers based on page 1 dataset where the account remained open during the quarter.

Page 3 -  customers who are disqualified because the account was closed during the six months preceding the quarter.  The logic for this analysis is that the customer is defined in page 1 results and not defined in step 2 and a transaction code indicates the account was closed and the reason for the closing.   A subsequent analysis step checks that the account was not reopened after closing.

Absent from the log for this step was the query from page 2.

The suggestion that the query was bypassed since the results would not change from the original execution seems plausible, but the step should not return zero rows.

Any additional suggestions are appreciated.

[Deleted User] · Answer

Gianni Ceresa wrote:I guess this is somehow linked to a previous thread which was about how to filter page Y based on analysis in page X.

Not sure having to peruse old threads to comprehend a question is a practical way of running the forum ;-)

Gianni Ceresa · Answer

I guess this is somehow linked to a previous thread which was about how to filter page Y based on analysis in page X.

OBIEE always try to be as smart as possible, optimizing the query as much as it can. Till where you see the filter on analysis page #2? When does it disappear?

It's possible that OBIEE believe the result will be the same by removing it at some point, but it's just guesses...