content-align-flex-start ">

SQL Server

SSAS

SQL Server Analysis Services References

Detailed Descriptions of each of the built in Data Mining Algorithmshttps://docs.microsoft.com/en-us/analysis-services/data-mining/data-mining-algorithms-analysis-services-data-mining Creating and Managing SubCubesSubCubes only exist for the duration of a session/connection so use for context not securityhttps://docs.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/building-subcubes-in-mdx-mdx Cube Securityhttps://www.mssqltips.com/sqlservertip/2776/configuring-permissions-for-sql-server-analysis-services/Measure and Dimension Security (14:30) https://www.youtube.com/watch?v=NlNw3wYbh8E

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

This is an error that you get when you try to view the built-in reports in SQL Server 2008 when the database compatibility is set to anything less than 2005(90). To fix this and make the built-in reports work: Right click on the database Select properties On the options tab change the compatibility level to …

Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Read More »

%d bloggers like this: