| Author |
Topic |
|
Kirun
Yak Posting Veteran
60 Posts |
 Posted - 2007-08-13 : 08:34:29
|
| Lets say i have one analysis server project on server A . I have made an excel sheet on desktop B in which i have inserted a pivot table which datasource is Server A's cube . I then have save this worksheet as webpage and save it on Server A. When i run this webpage on server A its working fine with but as soon as when i run this webpage on other PC it give me the error "The query could not be processed:The data provider didn't supply any further error information."what could be the reason .. Please help me i am going mad.... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 22:29:51
|
| Did you login windows with same account on those machines? |
 |
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2007-08-16 : 02:45:10
|
| no i want that page to dipslayed to all users in my intranet .. so they will be login with their own windows ID . Is this is due to imporsonation information in Visual Studio? as when i process the cube with the "Use credientials of current user" then cube is not processd . i have tried others imporsonation information options as well but i think i am not getting the webpage work.. Does i have to make the webpage again and again every time i change the imporsonation information or its a problem of OWC ? Also let me know any other alternative where we can display information of cubes in webpages .. thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-16 : 23:12:21
|
| Do they have proper permission to access cube? |
|
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2007-08-20 : 05:07:44
|
| yes they have the permision to view cubes . i hope you are talking about the permissions that we set in visual studio analysis server peroject |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 22:33:33
|
| No, I'm taking about permission to access AS. |
|
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2007-08-30 : 03:28:37
|
| I think there is some other problem that i have faced right now .. when i logged from my account to another computer.It gave me the same error "The query could not be processed:The data provider didn't supply any further error information."I installed OWC11.exe there ,and also install SQL Server pivot table service but to no use.. what could be the reason.. I also copy the microsfot excel OLAP query file(oqy) to the server and then make the pivot table from the server oqy file but to no use .. i am stuck in this .. please help me to find a way aor may be an alternate way :( sad Kirun |
|
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2007-08-30 : 03:33:16
|
 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 21:48:13
|
| Tried install AS client on it? |
|
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2007-08-31 : 01:55:50
|
| from where i should get it -- i have googled but couldnt find one |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 15:28:25
|
| It's part of AS installation program. |
|
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2007-09-03 : 06:48:26
|
| just plain AS client on the cliewnt machine -- no server nothing am i getting it right |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 12:57:07
|
| That's right. |
|
|
|
|
OLAP cube in excel worksheet