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

Alter OTBI column properties on multiple columns in one action

C Hammond

In an OTBI Analysis, is it possible to change the column properties on multiple columns (without having to access column properties on each column separately) - IE; can you set the Value Suppression to Repeat on all columns within the analysis ?

Thanks in advance.

Find more posts tagged with

Tips & Tricks

Analysis

OTBI

Report Layouts

Accepted answers

Gianni Ceresa

Hi @C Hammond ,

Welcome to the Oracle Analytics community and forum !

While not having access to an OTBI right now to check, I'm quite sure that there aren't more features than what OBIEE/OAS has from that point of view.

If you have access to the analysis XML code, yes. Because all the properties of each columns are defined in there. But, is it worth it? You have many more chances to break something, because it is a large piece of XML that must follow a number of rules etc.

There isn't an interface for changing the same setting on multiple columns of an analysis.

It's annoying, but setting it manually on each column is still the safest way (just try to make sure all the rest is correct, so you didn't waste those 10 minutes clicking through all your columns).

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27010/alter-otbi-column-properties-on-multiple-columns-in-one-action

Hi @C Hammond,

Fully agree with Gianni's explanation above.

If your requirement is to repeating the value in each row, you can do it from the Table Properties. Please find below a screenshot highlighting in yellow.

Hope this help.

Thank you.

Rich Merkel

You cannot do across multiple columns at same time in analysis.

however you can copy/paste the format from one column to another. Use the gear, column properties, on the column you have formatted select copy (1st icon in red). Then goto subsequent columns and use paste (2nd icon in red). This only does the style, however things like data format must always be done individually on each column from what I have experience.

-Rich

All comments

Gianni Ceresa

Hi @C Hammond ,

Welcome to the Oracle Analytics community and forum !

While not having access to an OTBI right now to check, I'm quite sure that there aren't more features than what OBIEE/OAS has from that point of view.

There isn't an interface for changing the same setting on multiple columns of an analysis.

It's annoying, but setting it manually on each column is still the safest way (just try to make sure all the rest is correct, so you didn't waste those 10 minutes clicking through all your columns).

C Hammond

Thanks @Gianni Ceresa

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27010/alter-otbi-column-properties-on-multiple-columns-in-one-action

Hi @C Hammond,

Fully agree with Gianni's explanation above.

If your requirement is to repeating the value in each row, you can do it from the Table Properties. Please find below a screenshot highlighting in yellow.

Hope this help.

Thank you.

Rich Merkel

You cannot do across multiple columns at same time in analysis.

-Rich

C Hammond

@Rich Merkel @Bhaskar Konar - thank you both, really useful to know!

SantoshKumarBhairi

@C Hammond alternatively, you can explore the options of editing such properties thru Advanced / Analysis XML.

C Hammond

https://community.oracle.com/products/oracleanalytics/discussion/comment/75609#Comment_75609

Really good point - I had not considered using that! Thank you @SantoshKumarBhairi