Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manidreamz
Starting Member
3 Posts |
 Posted - 2011-06-28 : 03:40:44
|
| Hi,I'm facing a issue in SSAS, We have about 5 cubes in Analysis service, I'm able to browse all the 5 cube as user 'A', When I change the user to 'B' Im not able to browse one particular cube alone and I'm getting following error"The query could not be processed The data provider didn't supply any further error information". Same user B can browse all 5 cube in Development environment but not in Prod environment. We are not able to trace the issue as we are able to browse as User A.We tried taking a backup of prod database and deployed in dev environment, even then User B is not able to browse. What might br the issue in database?Can anyone suggest a solution for this error.Thanks in advance.-Subbu |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-06-28 : 03:43:30
|
Seems like a permission error? Have you checked security?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
manidreamz
Starting Member
3 Posts |
Posted - 2011-06-28 : 03:50:17
|
| Hi Peso,I have given all permissions for that user thr roles. I'm not getting which security you are telling about. Please can you mention it. Thanks |
|
|
|
|
|
|
Not able to browse cube by particular user