Management FAQ After processing SSAS cube I get error: Server error : Process error [object doesn't exist]
| After processing SSAS cube I get error: Server error : Process error [object doesn't exist] |
| Written by Vidas Matelis | |||
| Monday, 02 April 2007 19:37 | |||
|
Q: After processing my cubes I have this error: Server error : Process error [object doesn't exist] A: Try to do this - go to Business Intelligence development studio, open your data source view and then on the diagram do right mouse click choose option "Refresh...". This will tell you what changes are between what you have in SSAS and what is really in database. It looks like one of your dimensions or measure groups is referencing table that does not exists in source database. By refreshing source database you will force Analysis Services check for changes and they will be reported to you. After accepting changes that Microsoft SQL Server Analysis Services reported, you will have to fix affected dimensions or measures for this problem to go away.
|
Most read
- How to install Adventure Works SQL DW and Analysis Services 2005 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
- MDX-How do you format or round KPI expression value?
- MDX-How do you calculate monthly average of one year, optionally including empty months?
Top Rated
- How to install Adventure Works SQL DW and Analysis Services 2005 sample database and project
- Analysis Services 2005 XMLA script to add/drop existing partition aggregate
- Why In Reporting Services MDX query disappears after leaving "Data" tab.
- When accessing calculation tab in BIDS I am getting error Unexpected error occurred
- In an MDX query how can I get the top 3 sales years based on the order quantity?
- What TCP port SQL Server Analysis Services 2005 uses
- How to calculate YTD monthly average and compare it over several years for the same selected month
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
