Global year filter for all kpi in sap dashboard...

system · June 14, 2018, 7:32am

Hello Team,

I have four kpi which is built in WebI and through Qaaws I am using those reports in sap dashboard. The following are the fields are available in my sales dashboard…
KPI-1 Top & bottom 10 KPI-2
Customer_id Net sales Plant_id Cust_id net sales

KPI-3 Plant wise top bottom 3 KPI-4
customer_id Plant Id Net_sales Year Month Plant Cust_id Net_Sales

I want a year combo box at the top of my xcelsius dashboard which will impact on whole kpi…
If I select year 2018 in combo box. It should display data of that particular year…

Thanks in advanced…
looking for the answer…

mjuned786 (BOB member since 2018-06-14)

system · June 27, 2018, 10:26pm

Hello mjuned786,

Welcome to B B.

That’s a simple concept. Have a look at the samples that come inside Xcelsius, in particular “List Box” same concept as Combo Box.

katullus (BOB member since 2009-08-21)

system · June 28, 2018, 5:37am

Hello Sir,
I am having three reports behind the xcelcius.

Id, Revenue
Plant Id, Id, Revenue
Month, Plant Id, Id, Revenue

I have used three column chart… in 2nd report for plant id I have used combo box, working fine…
But I want one global filter which is a combo box of year which should change all the data according to year.
I want to link all the data to that combo box…
Please assist…

mjuned786 (BOB member since 2018-06-14)