#How to use data analysis in excel 2008 full

Wednesday, 10:29:26 AM - Daniel Calbimonte Thanks, for some reason i deleted the dimension and recreated the dimension and added it to the actions and now i can see the data in the excel as well. Is there anything in excel or add on to accomplish this? In other word, I want to email out an excel report with two columns (Internet Average Sales amount and Internet Average Unit Price) in it to other people but I don't want recepicients to have connection to the SSAS or have a office cube data file sitting somewhere on their local machine. Is it possible to share only the 'view' of the excel report without the SSAS connection? (disclaimer: yes, I work for DevScope very closely to SmartPivot team ) ) You can check my blog here for more info /

#How to use data analysis in excel 2008 full

Lots of extra features, including full instant search, saved filters,faster table reports & several others. Have to mention our addon for Excel, Analysis Services/PowerPivot: SmartPivot. Also a big fan of Olap Pivot table extensions :) recomend that! Very good overview on Excel, OLAP & Analysis Services. And in ssms, its connecting to Analysis services (local). 'UNABLE TO CONNECT TO DATA SOURCE.REASON: UNABLE TO LOCATE DATABASE SERVER.VERIFY THE DATABASE SERVER NAMEYOU ENTERED IS CORRECT,OR CONTACT THE DATABASE ADMIN FOR HELP'Īfter this error, nothing is happening. , and selecting windows authentication, its showing an error, which says Please check this link:Īfter writing the server name as. How can find my servername? or what is wrong ? Could you please help me