One of the servers can’t see it’s own cubes. As a work-around you can Right-Click on the SSMS icon and select > Run as Administrator to get SSMS to see it’s own cubes: If you skip step in the setup where it asked you to add current user to AS server admin role, then you would need to run SSMS as administrator.
Posts under ‘SSAS 2008’
4 Gig limit in SSAS 2008 Dimension Processing
*Please note that this post is a work in progress and I’m still waiting on more answers but I wanted to get the information out there in case anyone else is running into this issue too: OK that title might be a little bit over the top for what I’m dealing with but if you [...]
Migrating to SSAS cubes error
Earlier this week I got the chance to do some SSAS work for the first time in a long time which made me very happy. My task was to migrate some cubes from Analysis Services 2000 to SSAS 2008. I was given a new Windows 2008 R2 Server with SQL Server 2008 SP1 (Slipstream installed) [...]
