Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11G: BI Publisher issue with fragmentation content

Received Response
1
Views
5
Comments
user6324533
user6324533 Rank 1 - Community Starter
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

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

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    user6324533 Rank 1 - Community Starter

    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
    Gianni Ceresa Mod

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

    Capture.PNG

    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
    user6324533 Rank 1 - Community Starter

    Thank you for your test.

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

  • Gianni Ceresa
    Gianni Ceresa Mod

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