Pivot table on local cube

[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

 

[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.