i used to connect the off line cube to the excel pivot table. However,
recently my attempt to connect the offline cube to the excel pivot failed.
The error message is

"Excel cannot find olap cube DSCLocal. Either the olap database has been
changed or you don't have permissions to connect to the cube."

Sometimes, i also encountered the offline cube has the data but in can't be
retrieved from the excel pivot table. What could have gone wrong.

Hope someone can help. Thanks a lot!!