Hello,
I've found a bit of an infuriating nuance in SSAS2005.
My cube used a view called view1. At some point in time the DSV was changed to use a very similar object called view2 instead.
I got a failure when processing the cube. The message was:
Errors in the OLAP storage engine: An error occurred while processing the 'view1' partition of the 'foo' measure group for the 'bar' cube from the foobar database.
In other words...the name of the object in the deployed DSV is still view1. I've looked at the XML and it has a friendly name of view2 (helpful) but the object name in the message above is really really misleading.
- Was this a design decision
- Is it worth bugging
- Should I just stop moaning
Thanks
Jamie
Cannot change naming metadata
gcy80
Try right clicking on the DSV pane in the BI Dev Studio and selecting Refresh.
BI Dev Studio will try to verify if objects in your DSV still exist in relational database. You will get a list of out-of-sync tables, views .This should help you to keep your DSV current.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thomas Jakobsen
Hi Edward,
The problem isn't prevelent in the DSV at design-time - its only when processing. I'm guessing that somewhere under the covers though it is holding onto some misleading aliases - that is what I think it should get rid of.
-Jamie
Frogmancomethagain
If you are getting an error :
"Errors in the OLAP storage engine: An error occurred while processing the 'view1' partition of the 'foo' measure group for the 'bar' cube from the foobar database."
It means that your partition name is 'view1'. Partition is an Analysis Services object holding your data . Parition is not a DSV object. It is part of your cube. At the beginning when you created partition it got assigned a name based on the name of the view.
Your view might be long gone, but your partition still has a name 'view1' you can switch to the partitions tab in the cube editor and change the name for your partition if you'd like.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Oscar Thornell
Edward,
You are spot on. I should have spotted that myself. Doh.
Still feeling my way around but I promise that the daft questions will stop soon :)
-Jamie