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 |
|
SQLboom
Yak Posting Veteran
63 Posts |
 Posted - 2003-12-11 : 04:52:58
|
| Hi, I am trying to connect MS Excel to the SQL SERVER 2000's Cube using the Pivot Table and Pivot Chart Wizard. There are five cubes in my SQL SERVER Analysis server's database but when I am connecting it to Pivot Table then it is showing me only 1 cube out of these 5 cubes. Out of these 5 cubes there are 2 virtual cubes and all the cubes are stored as MOLAP. Can somebody help me to find out why Pivot Table Wizard is not showing me remaining 4 cubes.Thanks |
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-11 : 08:09:41
|
| A couple of things to check:1) Are all the cubes processed? Unprocessed cubes don't show up in Excel.2) Did you give the user permission in the Cube Roles for the other cubes? Remember that the cube roles have to be explicitly applied to each cube and granted to each user.--Timothy Chen Allenemail me if you have a job in New Orleans for me[url]http://www.timallen.org[/url] |
 |
|
|
SQLboom
Yak Posting Veteran
63 Posts |
Posted - 2003-12-11 : 22:38:17
|
| HiI did check that all the cubes are processed. Now, when we are connecting the Excel to SQL SERVER Analysis Manager's cube using the Pivot table then the Pivot table wizard is not showing all the cubes but we are able to connect to all the cubes through VB(Using ADO MD).Could anyone help me to find out why this is happening.I believe this is not a case of access rights on cube as if a user cannot have proper access rights on a cube then he cannot connect to that cube using any application.Thanks in Advance |
|
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-15 : 17:24:03
|
| Does this happen on all clients? Have you installed the PTSFull.exe from Service Pack 3a on the clients? Are you using the driver version 8.0 when you connect from Excel?You're right about the access rights. If they don't have rights to the cube, they shouldn't see them in VB either.--Timothy Chen Allenemail me if you have a job in New Orleans for me[url]http://www.timallen.org[/url] |
|
|
|
SQLboom
Yak Posting Veteran
63 Posts |
Posted - 2003-12-19 : 00:03:57
|
| Yes... got it. .. .driver version 8.0 was the problem as you tracked. . . it's showing all the cubes now. . .Thanks a lot |
|
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-19 : 12:06:48
|
quote:
Originally posted by SQLboom
Yes... got it. .. .driver version 8.0 was the problem as you tracked. . . it's showing all the cubes now. . .Thanks a lot
 Glad to hear it. We had the same thing happen. Be sure the PTSFull.exe from the service pack is installed on the client, too-- we had a lot of performance problems because some of our clients didn't have it.--Timothy Chen Allenemail me if you have a job in New Orleans for me[url]http://www.timallen.org[/url] |
|
|
|
|
|
|
Excel Not showing all Cubes for selection