Actions using OWC Pivot Table and OLAP

[Don Pfister]

Not sure if this is an OWC issue or more of an Analysis
Services issue.

I have an Analysis Services application front-ended by
a .Net application using the OWC 10 pivot table to run our
queries. We have several cubes where the only visible
measures are calculated measures. We would like to
offer "drill-through" functionality. Since regular drill-
through doesn't work because of the calculated measures
I've been working on implementing drill-through via
actions.

I'm using MDX expressions like
item_date.currentmember.name
(dimension.currentmember.name) to get the specifics on the
cell that is clicked and pass the dimension data to my
relational query. Where I'm having problem is when the
action is clicked from within Cube
Editor "currentmember.name" returns the current member's
name as expected (e.g. 6/8/2003). When I perform the same
operation in the OWC pivot table it always returns the
dimension's all level (e.g. All Dates).

Does OWC fully support actions?

Is there an issue with my MDX?

This action targets cells. Actions at other levels seem
to be OK. I can't seem to find a lot of documentation on
actions and even less on actions implemented at the cell
level or through OWC.

 

[Wei-Dong Xu [MSFT]]

Hi Don,

Thank you for posting in MSDN managed newsgroup!

Based on my experience, I'd suggest you can download the Office OWC tool kit for obtaining more information regarding the action. In the left panel
of tool kit, you can find one "Action" link which contain the demonstration and sample codes for you. This tool kit will provide the direction for you
concerning the usage of action from OWC. Please go to:
Microsoft Office XP Web Component Toolpack
http://www.microsoft.com/downloads/...77-2100-4586-a13c-50e56f101720&displaylang=en

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Richard Erasmus]

Hi Don,

I am having the same issues when using actions at cell
level. Have you managed to find a solution yet?