<div>
I cannot find the reference, but I believe it is the SQL Server that is only feeding Excel the data accessible by the provided credentials. &nbsp;Excel is merely displaying the data it is allowed to see.
</div>


I cannot find the reference, but I believe it is the SQL Server that is only feeding Excel the data accessible by the provided credentials.  Excel is merely displaying the data it is allowed to see.

<div>
Agreed. I just don't know what. <br />
<br />
From what I can deduce Each User in a user dimension table has the company level windows login column and it is set on each dimension in the CubePermissions section.<br />
<br />
But i'm missing a piece to the puzzle. I think it has something to do with roles but its not clear.
</div>


Agreed. I just don't know what.

From what I can deduce Each User in a user dimension table has the company level windows login column and it is set on each dimension in the CubePermissions section.

But i'm missing a piece to the puzzle. I think it has something to do with roles but its not clear.

<div>
<div class="content wysiwyg-content">
While using SSAS 2016 I have inherited a Multi-Tenant Cube.<br />
<br />
This cube contains data across all companies.<br />
<br />
How ever when you access the cube via excel using an assigned company level windows login that exists on the user dimension...its smart enough to only bring back data for that company.<br />
<br />
My question is where does that logic exist that makes Excel smart? How does it know? We have no proxy site set up yet. Just a site where the mspump sits.
</div>
</div>


While using SSAS 2016 I have inherited a Multi-Tenant Cube.

This cube contains data across all companies.

How ever when you access the cube via excel using an assigned company level windows login that exists on the user dimension...its smart enough to only bring back data for that company.

My question is where does that logic exist that makes Excel smart? How does it know? We have no proxy site set up yet. Just a site where the mspump sits.

How does Excel know to only bring back one company's data for a multi-tenant cube?

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.

SSAS

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.