Additional Actions Menu in Excel 2007 Very Slow to appear

[DAC]

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

[DAC]

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

Post by DAC
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

[Ryan Dye]

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

Thanks!

Post by DAC
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

Post by DAC
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
Submitted via EggHeadCafe
OAuth Basics for .NET Developers
http://www.eggheadcafe.com/tutorials/aspnet/16beeea4-4332-4d23-8433-ade0ae6dbcbd/oauth-basics-for-net-developers.aspx

[Ryan Dye]

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

Thanks!

Post by DAC
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

Post by DAC
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

Post by Ryan Dye
Just curious if you ever solved this. I am experiencing the exact same issue.
Thanks!
Submitted via EggHeadCafe
Creating a SharePoint Designer workflow
http://www.eggheadcafe.com/tutorials/aspnet/4b58a093-2c77-4568-81f0-f31feee2704a/creating-a-sharepoint-designer-workflow.aspx