OBIEE 11G: BI Publisher issue with fragmentation content

user6324533

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

Hi,

First thing first: you aren't talking with Oracle Support but posting on a community and public forum, if you want to open a SR you must go to https://support.oracle.com/

What does the logs tell you?

Any query in OBIEE has logs, so you must be able to find exactly what query Publisher is sending to OBIEE.

Wanted to try to make the example online right now but no luck on OBIEE 11g there are 500 users online with mobile app killing the instance and on the 12c one they wrongly set datatypes on dates for the fragments ...

user6324533

Hello Gianni, thanks for your reply, yes I also opened an SR, but I thought I should try my luck here as well.

I looked at the log, and the SQL query generated is indeed wrong: it is using the first table (the one with data only after the year 2009) to query data from 2008. The "fragmentation content" is not taken into account.

Gianni Ceresa

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 ...

user6324533

Thank you for your test.

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

Gianni Ceresa

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