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

Question

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.

Tom D · Answer

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.

Christyxo · Answer

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.