dbTalk Databases Forums  

Issue with Excel Add-in for Analysis Services

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Issue with Excel Add-in for Analysis Services in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
guy.mounier@ba-insight.net
 
Posts: n/a

Default Issue with Excel Add-in for Analysis Services - 01-18-2006 , 07:42 PM






Hello,

I am using the Excel Add-in for Analysis Services against a SSAS 2005
cube. The data in my free form report does not refresh properly
whenever I collapse or expand a row or column member. Any suggestions?

Thanks.

Guy


Reply With Quote
  #2  
Old   
alanr
 
Posts: n/a

Default Re: Issue with Excel Add-in for Analysis Services - 01-19-2006 , 10:02 AM






There is a new version of excel add-in that came in the last few months

What version are you using?

guy.mounier (AT) ba-insight (DOT) net wrote:
Quote:
Hello,

I am using the Excel Add-in for Analysis Services against a SSAS 2005
cube. The data in my free form report does not refresh properly
whenever I collapse or expand a row or column member. Any suggestions?

Thanks.

Guy


Reply With Quote
  #3  
Old   
guy.mounier@ba-insight.net
 
Posts: n/a

Default Re: Issue with Excel Add-in for Analysis Services - 01-19-2006 , 02:35 PM



I am using the latest version, 1.5.0166.0

Are you experiencing this kind of issue when collapsing/expanding a
free form row or column member?


Reply With Quote
  #4  
Old   
sarah aldridge
 
Posts: n/a

Default Re: Issue with Excel Add-in for Analysis Services - 01-23-2006 , 08:25 AM



Hi,

I too am having issues with the excel cube analysis addin and the dimension
drill down.

I have a dimension hierarchy with hidememberif same as parent set.

but when trying to expand and collapse the dimensions in the build report
window or pivot table it does not expand the levels properly

has anyone else had any issues like this





"guy.mounier (AT) ba-insight (DOT) net" wrote:

Quote:
I am using the latest version, 1.5.0166.0

Are you experiencing this kind of issue when collapsing/expanding a
free form row or column member?



Reply With Quote
  #5  
Old   
Mike Honey
 
Posts: n/a

Default Re: Issue with Excel Add-in for Analysis Services - 02-01-2006 , 08:36 PM



I am having issues just with the Collapse command - it is always disabled
(greyed-out). This happens no matter what structure of dimension is in use.
Environment is Excel 2003 SP2, Addin 1.5.0166.0, SQL 2005.

Can anyone assist?
Thanks
Mike

"sarah aldridge" wrote:

Quote:
Hi,

I too am having issues with the excel cube analysis addin and the dimension
drill down.

I have a dimension hierarchy with hidememberif same as parent set.

but when trying to expand and collapse the dimensions in the build report
window or pivot table it does not expand the levels properly

has anyone else had any issues like this





"guy.mounier (AT) ba-insight (DOT) net" wrote:

I am using the latest version, 1.5.0166.0

Are you experiencing this kind of issue when collapsing/expanding a
free form row or column member?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.