Hi guys,
We are building a resourcing solutions which looks at exceptions between Timesheet data and Resourcing data, ie. the resourcing team want to be able to see that the time logged by consultants matches what is was planned by resourcing.
The WebI report is being built on top of BPC10.0 using a BPC planning model. Within the planning model the timesheet data and resourcing data will be stored as versions. We are able to build a WebI report from a BEx query on top of this model, but we are struggling with presenting the data as requested. Within the report resourcing want to be able to see the resourcing data and the timesheet data. What we want to do is compare the timesheet and resourcing versions, blank out any cells for dates where there are no exceptions, and remove any consultants who have no exceptions at all that week.
An example of this would be:
-
4th 5th 6th 7th 8th
Consultant A Res 1 1 1 0 0
-
Time 1 1 1 0 0
Consultant B Res 1 0 0 1 1
-
Time 0 0 1 1 1
So in this case we would want to completely hide the data for consultant A and show the data for consultant B in this format:
-
4th 5th 6th 7th 8th
Consultant B Res 1 x 0 x x
-
Time 0 x 1 x x
Where x donates a blank cell.
The problem we have with the filters and conditions we have currently been working with is that either we are able to only blank out cells with no exceptions, or to completely remove any day with out exceptions (ie we would only see the dates the 4th and 6th displayed. We need to keep the week structure there so that the view is intuitive to the User). Neither of the "solutions" we are working on has the full functionality that we need and we can't find the middle ground.
I have searched the SDN for similar issues but haven't been able to find anything that really matches up to this. Apologies if I have missed a similar thread and am covering old ground, but any help would be greatly appreciated. Does anyone have a solution for these issues?
Many thanks,
Mike
Edited by: Michael Cowan on Jan 11, 2012 11:40 AM