Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how to set up a cube for pivot table service in Excel?

0 views
Skip to first unread message

=== Steve L ===

unread,
Jan 31, 2005, 4:05:52 PM1/31/05
to
background: sql2k and analysis service

I know how to create a cube in analysis service, but how to view the
cube in the Pivot Table services in Excel?
when I go to Data|PivotTable and PivotChart report...|External Data
Source|
Get Data | OLAP cube, then browse to the server, but I don't see any of
the cubes being created.

I'm using Standard SQL2k. Is this a sql version issue or should i
create cube differently?

thank you

Mike John

unread,
Jan 31, 2005, 4:17:26 PM1/31/05
to
Have you set permissions on the cube to allow access from the user running
Excel?
Under Database Roles in Analysis manager.

Standard version includes analysis services, with EE having increased
features in some areas, so I do not think that is your problem.

Mike John

"=== Steve L ===" <stev...@powells.com> wrote in message
news:1107205552....@f14g2000cwb.googlegroups.com...

=== Steve L ===

unread,
Jan 31, 2005, 7:01:00 PM1/31/05
to
i'm very lost...:(
i created a cube on the analysis service then add my nt accout to the
All Users database role. (enforced on client).
i then go thru the steps in Excell, Data|PivotTable and PivotChart
report...|External Data Source|
Get Data | OLAP cube, but then where shoudl browse to from there?

i check the book online about the local cube. it was not helping. i
still dont' know how to create a local cube.

Mike John

unread,
Feb 1, 2005, 4:29:14 PM2/1/05
to
Steve, it is difficult to follow your description, but Local cube has
nothing to do with connecting to an analysis services cube.

After you select olap cube you should be able to select thser server and
database that contains the cube.

Mike John


"=== Steve L ===" <stev...@powells.com> wrote in message

news:1107212127.3...@f14g2000cwb.googlegroups.com...

=== Steve L ===

unread,
Feb 1, 2005, 5:59:26 PM2/1/05
to
...After you select olap cube you should be able to select thser server
and
database that contains the cube...
which i did but i couldnt' find any cubes on the sql server running
analysis services thru Excel pivot table services. i can see cubes in
the analsysis services itself, but even when i search the sql server
with analysis services on it, i couldn't find any file with extension
.cub

also, i looked up the help files for excel:
In the PivotTable report, the Offline OLAP command on the PivotTable
menu (PivotTable toolbar (toolbar: A bar with buttons and options that
you use to carry out commands. To display a toolbar, click Customize on
the Tools menu, and then click the Toolbars tab.)) is unavailable if
the provider does not support offline cube files.
in my excel, the Offline OLAP menu is always greyed out. why?

=== Steve L ===

unread,
Feb 1, 2005, 6:01:52 PM2/1/05
to
...After you select olap cube you should be able to select thser server
and

=== Steve L ===

unread,
Feb 1, 2005, 6:05:36 PM2/1/05
to
...After you select olap cube you should be able to select thser server
and

=== Steve L ===

unread,
Feb 1, 2005, 6:06:49 PM2/1/05
to
...After you select olap cube you should be able to select thser server
and

=== Steve L ===

unread,
Feb 1, 2005, 6:07:34 PM2/1/05
to
...After you select olap cube you should be able to select thser server
and
0 new messages