BI Publisher (MOSC)

MOSC Banner

BIP 11.1.1.7.1: Group Filters

edited Apr 1, 2014 12:45PM in BI Publisher (MOSC) 3 commentsAnswered

Hello,

I have a data model with the following structure:

G_1

    G_2

The parent group G_1 record can have multiple child records in G_2.

I have defined a PLSQL Group Filter on G_1 but it seems that BIP executes it as many times as there are number of records in G_2.

That surprised me. I would have thought that since the filter is defined at G_1 level, it will only be executed for each row retrieved at G_1 level to either include it or not based on the filter outcome.

Is this how it's supposed to work?

Thanks,

Manish

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