chrishuffman5/analytics-ssas-2025
skills/analytics/ssas/2025/SKILL.md
Version-specific expert for SQL Server Analysis Services 2025 (compatibility level 1700). Covers Horizontal Fusion, selection expressions, enhanced DirectQuery parallelism, LINEST/LINESTX, binary XML, and improved diagnostics. WHEN: "SSAS 2025", "SQL Server 2025 Analysis Services", "compatibility level 1700", "Horizontal Fusion", "selection expressions", "LINEST", "LINESTX".
$ install --global
skillsauthnpx skillsauth add chrishuffman5/domain-expert analytics-ssas-2025Install this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 26, 2026, 4:30 AM21.9s1 file scanned
SKILL.md
- name:
- analytics-ssas-2025
- description:
- Version-specific expert for SQL Server Analysis Services 2025 (compatibility level 1700). Covers Horizontal Fusion, selection expressions, enhanced DirectQuery parallelism, LINEST/LINESTX, binary XML, and improved diagnostics. WHEN: \"SSAS 2025\", \"SQL Server 2025 Analysis Services\", \"compatibility level 1700\", \"Horizontal Fusion\", \"selection expressions\", \"LINEST\", \"LINESTX\".
- license:
- MIT
- version:
- 1.0.0
- author:
- christopher huffman
SSAS 2025 Version Expert
You are a specialist in SQL Server 2025 Analysis Services, compatibility level 1700.
For foundational SSAS knowledge (VertiPaq, DAX fundamentals, processing, security), refer to the parent technology agent. This agent focuses on what is new or changed in SSAS 2025.
Key Features
Horizontal Fusion
Reduces the number of SQL queries generated by DAX in DirectQuery mode.
- DAX queries that previously generated multiple independent SQL queries against the source are now fused into fewer queries
- Fewer round-trips to the source database means faster overall query execution
- Builds on the parallel DirectQuery introduced in SSAS 2022 -- even with parallelism, fewer queries is better
- Most impactful for complex reports with many visuals hitting DirectQuery tables
- No configuration required -- the engine applies Horizontal Fusion automatically at compatibility level 1700
Enhanced DirectQuery Parallelism
Further improvements to parallel DirectQuery (building on SSAS 2022):
- Parallelizes multiple queries to the data source for a single DAX query
- Better handling of data source delays and network latency
- Combined with Horizontal Fusion: fewer queries, each running in parallel, for maximum throughput
MDX + Calculation Groups Performance
Significant performance improvements for MDX queries on models that use calculation groups and format strings.
- Reduced memory usage for these query patterns
- Improved responsiveness
- Benefits organizations using calculation groups (SSAS 2019+) with MDX-based reporting tools (Excel PivotTables, SSRS)
Selection Expressions
Extends the calculation groups feature (introduced in SSAS 2019) with finer-grained control:
- Selection expressions provide control over calculation behavior when multiple calculation items are selected simultaneously
- No-selection behavior defines logic for when no specific selection is made on a calculation group
- Enables more sophisticated calculation group patterns without workaround DAX measures
- Requires compatibility level 1700
Independent Value Filters
New option to control value filter behavior in the engine:
- Prevents automatic combining (coalescing) of multiple filters on the same table into a single filter
- Provides greater flexibility for precise, independent filtering in complex models
- Addresses edge cases where coalesced filters produced unexpected results
DAX Language Enhancements
LINEST and LINESTX:
- Perform linear regression using the Least Squares method
- Calculate the straight line that best fits given data points
- Enables statistical analysis directly within DAX without external tools
- LINEST returns a single row; LINESTX is the iterator version for row-by-row calculation
Unicode Surrogate Pair Support:
- Support for expanded Unicode standards including Chinese GB18030 government standard
- Ensures correct handling of supplementary Unicode characters in DAX string operations
Binary XML + Compression
XMLA-based communication improvements:
- Switched from plain text XML to binary XML for XMLA communication
- Compression enabled for .NET client libraries
- Reduces network overhead and improves response times for large result sets
- Transparent to applications -- no code changes required; update client libraries to benefit
Diagnostics Improvements
Execution metrics now exposed through Extended Events and Profiler traces:
- Query execution metrics available via XEvents for detailed performance analysis
- Better visibility into query execution plans and resource consumption
- Enables more precise troubleshooting compared to prior versions
Migration from SSAS 2022
- Upgrade the SSAS instance to SQL Server 2025
- Set model compatibility level to 1700 in Visual Studio or Tabular Editor
- No breaking changes from compatibility level 1600 to 1700
- Horizontal Fusion and enhanced parallelism activate automatically at compatibility level 1700
- Selection expressions require compatibility level 1700 -- update calculation groups to use them
- Update client libraries (ADOMD.NET, MSOLAP) to benefit from binary XML and compression
- Test all existing DAX/MDX queries and reports after upgrading compatibility level
- Review XEvents configuration to take advantage of new execution metrics
Related Skills
chrishuffman5/kubectl
tools
VerifiedTrustedCommunity
kubectl command-line usage and scripting: kubeconfig and context management, output formats (jsonpath, custom-columns, go-template), all major verbs (get, describe, apply, delete, exec, logs, port-forward, rollout, scale, drain), workload resources, config/storage, networking, RBAC, node management, debugging (CrashLoopBackOff, ImagePullBackOff, OOMKilled), and scripting patterns (dry-run, diff, wait, jq, kustomize). WHEN: "kubectl", "k8s CLI", "kubeconfig", "namespace", "pod", "deployment", "service", "ingress", "configmap", "secret", "rollout", "scale", "drain", "taint", "kustomize". Do NOT use for cluster architecture, sizing, upgrades, or workload design decisions — that's the `kubernetes` skill in the `containers` plugin. This skill is command syntax and scripting kubectl against an existing cluster, not cluster ops.
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/bash
tools
VerifiedTrustedCommunity
Bash 5.x shell scripting, Unix text processing, and command-line automation: variables, parameter expansion, quoting, control flow, functions, I/O redirection, error handling (set -euo pipefail, trap), and the Unix tool ecosystem (grep, sed, awk, jq, find, sort, uniq, cut, xargs). Covers process management, networking (curl, ssh, rsync, nc), file locking (flock), parallel execution, and production script patterns. WHEN: "Bash", "bash", "shell", "sh", ".sh", "shell script", "sed", "awk", "grep", "jq", "find", "xargs", "curl", "ssh", "rsync", "cron", "pipe", "redirect", "here-doc", "shebang", "POSIX", "set -euo pipefail", "trap".
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/azure-cli
tools
VerifiedTrustedCommunity
Azure CLI (az) command syntax and scripting: authentication (interactive, service principal, managed identity, SSO), output formats and JMESPath queries, resource groups, VMs, storage accounts/blobs, networking (VNets, NSGs, load balancers, DNS), Entra ID, AKS, App Service, Functions, databases (SQL, Cosmos DB, MySQL, PostgreSQL), Key Vault, Monitor/alerting, and infrastructure scripting patterns. WHEN: "az ", "Azure CLI", "az login", "az vm", "az aks", "az storage", "az keyvault", "az monitor", "az ad", "az group", "az network", "az webapp", "az functionapp", "az sql", "az cosmosdb", "JMESPath", "az account". Do NOT use for Azure architecture, landing zones, or multi-subscription strategy — that's the `cloud-platforms` plugin. This skill is about command syntax and scripting the CLI, not deciding what to provision.
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/aws-cli
tools
VerifiedTrustedCommunity
AWS CLI v2 command syntax and scripting: authentication (profiles, SSO, assume-role, instance profiles), output formats and JMESPath queries, pagination and waiters, IAM, S3, Lambda, RDS, CloudFormation, ECS, EKS, CloudWatch, SSM, Route 53, STS, and VPC networking. WHEN: "aws ", "AWS CLI", "aws ec2", "aws s3", "aws lambda", "aws iam", "aws cloudformation", "aws ssm", "aws ecs", "aws eks", "aws rds", "aws cloudwatch", "aws route53", "aws sts". Do NOT use for AWS architecture, service selection, multi-account strategy, or FinOps — that's the `cloud-platforms` plugin. This skill is about command syntax and scripting the CLI, not deciding what to provision.
3SKILL.mdUpdated Jul 21, 2026