Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to set different Border color to single column in pivot table

Received Response
105
Views
7
Comments
3212463
3212463 Rank 3 - Community Apprentice
edited Aug 13, 2024 7:03PM in Oracle Analytics Cloud and Server

in OBIEE 10g, want to customize cell border of pivot table, for right side of cell should be black and rest sides need to be other color. When trying to set same from Edit Format -> Border setting, at a time it allows to set only one color, rest sides of cell become blank.

When tried to set it from 'Custom CSS Style' by using border-right:   black 3px solid; this border is coming around text in that cell and not to exact border of cell.

Request your i/ps on same.

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    Check this https://forums.oracle.com/forums/thread.jspa?messageID=10743192

  • 3212463
    3212463 Rank 3 - Community Apprentice

    Hi Srini,

    CSS styles mentioned in link given by you not helping me out. I want to set border of measure column of pivot table. I am trying to do it from

    pivot table -> measure column -> Format measure value

    But whatever CSS style code we write, it applies on text (measure value) and not on cell border.

    Please suggest.

  • #Mayur
    #Mayur Rank 5 - Community Champion

    Hi,

    It can be easily achieved by the conditional formatting.

    Try with the conditional formatting.

    Thank You.

    Mayur

  • 3212463
    3212463 Rank 3 - Community Apprentice

    Hi Mayur,

    Thanks for your reply, however, we want to set different color to 2 sides of borders of same cell,

    which is not possible from border formatting,

    and from conditional formatting, on one cell only one (first) conditional format works, other conditional formats defined are not working.

    Please suggest.

  • #Mayur
    #Mayur Rank 5 - Community Champion

    Hi,

    I am using thick line instead of single line to highlight the color. Please check out the following snap I have used different color for the SINGLE CELL.

    pastedImage_0.png

    Criteria:

    pastedImage_1.png

    Logic:

    I have applied conditional formatting on different measure on single cell,

    >>Manufacture cost:

    pastedImage_3.png

    Marketing Spend:

    pastedImage_5.png

    and the last one:

    No of Units Sold Out:

    pastedImage_7.png

    Use the same kind of logic. I hope it will work

    Mark it helpful if it works.

    Thank You.

  • 3212463
    3212463 Rank 3 - Community Apprentice

    Hi Mayur,

    Thank you for your reply, it is definitely helpful.

    However, when I am trying to set one side of border in my report, OBI is making remaining 3 borders as blank (no border at all).

    Seems you are doing it in 11g and I am using 10g. Is it version issue or does it has any workaround or setting?

  • #Mayur
    #Mayur Rank 5 - Community Champion

    Hi,

    Not sure about version because I don't have experience of the other Version.

    Mark it helpful.

    Thank You.