Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Brio ColMax in OBI

659047Feb 25 2009 — edited Feb 25 2009

HI,
One problem I encountered while migrating our Brio report to OBI. There is ColMax function within Brio to return the largest value in a column of numbers.
e.g

ColMax (Amount, State) as Computed

State City Amount Computed
AZ Tucson 112 112
CA Burbank 240 240
CA Glendale NULL 240
NY New York 490 490
NY Rochester 180 490

Is there any way I can implement this in OBI?
Thanks
W.D

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2009

Added on Feb 25 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

3 comments

776 views