Bold/Border for Selected Rows

2773333

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.

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

Gianni Ceresa

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

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

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

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,

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

Regards

Vyshak P

Thomas Dodds

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.