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

Jonathan Chan gmg · May 2020

Summary

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

FPonte · May 2020

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.

Prudence K · May 2020

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?

Raghavan p-Oracle · May 2020

Yes, this is not possible.

Jonathan Chan gmg · May 2020

Hello Fernando,

Thank you for for the response and reference link.

Best.

Jon

Jonathan Chan gmg · May 2020

Hello Raghavan,

Thank you for the affirmation.

Best.

Jon

Jonathan Chan gmg · May 2020

Hello Prudence,

Thank you for the "reverse engineering" approach!

Best.

Jon

Robert Fighiroae-Oracle · June 2020

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

Prudence K · June 2020

This is awesome - thank you for this!

Jonathan Chan gmg · June 2020

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

Robert Fighiroae-Oracle · June 2020

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