Create a number of Dynamic Charts based on "Work Centre" in BEx Workbook?

Hi all,

We are on BI 7.0

I am trying to create a number of dynamic charts in a BEx workbook based on the different values of "Work Centre" so that each unique work centre has its own chart.

All titles and descriptions would have to be dynamic based on the work centre.

I.e If there are 20 work centres we would need 20 charts. 30 work centres 30 charts etc.

Also to add a little more complexity we need to only show a chart if a key figure (Demand Hrs) has a value greater than ZERO.

Would be very grateful and would assign generous points for a solution.

This needs to be done in a BEx workbook.

Thanks in advance,

Steve Jones

BI Consultant