Some time ago I run into following problem with Production Manager Role Center. One of the reporting services report - Capacity load nect 30 days (hours) raised error:

Error while executing query for WIPLevel-Dataset.
The [WIP Level]-element could not be found in the cube while analyzing the string ‘[Measure].[WIP Level].
The value expression for the query object ‘prodUnitId’ contains an error:  the index is out of array size.
Here problem is quite easy.

After long troubleshooting we found out that this reports worked fine for environments were multi site functionality was on. Basically we missed some data in tables, what makes report not working. To workaround this problem you can:

1.      Add one record to InventSite table
2.      Add one record to ProdUnitTable where ParentSiteId is connected with record created in step 1
3.       Update table WrkCenterTable (field ProdUnitId for work center groups set up to record created in step 2)
4.      Process cubes

--author: Czesława Langowska
--editor: Czesława Langowska
--date: 06-12-2010