Oracle Analytics and AI

Karthi_obiee

Hi All,

In OBIEE is there a way where I can show the total row count after running the analysis. .

Thanks.

JustTheFacts

Hello,

Are you interested only in knowing the rowcount, or do you need it displayed in the report? There are ways to do both.

Knowing the rowcount

1. If you are an administrator (or if your admin grants you appropriate rights) you can see rowcounts in the session log, available from the Administration screen in the web interface. The basic final (client) row count is visible right in the session log. For more detailed counts (DBMS rowcount for example), query logging must be enabled for the user ID running the report.
2. If you have Usage Tracking enabled (highly recommended), you can get detailed query statistics including rowcounts from the S_NQ_ACCT table. If you have a subject area built on top of the Usage Tracking tables (also highly recommended), then you can just build an Analysis for what you need.

Displaying the total (client) rowcount in the results

There are a few ways to do this, but an easy one is to add a column with this formula:

MAX(RSUM(1))

That will result in results like this:

Region	Units	RowCount
Northern	50	3
Southern	100	3
Western	140	3

You can then hide that RowCount column in your main view and use it in a Narrative view, for example, to show total rows at the top of the report.

Hope that helps.