Hi
I am facing some problem in my drill through action. It used to work perfectly but no any more. I could not even find what make it not to work L
I've created a cube in SSAS 2005, and have it deployed to my server. I can connect to the cube via Excel 2007, and the pivot table and pivot chart work perfectly. When I try to drill through on a cell to see the detail rows, I get the following error:
"The query did not run, or the database table could not be opened.
Check the database server or contact your database administrator. Make sure the external database is available and hasn't been moved or reorganized, then try the operation again."
I can do the drillthrough OK in Visual Studio in the designer, but Excel fails with the above error
I found a similar post on the following link:
I have even try edit the Excel connection to Analysis Services, and add "Locale Identifier=1033" at the end of the connection string. But it does not work either. I do not know what reason behind it. It used to be working but I have done lot of development after that and now when I test me drill through action it is not working any more.
Please let me if you know any thing about it. I will really appreciate that.
Many thanks