How to Find Max Row Count for union reports

Rookie_86Oct 16 2012 — edited Oct 16 2012

Hi,

Obiee -10g.

I have a report which is combination of 2 different criteria's.

But, as per my requirement i need to show Total no. of records.

I knew, that for Total no. of records : we need to do Max(Rcount(1)).

But, when i created the same as this is combination of 2 different reports.

This, column displays - 2 distinct values i.e. say 15, 35.

15 - records is the max count of report1.

35 - records is the max count of report2.

How could i acheive the max. row count ?

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked due to inactivity on Nov 13 2012

Added on Oct 16 2012

#11g, #answers, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #oracle, #prompt, #publisher, #report, #reports

5 comments

1,045 views