analysis services

I'm relatively new to Power Query in Excel, but I think this is a simple question. My company puts sales information in a large pivot table format and it looks like it's an Analysis Services "cube." Trouble is, Excel has trouble dealing with the data loads, and I'd like to connect to the...

I'm connecting to Analysis Services; I need to represent the data in # and % columns and not sure how to accomplish this. <colgroup><col><col span="2"></colgroup><tbody> System\Region\Location\Appointment Department 7/1/2018 # % Total number of scheduled appointments 100 x% Total...

Hello, Excel world! I've managed to go through basic books about creating charts in Excel. I can say, I even learned some tricks to make reports/dashboards nicer. But browsing though web, I found some really amazing reports done in Excel. Reality-check: need to learn A LOT more to get to that...

I am using Excel 2010 and have a need to visually see all the selections made in the pivot filters. I am using Analysis Services to create a PivotTable. Specifically, I am displaying information by Product Number and would like to have an output next to the pivot that shows the Products...

I have a workbook in which the user connects to SQL Server Analysis Service Cubes. The server is not a part of an Active Directory domain and thus Windows Authentication is not an option. For security reasons storing the password in the excel file is also not an option. The workbook uses a form...

I've been working with SQL Server 2000 AS cubes and presenting them in pivot-tables in Excel 2003 with no problems. I was recently looking at other BI tools I could use and stumbled across the Excel Add-In for Analysis Services, which adds a Cube Analysis menu to Excel and seems to have lots of...