Pivot table on local cube

  • Thread starter Thread starter IgorM
  • Start date Start date
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
 
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
Click to expand...

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.
 
Back
Top