BI Publisher (MOSC)

MOSC Banner

Issues with group filter

edited Dec 15, 2011 6:40AM in BI Publisher (MOSC) 6 comments
I have a pretty simple DM based on Siebel DB - list of accounts, and for each account - list of contact. On Accounts data group i have aggregate function column that counts the number of contact in that account. It works fine. The issue starts if i try to use this aggregate as group filter - it work fine if i specify the filter as "CONT_CNT=0" the resulting XML only shows accounts with zero contact. But if i specify it as "CONT_CNT>0" then i get EMPTY XML, like that
<DATA_DS>
</DATA_DS>

Any idea what is wrong ? 

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