Pivot table on local cube


I

IgorM

Hi

I have a pivottable that retreives some data from an Access database. When I
double click some value in the pivottable Excel adds a sheet with all the
data that concerns the value clicked.
I also built a local cube using the same query that was used in the
abovementioned pivottable. Unfortunately when I double-click some value in
this pivottable a get a message that Excel cannot show details because this
feature was disabled for this cube on a server. Is it possible to get this
functionality with pivottable built from local cubes?

Kind regards
IgorM
 
Ad

Advertisements

D

David Heaton

Hi

I have a pivottable that retreives some data from an Access database. When I
double click some value in the pivottable Excel adds a sheet with all the
data that concerns the value clicked.
I also built a local cube using the same query that was used in the
abovementioned pivottable. Unfortunately when I double-click some value in
this pivottable a get a message that Excel cannot show details because this
feature was disabled for this cube on a server. Is it possible to get this
functionality with pivottable built from local cubes?

Kind regards
IgorM

I believe there is an option with SQL Server that allows user to drill
to details, but most of the time this is disabled due to performance
issues.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top