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

Is it possible to create link-level links between two subgroups?

Received Response
87
Views
5
Comments
John K-Ctr Boyd
John K-Ctr Boyd Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

Is it possible to create link-level links between two subgroups?

Content

I am using BI Publisher Enterprise / OBIEE 11.1.1.7:

I am trying to recreate a data model in BI Publisher Enterprise based on a Reports Builder RDF data model, but I and having difficulty reproducing the structure:

Reports Builder - Link Group to Group.png

Should it be possible to create links between the two groups G_PO_LINE and G_BL_PO_SHIPMENT?

Also, the hover links are put up into the far corner, which appears to be a bug.

G_PO.PO_HEADER_ID -> G_BLPO_SHIPMENT_ID.PO_HEADER_ID

G_PO.PO_LINE_ID -> G_BL_PO_SHIPMENT.PO_LINE_ID

BI Publisher - Link Group to Group.png

However, after I create the links and save the data model, the G_PO_DIST group and links all disappear when the data model is reloaded!

Snap32.png

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    There are so much things that you can do at template level than data model ,doing at data model has better performance ,something that cannot be achieved at data model can do at template , and your requirement can do at both level. Thanks

  • John K-Ctr Boyd
    John K-Ctr Boyd Rank 2 - Community Beginner

    BI Publisher 11.1.1.9.0 build 20161208

    I don't think a "link" in an RTF is the same as a SQL join(?) and this is what I need to produce the proper result set. Some of the things I need to do are best done at the data model level and are difficult (if not impossible to accomplish in an RTF template.

  • John K-Ctr Boyd
    John K-Ctr Boyd Rank 2 - Community Beginner

    Yes, that is what I am doing… element level links  between two queries that have TWO groups each. This seems to cause problems. I have filed an SR with Oracle and they are investigating why the structure is not preserved by the BI Publisher application (as it is in Reports Builder). Stay tuned.

    I have tried the RTF approach. The example I've shown is a simple one. The actual report requires several more queries and ~ 30 sums across different groupings. This seems like too much to ask of an RTF template since they are intended more for formatting output.

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    what is BIP version? 

    you can link two different data sets at template level instead of data model level. Thanks

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Try creating element level link,

    Creating Element-Level Links

                            Or

    You can regroup data or link different data sets at RTF template level.

    please upload xml , rtf template(if created) , sample output.