Oracle Analytics Cloud and Server

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

Enable alternate styling by default in OBIEE analysis

Received Response
21
Views
9
Comments
User_DTFOB
User_DTFOB Rank 4 - Community Specialist

Hi Team,

We would like to enable alternate styling by default for all users when they create a new report in OBIEE.

Is there a way or XML tag that we can add in instanceconfig table to enable it by default.

pastedImage_0.png

pastedImage_1.png

Answers

  • User_DTFOB
    User_DTFOB Rank 4 - Community Specialist

    Hi Team,

    Any suggestions for the query posted.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You can fiddle with pretty much every single setting/button and about 10 years back many people did it and blogged about it.

    But we stopped doing this since that's just taking customization too far. What's the real added value vs everything you can mess up when doing it. Also since you're touching core files for most of those things you will lose your customization every time you patch.

    And that's another thing. In 2020 companies should definitely rather stay on track with updates (bundle patches) every 3 months rather than not doing anything for 5 years and then complaining that everything has changed and the upgrade effort is so high.

  • User_DTFOB
    User_DTFOB Rank 4 - Community Specialist

    Hi Christian,

    Thank you for the reply.

    I surfed for quite some time but did not find anything related to alternate styling.

    I do agree we should not go too far with the customizations. I posted this query as all our reports have this green bar styling consistently for all reports.

    And would like to come by default instead of changing the property everytime.

    Please guide with any solution

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    First place I can guide you too is obviously the documentation which outlines how many of the customizations can be done via the webmessages:

    https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-19315C4B-8B73-41BD-B5CE-B1F79C31263E.htm

  • User_DTFOB
    User_DTFOB Rank 4 - Community Specialist

    Hi Christian,

    The documentation is quite useful to change the defaults for analysis and dashboards, however does not mention anything about alternate styling.

    To modify the alternate styling settings, We will have to change the answerstemplates.xml or the instanceconfig.xml.

    I am also not aware of the exact Tag which needs to be added to one of these files.

    I know this is a very specific question, but any guidance will help.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I'm really not a fan of suggesting anyone to do this or play with those files (as I said, you can pretty much destroy your environment).

    Have a look at MOS Doc Id 2298472.1. It is one of the official documents covering a customization of this sort. You basically have to find which JS controls the table view and then modify that JS.

    Once more: bad idea. Back up thing 50 times before modifying.

  • User_DTFOB
    User_DTFOB Rank 4 - Community Specialist

    Hi Christian,

    I will not be confident in changing in any of the JS files myself as I do not hold any experience in it. I was hoping if there is any direct way to update it in files like instanceconfig etc.. wirh an XML tag.

    This is not priority for us and we wanted to have it is a value add.

    Since it looks little tricky and can lead to issues in future.. we will leave this item for now.

    Thank you

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    It's better not to do this except for maybe in a sandbox to see how it works.

    The solution is the JS in the MOS Doc above. For future reference and for other users looking for this you could mark that one.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    For the benefit of other forum users and in order to help them find answers quickly and efficiently, could you please close this thread?