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

Bold/Border for Selected Rows

Received Response
22
Views
5
Comments
2773333
2773333 Rank 4 - Community Specialist
edited Aug 13, 2024 6:10PM in Oracle Analytics Cloud and Server

Hi All

I have a requirement from the customer that they need some of the values highlighted in bold and some with top and bottom border for a particular row item.

The row is the Total of the items above. The report looks like the screenshot below.

Capture.PNG

In the picture the values of 'Total Postpaid Billed Revenue', 'Total Postpaid Recurring Revenue', 'TOTAL POSTPAID - Consumer Gross Revenue' should be highlighted from the other.

One solution that I knew was conditional formatting. So I created a column in the analysis as Rank -> ASCII(CAST(RANK("Column"."Name") as char (4))). This formula is expected to give a unique rank for all the items so we can provide conditional formatting based on Ranks. However, some of the Ranks are repeating for multiple items hence when I give bold for that rank it is affecting other description items.

Anyone with better solution for this requirement ? Any help will be appreciated.

Thanks

Vyshak

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Why don't you simply use as condition the values of your first column? "TOTAL POSTPAID - Consumer Gross Revenue" will always have the same name while ranking can easily change by adding a new account / kind of revenue.

  • 2773333
    2773333 Rank 4 - Community Specialist

    Hi Gianni

    I agree with your point about making a condition with respect to the first column. But this will be static and tomorrow when there are new accounts added the TOTAL value will tend to change.

    This will not change our condition. Is it ?

    Regards

    Vyshak P

  • Gianni Ceresa
    Gianni Ceresa Mod

    The total value will change, and this is why your RANK() approach will not work if you add accounts. But are you going to change the label of the total account as well?

    If the answer is yes then you need something else like an attribute you don't display but which is related to the accounts and identify the various kind of accounts requiring different styles.

    If your accounts are in a dimension you can make things in a cleaner way by settings styles based on the hierarchy level of your accounts.

    Have a look at http://slc02oks.oracle.com:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F11.%20Demos%2F_portal%2F11.20%20Essba…

    (Prodney / Admin123)

  • 2773333
    2773333 Rank 4 - Community Specialist

    Hi Gianni

    We will not change the label of the Total account. But here the Total account is hardcoded as Sum ( The related accounts ) For example Total POSTPAID REVENUE = Subscription Revenue + Outroaming Rev., + etc. etc. as seen in the pic below,

    pastedImage_0.png

    Since the Total Account is just a static value then how can we give it in the conditional format ?

    Regards

    Vyshak P

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    This is where you need a dimensional hierarchy to do the aggregation logically and then you'd have the logical column on which to base the advice that you've been given. 

    After having done copious amounts of Financial rollouts with OBIEE, it's imperative to have the account dimension built with the appropriate hierarchies in the physical layer first.  This makes performance and maintainability much much easier to achieve.