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

Detail Report (Drilldown) is not reflecting the correct county

Received Response
2
Views
1
Comments
Cameron Loepker
Cameron Loepker Rank 4 - Community Specialist
edited Aug 13, 2024 5:25PM in Oracle Analytics Cloud and Server

Hello Board,

I am on OBIEE version :Oracle Business Intelligence 12.2.1.3.0

In a nutshell- I know the answer to my question, but I would like to hear any other opinions or methods of solving this issue.

backstory-

We have a summary report that is performing a union, then there are two different drill down reports showing detail to two respective total amounts (Total A and Total B). My goal is to have the detail report filtered on the correct county per which line they drilled into.

we have a county code column that is being used from source A in union set 1, and a completely different column from another table which is county code (same values) to finish the union is set 2.

I have tried to do a filter on each of those columns inside the detail report where is prompted, but so far I am unable to get this to work. I have used every single county code that is being touched by the summary but it still does not want to play nice.

to my eyes there are no conflicting filters, and the joins in the RPD have been meticulously reviewed by three different developers..all seemingly correct joins. the only filter that is processing correctly onto the detail report is the time period, where we are using a dashboard prompt on summary report and a presentation variable being called in the filter of the detail report. It wouldn't work to create a dashboard prompt on the summary page, because there is the desire to see all counties by default, and the preferred functionality would be to click on the amount of a certain county then be brought to a report that has the detail breakdown.

also to add more information, union set 1 is bringing in data from a retired table that is <=2017 and union set 2 is using the new table which is 2018 and forward. i did try to add the county code from the old table, and it did not like that.. so it appears I am stuck using the county code from the second union set but it is not actually working.

thanks,

Cameron

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Cameron Loepker wrote:In a nutshell- I know the answer to my question, but I would like to hear any other opinions or methods of solving this issue

    Model it in the RPD and do no use UNION in the analysis? ;-)