C
Christina
Hello,
We use Excel Pivot table as the front-end tool to display
our OLAP Cube. On our Production server, we also set the
security for Excel so when users enters the Pivot table,
they would have to logon (using NT security).
It works fine if I only have one worksheet pointing to the
OLAP Cube. However, if I create another worksheet
pointing to the same Cube (same data source) or a
different Cube, the logon box pops up every 10-15 seconds,
non stop and then Excel hangs.
Is there a way around this? How can I create 2 worksheets
pointing to 2 different Cubes or the same Cube without
having the logon box popping up constantly?
Any help is greatly appreciated. Thank you in advance.
Regards,
Christina.
We use Excel Pivot table as the front-end tool to display
our OLAP Cube. On our Production server, we also set the
security for Excel so when users enters the Pivot table,
they would have to logon (using NT security).
It works fine if I only have one worksheet pointing to the
OLAP Cube. However, if I create another worksheet
pointing to the same Cube (same data source) or a
different Cube, the logon box pops up every 10-15 seconds,
non stop and then Excel hangs.
Is there a way around this? How can I create 2 worksheets
pointing to 2 different Cubes or the same Cube without
having the logon box popping up constantly?
Any help is greatly appreciated. Thank you in advance.
Regards,
Christina.