Oracle Transactional Business Intelligence

How to pick mulitple fields into table box when buidling report using data model?
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
Answers
-
Hi Jonathan.
As far as I know that is not possible.
Cheers
Fernando.
-
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?
-
Yes, this is not possible.
-
Hello Fernando,
Thank you for for the response and reference link.
Best.
Jon
-
Hello Raghavan,
Thank you for the affirmation.
Best.
Jon
-
Hello Prudence,
Thank you for the "reverse engineering" approach!
Best.
Jon
-
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
-
This is awesome - thank you for this!
-
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 == ABCFurthermore, 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
-
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
-
HA! Sometimes I love my Outlook ... it reformatted your response to this:
-
Hello Robert,
Thanks for the advise.
I have posted the questions on the following 3 posts:
https://cloudcustomerconnect.oracle.com/posts/db4fd3db16
https://cloudcustomerconnect.oracle.com/posts/64c2017ac6
https://cloudcustomerconnect.oracle.com/posts/9c3b02a874
Chat over there.
Jon
-
What an "open ended" response. I've have posted my outstanding questions to 3 new posts below, and hopefully they will offer "closure"!
https://cloudcustomerconnect.oracle.com/posts/db4fd3db16
https://cloudcustomerconnect.oracle.com/posts/64c2017ac6
https://cloudcustomerconnect.oracle.com/posts/9c3b02a874
Best.
Jon
-
HA HA