Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Alter OTBI column properties on multiple columns in one action

Accepted answer
22
Views
5
Comments
C Hammond
C Hammond Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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.

Tagged:

Best Answers

  • Gianni Ceresa
    Gianni Ceresa Mod
    Answer ✓

    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
    Bhaskar Konar Rank 8 - Analytics Strategist
    Answer ✓
    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.

    image.png

    Hope this help.

    Thank you.

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics Lead
    Answer ✓

    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

    image.png

Answers