I have processed my cube successfully, and can browse it just fine from SSAS, but when trying to execute a MDX query against the cube in SSAS it returns #Error. Any idea what I have to do? – I’m using SQL Server 2005 – I have two cubes in one SSAS project – and only one of those two cubes have this problem.
Any help is appreciated. Thanks.