Oracle Transactional Business Intelligence

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

How to pick mulitple fields into table box when buidling report using data model?

Received Response
195
Views
14
Comments

Summary

How to pick mulitple fields into table box when buidling report using data model?

Content

Hello Oracle Community,

When building report using data model, in the "Create Table" process, is there an option that allows dragging multiple fields together over to the table box?  Instead of having to drag one field at a time.

Thank you.

Jon

 

Version

Oracle Business Intelligence 11.1.1.9.0

Screenshot 2020-05-05 at 4.45.35 PM.png

Welcome!

It looks like you're new here. Sign in or register to get started.
«1

Answers

  • Rank 6 - Analytics Lead

    Hi Jonathan.

    As far as I know that is not possible.

    https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-AF9605D4-56E5-4EEF-AEC2-559A103091C0.htm#BIPRD2211

    Cheers

    Fernando.

  • Rank 5 - Community Champion

    I have never been able to do anything like that - however when I am building reports, I usually work right to left.  So if I am build a report that has 15 columns, I drag in column 15, then 14, then 13, etc.  This way, I am not starting with 1, then 2, then scrolling over to add 3, then scrolling over to add 4, etc.  Hopefully that helps a little bit?

  • Rank 5 - Community Champion

    Yes, this is not possible.

  • Rank 5 - Community Champion

    Hello Fernando,

    Thank you for for the response and reference link.

    Best.

    Jon

  • Rank 5 - Community Champion

    Hello Raghavan,

    Thank you for the affirmation.

    Best.

    Jon

  • Rank 5 - Community Champion

    Hello Prudence,

    Thank you for the "reverse engineering" approach!

    Best.

    Jon

  • Rank 4 - Community Specialist

    Hi Jon,

    This is not possible for BIP Interactive View - If this is a functionality that you would like to have in the feature, you can raise it as an Idea on the BI Technology page:

    https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary

     

    If I'm in a hurry and don't necessarily need a BIP report with interactive view then I usually go for the RTF template auto-generation:

    - Cancel the Create Report screen

    - Select the data model from the upper left side of the screen

    - Click on Generate RTF layout based on selected Data Model

    - Provide a Template Name

    - Click on Generate

    - Save the Report

    You should now have the report generated with all columns used in the Data Model, without having to drag and drop each and every one of them.

     

    Kind regards,

    Robert

  • Rank 5 - Community Champion

    This is awesome - thank you for this!

  • Rank 5 - Community Champion

    Hello Robert,

    Thanks for the solution.

    I performed the approach you advised, and ran into 2 errors.  Could you kindly comment on possible resolution:

    1) Error 1
    • Error code - It appears when I run the saved report.
    oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.ProcessCancelledException: FOBlock was cancelled after 0 seconds
    • Data model:
    EGP_SYSTEM_ITEMS_B

    2) Error 2
    • Error was prompted when coding the function "OR" to enable a column be filtered by two different entries (G_1.ITEM_NUMBER == ABC OR DEF).  Please see attached screenshot for the error message.
    • Remark: Formula would work if column is set to equal  (==) to only one entry.  ex.  G_1.ITEM_NUMBER == ABC

    Furthermore, do you know which column and table is the description to Attribute entries usually located at?  In particular the descriptions to Attribute4 and Attribute5 in the table EGP_SYSTEM_ITEMS_B.  I understand the description entries' location could be company specific but I am wondering whether there is a column where the attribute descriptions are usually located at.

    Lastly, what's the difference between tables that are different only by an underscore "_" written at the end of the table name?  Ex. Table "EGP_SYSTEM_ITEMS_B" and Table "EGP_SYSTEM_ITEMS_B_"?

    Best.

    Jon
     

     

    ERROR 2.png

  • Rank 4 - Community Specialist

    Hi Jon,

    This topic was opened for the "How to pick multiple fields into table box when building report using data model?" question and my solution was for this question.

    Regarding your last reply, please open a new thread and provide full description of what exactly are you trying to do in the data model.

    Best regards,

    Robert

Welcome!

It looks like you're new here. Sign in or register to get started.