# 1.    Import a Business object report through Live office Connection

• Goto Live office tab and click on interactive analysis to import a BO report.
• Goto the respective report from where the data is supposed to be fetched.(make sure you have ranked the objects in the report using a dense rank  formula as provided below)
• Create a object [Status] in Universe for Least or High rated company)

=If([Status]=”Least”;[Rank_Amt];[Rank_Amt2])

Where

[Rank_Amt]= dense_rank() Over(Order by Sum(Revenue)ASC)

[Rank_Amt2]= dense_rank() Over(Order by Sum(Revenue)DESC)

*Note: [Rank_Amt] and [Rank_Amt2] are universe objects

You can refer to the link for further information on SAP BO Dense ranking

2.    Import a Business object report through Live office Connection

# Select Labels for the radio button from the imported BO report

Select The Source and destination for the radio Button

Source:

Destination:

# –This formula will leave a blank space where the rank is repeated

Take 5 cells in Excel which will give smallest 5 numbers out of the above formula

Say N7 to N11

# N7 = SMALL(L:L,1)

N8 = SMALL(L:L,2)

# N11 = SMALL(L:L,5)

-These Formulas will give the minimum 5 values out of the above formula

Create a flag Column with Formula as follows

=IF(ISNA(IF(MATCH(H7,\$N\$7:\$N\$11,0),”between”,”older”)),””,IF(MATCH(H7,\$N\$7:\$N\$11,0),between”, older“))

# ***Even if there are many Number of Companies on the same rank all of them will be considered and displayed.

Refer to the below excel dashboard snapshot