I know it's in the excel add in but how about code against the normal excel
pivot (not owc).

see the following ms article...

http://msdn.microsoft.com/sql/sqlwar...extendolap.asp


Michael Vardinghus wrote:

Thanx for the tip

Had seen that one but cannot see activating OLAP actions specifically (they
can be activated from differnet locations in the pivottable - from cells,
dimensions etc.)

Perhaps some of the code regarding the other areas could be used for that -
but I'm not (yet) qualified to conclude this...

"RuiDC" <rui.dacosta (AT) ubs (DOT) com> wrote

I'm not sure i understand your question, perhaps if you can rephrase
it, i might be able to help.

Are you perhaps just interested in listing what actions exist in a
cube?
If so, then you could use DSO, but that does not give you the ability
to execute the action.

I want action support on the target's specified in the cube.

In the excel add in you can for instance right click on cells and then
you'll see actions with cell-level as targit. If I click a dimension I
expect to see actions that has the dimension member as target and so
forth...

i want to see the action on a right click menu and choose the action to do
something completely differnt than pivoting...

"RuiDC" <rui.dacosta (AT) ubs (DOT) com> wrote