Union being overridden in OBIEE

Question

I have used a 'Union' to combine two reports showing different dates. When I open the report on it's own it works fine with the two dates shown. However when I drill to the (union) report from another on the dashboard it only shows one date. Is there a dashboard filter that I may need to un apply or is there some other explanation!? I cannot seem to get the report to function as required from the drill.

Answer 1

Tough to answer - need more info. Some possibilities:

1. You're not really drilling to the report you think you are. You can learn a lot by looking at the log to see what's happening in the target report.
2. You may be passing values from the first report that exclude the date in the second report. Check your filters in the target report. Look at the generated WHERE clause in the log. Run the SQL directly against the database. Is the date still excluded?