arcanecode

Connecting to SSAS from Report Builder Query Designer – A Connection Cannot Be Made

Introduction Recently I was attempting to create a dataset in the SQL Server Reporting Services Report Portal. I created my data source, then launched Report Builder to create my Dataset. Report Builder connected to my SQL Server Analysis Services Tabular database OK, the Test Connection button worked, but when I tried to go into the query designer I kept getting the error: A connection cannot be made. Ensure that the server is...

arcanecode.wordpress.com arcanecode.wordpress.com

Connecting to SSAS from Report Builder Query Designer – A Connection Cannot Be Made

Introduction Recently I was attempting to create a dataset in the SQL Server Reporting Services Report Portal. I created my data source, then launched Report Builder to create my Dataset. Report Builder connected to my SQL Server Analysis Services Tabular database OK, the Test Connection button worked, but when I tried to go into the query designer I kept getting the error: A connection cannot be made. Ensure that the server is...

arcanecode.wordpress.com arcanecode.wordpress.com

Why Do I Need An SSAS Cube?

A viewer of my Pluralsight courses wrote to me asking what I thought was an excellent question. “What is the advantage of having an SSAS Cube?” or at it’s root, why do we need cubes at all? What do cubes provide that we can’t get directly from the database? It’s an excellent question because understanding why is the foundation for all other learning about cubes. If you know why you are doing something, you’ll better...