Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TOP N & ALL OTHER in BOBJ 4.0 Dashboard Design

Hi All,

We are SAP BW using BEx Queries as the datasource via BOE in Dashboard design.

Does any one have any idea on doing Top 10 or N on customers and show All Other and plot in the column graph.

Requirement:

Show table on Top 10 or N based on "Total" Volume. Metrics the table need to shows is Volume and Growth Rate.

                                                          jan feb mar apr may jun jul aug sep oct nov dec   q1   q2    q3   q4    total

Customer N         Act Fcst Vol          100 200 100 100 50 50 50   30 30    40  50     50   400 200 110 140   850

                              GR%

                              Next Year GR%

Customer N-1        Vol

                               CY GR%

                    Next Year GR%

Customer N-2         Vol

                                GR%

                     Next Year GR%

Customer N-3         Vol

                                  GR%

                      Next Year GR%

:

:

TOP 10 Total : Vol

                         GR% (% shouldnt add up)

        Next Year GR% (% shouldnt add up)

Graph 1 : N customer & All Other in X axis and Volume on Y Axis

Click on each customer and show graph on current growth rate and next year growth rate by month in x axis and % in y axis.

Please let me know if it can be done in BOBJ 4.0 Dashboard design.

Thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question