OBIEE 11G: BI Publisher issue with fragmentation content

Question

Dear Support,

We face a potential bug with BI Publisher in OBIEE 11G when the logical table sources use the "fragmentation content" feature.

The example of the bug we have is with 2 logical table sources:

- The first one has the fragmentation content YEAR >= 2009

- The second one has the fragmentation content YEAR < 2009

So these 2 logical table sources are complementary: one has the data after 2009, the other one has the data before 2009.

This fragmentation feature works fine in OBIEE.

Now when we build a data model in BI Publisher, we have data only after 2009.

The second table is ignored.

The fragmentation content feature is ignored.

Please let us know: is this a known bug in BI Publisher ? I did not manage to find information regarding this issue on the internet.

Is there a way to fix the problem?

Thanks and regards,

Sylvain

Gianni Ceresa · Answer

As you just said 11g I took the latest 11g SampleApp, so 11.1.1.9.0 (Build 150415.1247 64-bit)

user6324533 · Answer

Thank you for your test.

Which 11G version are you using? We have 11.1.1.7.150120.

Gianni Ceresa · Answer

Managed to run my local SampleApp 506 (11g) : fragmented source in Publisher no problem at all.

Same analysis in OBIEE gives the same results as Publisher using a Subject Area as source. The 4th column is the "fragmented column" while 2nd and 3rd go to one logical table the first and to the second logical table the second.

The fragmentation condition is really similar to yours, based on a date but going down to the day instead of stopping to the year, same business ...