cancel
Showing results for 
Search instead for 
Did you mean: 

need help to develop report with column chart

Former Member
0 Kudos

Hi

I am new to SAP BO world.Could anyone please help me to design report with column chart.Please guide me how to develop report for the following requirement.I am not aware of variance columns and variance labels.Please provide some guidance or some tutorials(for column Chart) so that I can complete the task. Please reply me as soon as possible.Waiting for reply.Thanks in advance.

Type: Column Chart

u2022 Rows: Banking Asset Margin (%)

u2022 Start / End Columns: PY YTD Act(Prior year year to date); CY YTD Act(Current year Year to date)

u2022 Variance Columns: # Var (CY-PY Act) for GOLM; Volume; Rate; Non Banking NII; Banking Volatility in NII; Banking Volatility in OOI; Fees/One Offs/Other; Volatile Items; Sophie

u2022 Sub-total columns: PY YTD Underlying; CY YTD Underlying.

u2022 Variance Labels: % Var (CY-PY Act) for Total Income and Underlying Income

u2022 Sub-Total Labels: # Var (CY-PY Act) for Net Insurance Income; Banking Volatility; Other Operating Income

Additional information

u2022 Variance columns (bar) colours: Red = Adverse to Prior Year; Green = Favourable to Prior Year

u2022 Columns to show values. Adverse values to be shown in red text in brackets. Favourable results in black text.

u2022 All values in Black, but adverse to be shown below the bar.

Accepted Solutions (0)

Answers (1)

Answers (1)

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

This type of question is almost impossible to answer over a forum .

You need to work with your business to understand what these requirements mean in terms of data modelling and relationships between object entities.

- Some of these metrics should be delegated to source, and calculated in the update routines to your datatargets (aka Cubes/Tables)

- Others could be resolved in the semantic layer (Universe)

- Other will be calculated in the presentation layer as local formulae or variables.

whilst BusinessObjects is a fairly intuitive tool, it may be unreasonble to expect a new learner to deliver an advanced report with conditional formatting.

Regards,

H