Additional Actions Menu in Excel 2007 Very Slow to appear

#11

Just curious if you ever solved this. I am experiencing the exact same issue.

Thanks!

Quote:

On Friday, March 21, 2008 4:46 AM DA wrote:

I have a cube that I am accessing from an Excel 2007 pivot table. It is
performing well and most pivot table manipulations refresh in a couple of
seconds.

The problem I have is that I have defined a reporting action with a target
type of 'Cells' and a target object of 'All Cells' that I want to appear
under Additional Actions when the user right clicks a cell in the Excel Pivot
table. It works but it takes an eternity (up to 30 seconds plus at times)
for the additional options to appear on the Excel menu when I right click and
select Additional Options.

Originally I had a condition attached to the action and I thought this might
be the issue but I tried both with and without it and it makes no difference.
The report has five parameters that it picks up as Member_keys from 3
dimensions.

To confirm my design was okay I also tested from ProClarity desktop and even
with the cell selection condition in place the Action appears on the right
click menu immediately (less than a second). The issue appears to be
related exclusively to Excel 2007.

Anyone seen this behaviour or can give me any guidance what to look for to
try to improve performance as almost all of my user base are using Excel
2007? Thanks for any help

Quote:

On Thursday, April 03, 2008 8:58 AM DA wrote:

Still struggling with this problem if anyone can help??

I did fnd out something additional during my investigation. If the Pivot
table does not have any Page or Report level filters, the Additional Actions
appear immediately on a Right-click. It is only when I add Report
Level/Page filters to the Pivot Table that the problem occurs. Doesn???t
really help the end user much because virtually every Pivot Table they have
has Page Filters

"DAC" wrote:

Quote:

Submitted via EggHeadCafe
OAuth Basics for .NET Developers
http://www.eggheadcafe.com/tutorials...evelopers.aspx

#12

Just curious if you ever solved this issue? I am experiencing the exact same behaviour.

Thanks!

Quote:

On Friday, March 21, 2008 4:46 AM DA wrote:

I have a cube that I am accessing from an Excel 2007 pivot table. It is
performing well and most pivot table manipulations refresh in a couple of
seconds.

The problem I have is that I have defined a reporting action with a target
type of 'Cells' and a target object of 'All Cells' that I want to appear
under Additional Actions when the user right clicks a cell in the Excel Pivot
table. It works but it takes an eternity (up to 30 seconds plus at times)
for the additional options to appear on the Excel menu when I right click and
select Additional Options.

Originally I had a condition attached to the action and I thought this might
be the issue but I tried both with and without it and it makes no difference.
The report has five parameters that it picks up as Member_keys from 3
dimensions.

To confirm my design was okay I also tested from ProClarity desktop and even
with the cell selection condition in place the Action appears on the right
click menu immediately (less than a second). The issue appears to be
related exclusively to Excel 2007.

Anyone seen this behaviour or can give me any guidance what to look for to
try to improve performance as almost all of my user base are using Excel
2007? Thanks for any help

Quote:

On Thursday, April 03, 2008 8:58 AM DA wrote:

Still struggling with this problem if anyone can help??

I did fnd out something additional during my investigation. If the Pivot
table does not have any Page or Report level filters, the Additional Actions
appear immediately on a Right-click. It is only when I add Report
Level/Page filters to the Pivot Table that the problem occurs. Doesn???t
really help the end user much because virtually every Pivot Table they have
has Page Filters

"DAC" wrote:

Quote:

On Wednesday, December 01, 2010 12:08 PM Ryan Dye wrote:

Just curious if you ever solved this. I am experiencing the exact same issue.

Thanks!

Quote:

Submitted via EggHeadCafe
Creating a SharePoint Designer workflow
http://www.eggheadcafe.com/tutorials...-workflow.aspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Additional Actions Menu in Excel 2007 Very Slow to appear

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Still struggling with this problem if anyone can help?? - 12-01-2010 , 11:08 AM

Re: Still struggling with this problem if anyone can help?? - 12-01-2010 , 11:10 AM