BI Publisher (MOSC)

MOSC Banner

MIN and MAX aggregate functions not working in BI Publisher repot for a String type in Pivot.

edited Dec 18, 2014 10:17AM in BI Publisher (MOSC) 3 commentsAnswered ✓

In my BI Publisher report, I have a pivot table with two measure columns 'Equipment Code' and 'Bad Order Code'.
Both are VARCHAR.I used Oracle BI Analysis as my source Data Model.When I try to use these two columns as measures, I noticed the MIN and MAX are greyed out in the Pivot table.I also noticed in BI Publisher report, the MIN and MAX are only applicable to numeric types and not for strings,unlike OBIEE.Cannot a String type have Count, First, Last, Maximum, and Minimum   functions applicable in BI Publisher report.

But the same works if I choose a Data Table instead of Pivot.B/c in a Data Table I can use 'No Formula' option and display the value as is.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center