3
Vote

SSASPartitions function performance

description

Despite asking for one cube partition, SSASPartitions function allways retrieve internally all partitions from all cubes from the catalog parameter. As CLR function does not support overloaded methods so as to accept optional parameters,the only way I see is setting optional parameters in the SQL Server Table function.
Don't tried yet if it is compatible with deployment from Visual Studio.

comments