Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OBIEE 12c Trouble determining the total number of records returned using unions

Received Response
11
Views
2
Comments
Tom D
Tom D Rank 3 - Community Apprentice
edited Aug 13, 2024 5:14PM in Oracle Analytics Forum

I have an analysis which uses several unions. Rather than scrolling to the bottom of the results and seeing that "Rows 1 of X" (X being the total that I am looking for), I would like to see X near the top of my results. This may have been posted here before, but I cannot find a meaningful solution.

Answers

  • Christyxo
    Christyxo Rank 2 - Community Beginner

    If your analysis is static, and it's not a particularly high cost to the database you could just create a second version of your analysis which is only the total and then place both of those analysis on a dashboard. Aggregation at top, detail at the bottom.

    If it's dynamic in any way, you could also convert the criteria to dashboard prompts that affect both versions of your analysis.

  • Tom D
    Tom D Rank 3 - Community Apprentice

    Christyxo,

    Yes, I'm doing what you had mentioned. I was hoping to not have to do the second aggregation piece and keep it to one analysis.

    Thanks for responding.