Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
View and Layout in OTBI
Hi,
Is there any document / video which shows how to make changes in a view and in a layout and the relationship between the two.
Also, is there a way to make changes to the view, without the query running in the backround ?
Answers
-
Please take a look into the following docs which might be useful.
Assemble Views for Display:
Modify the Layout of Data in Views:
Hope this help.
Thank you!
1 -
If you are looking for videos with examples, please take a look into the following series which might be useful too.
Hope this help.
Thank you.
1 -
Thank you @Bhaskar Konar. I will check the above links.
1 -
0
-
Please find below some good oracle documentation and training materials for OTBI.
Hope you find this useful.
Thank you.
0 -
@Pavan Cheruvu-Oracle , Welcome to the Oracle Analytics Community!
Al the above material provided will give you a good start and understanding of the OTBI.
About your other question - is there a way to make changes to the view, without the query running in the backround ?
Answer is "No" because
- Views are generated from query output
- Any View change requires XML regeneration
- Which means the query must run
As a best practice always follow these:
- Build SQL
- Run once and generate XML
- Save as Sample XML
- Design Views using sample XML
- Design Layouts using sample XML
- Re-run query only when structure changes
0 -
@RVora
Did you mean the Analysis XML under the Advanced Tab? Are you suggesting I copy and regenerate it in a different Analysis as Sample XML?
And use this new analysis / report to make changes to the layout?0 -
Not sure if following is applicable for OTBI Report?
As a best practice always follow these:
Build SQL
Run once and generate XML
Save as Sample XML
Design Views using sample XML
Design Layouts using sample XML
Re-run query only when structure changes
It would be helpful if you can provide some more information?
0
