BI Publisher (MOSC)

MOSC Banner

BI Publisher - MAX function broken ?

edited Feb 26, 2014 12:00PM in BI Publisher (MOSC) 12 commentsAnswered
 I am using BI publisher 11.1.1.6

I have the following table with two records :


SELECT * FROM MMJ2;

F1       F2
---      ----
-10    100
-5       200

I create a dataset G_1  doing a select * from mmj2

I drag F1 from G_1 to the Global  Level Functions dataset and do the MAX aggregate function. F1 and F2 are number fields in the db and integers in BI Publisher.

It is returning 0 as the max for F1, it should return -5.    Here is the sample XML output :

<DATA_DS>
<G_1>
<F1>-10</F1>
<F2>100</F2>
</G_1>
<G_1>
<F1>-5</F1>
<F2>200</F2>
</G_1>
<MAX_FI>0</MAX_FI>
</DATA_DS>

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