Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Excel Cube contextual menu - Checkboxes missing!

Author  Topic 

clir
Starting Member

6 Posts

Posted - 2006-04-12 : 11:37:17
Hi,
i am using sql server 2005 + analysis services.
I have processed cubes.
I want to work on them through MS Excel. I have installed the MS add-in called 'Cube Analysis' which enable to use the cube features within MS Excel. http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

It works fine excepted one issue I am encountering:
On a row or column heqder, when I click on it, a popup window appears with the possible values. That's good but there's no checkbox against each item! This is a major issue because I want to be able to select only a few of the items.
Note: we have checkboxes with the Pivot Table contextual menu.

Any help much appreciated.

Chris
   

- Advertisement -