I was busy modifying CALUMO's data warehouse today. There was an existing field in a table in SQL Server that I need to make much larger. I changed the table then tried to process the SQL Server Analysis Services (SSAS) cube when I had this error:
Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated. Errors in the OLAP storage engine: An error occurred while the 'Parent5' attribute of the 'Task' dimension from the 'Timesheet' database was being processed.
Thanks to the internet and it's ability to have answers to many things, I was 3 clicks and 2 seconds away from fixing the problem. BIDS Helper is the tool I needed and I already have that installed. If you haven't got BIDS Helper installed you should. Get it here: http://bidshelper.codeplex.com/.
How did it fix my issue?
1. I right clicked on Dimensions in the Solution Explorer.
I was then presented with a screen like this:
2. I made sure I had everything checked (the default) and hit OK.
3. I was finished!
I reprocessed the cube and it worked!
The other thing BIDS helper helps me with is deploying MDX Scripts or calculations without the need to reprocess the cube. SQL 2005 had issues with this when you had write back partitions i.e. you could only deploy about twice before you received errors in your reports and input templates. I think SQL 2005 changed the indexing or field association incorrectly.
Back to my point. The Deploy MDX Script button saves me so much time. If for only this feature I would suggest you download it.
These are just two awesome things BIDS Helper helps with to deliver reporting, budget, forecasting, planning business intelligence (BI) and business performance management (BPM) systems.
How does BIDS Helper help you?