nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

View and Layout in OTBI

Pavan Cheruvu-Oracle

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 ?

Find more posts tagged with

OTBI Reports

Accepted answers

All comments

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/28011/view-and-layout-in-otbi

Hi @Pavan Cheruvu-Oracle,

Please take a look into the following docs which might be useful.

Assemble Views for Display:

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/assemble-views-display.html

Modify the Layout of Data in Views:

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/modify-layout-data-views.html#GUID-0C106632-0431-46F7-B0E0-6EA8210EBD67

Hope this help.

Thank you!

Bhaskar Konar

Hi @Pavan Cheruvu-Oracle.

If you are looking for videos with examples, please take a look into the following series which might be useful too.

https://www.youtube.com/playlist?list=PL_TVdLD62yrv-uuOQrnpJmkYXE8BIfchI

Hope this help.

Thank you.

Pavan Cheruvu-Oracle

Thank you @Bhaskar Konar. I will check the above links.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/74431#Comment_74431

Hi @Pavan Cheruvu-Oracle,

Yes, sure. Do let us know.

Thank you!

Bhaskar Konar

Hi @Pavan Cheruvu-Oracle,

Please find below some good oracle documentation and training materials for OTBI.

https://docs.oracle.com/en/cloud/saas/otbi/

https://docs.oracle.com/en/cloud/saas/otbi/create-analyses-dashboards-otbi.html

Hope you find this useful.

Thank you.

RVohra

@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

Pavan Cheruvu-Oracle

@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?

Bhaskar Konar

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?