MS SQL Server OLAP - "Action" in Excel Add-in greyed out on non-data cell

Author

"Action" in Excel Add-in greyed out on non-data cell

bhorwatt

2006-03-30, 8:27 pm

I implemented the url action referenced in Teo Lachev's AMAS 2005 book to
pass an address from the cube to a map website and pull up a map to the
customers house when right clicking the customer name member. This worked
great in the cube browser in Analysis Services.

Since that excellent, fully functional cube browser is non-distributable, I
tried to attempt the same in the SP1 version of the Excel add-in, 1.5.0166.0,
and found the action is greyed out on a member cell and is only available if
you right click on a data cell. That doesn't work for my action. Is there
some reason why an excel based browser cannot be as fully functional as the
browser in Analysis Services?

bhorwatt

2006-03-31, 8:26 pm

I tried this again after reading in the notes that if the Action menu was
disabled, then there was no corresponding acting on that cell. I found out I
was connecting to a perspective in which I did not include that action. I
tried it again with the primary perspective and it worked as designed.

"bhorwatt" wrote:

> I implemented the url action referenced in Teo Lachev's AMAS 2005 book to
> pass an address from the cube to a map website and pull up a map to the
> customers house when right clicking the customer name member. This worked
> great in the cube browser in Analysis Services.
>
> Since that excellent, fully functional cube browser is non-distributable, I
> tried to attempt the same in the SP1 version of the Excel add-in, 1.5.0166.0,
> and found the action is greyed out on a member cell and is only available if
> you right click on a data cell. That doesn't work for my action. Is there
> some reason why an excel based browser cannot be as fully functional as the
> browser in Analysis Services?

Sponsored Links