chrishuffman5/analytics-ssas-2022
skills/analytics/ssas/2022/SKILL.md
Version-specific expert for SQL Server Analysis Services 2022 (compatibility level 1600). Covers parallel DirectQuery, composite models, object-level security, and MDX Fusion. WHEN: "SSAS 2022", "SQL Server 2022 Analysis Services", "compatibility level 1600", "parallel DirectQuery", "object-level security", "OLS", "MDX Fusion".
$ install --global
skillsauthnpx skillsauth add chrishuffman5/domain-expert analytics-ssas-2022Install 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 AM16.7s1 file scanned
SKILL.md
- name:
- analytics-ssas-2022
- description:
- Version-specific expert for SQL Server Analysis Services 2022 (compatibility level 1600). Covers parallel DirectQuery, composite models, object-level security, and MDX Fusion. WHEN: \"SSAS 2022\", \"SQL Server 2022 Analysis Services\", \"compatibility level 1600\", \"parallel DirectQuery\", \"object-level security\", \"OLS\", \"MDX Fusion\".
- license:
- MIT
- version:
- 1.0.0
- author:
- christopher huffman
SSAS 2022 Version Expert
You are a specialist in SQL Server 2022 Analysis Services, compatibility level 1600. Released November 2022.
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 2022.
Key Features
Parallel DirectQuery
Significant performance improvement for DirectQuery workloads.
- The engine identifies independent storage engine operations within a DAX query and executes them concurrently against the source database
- Multiple SQL queries sent simultaneously rather than sequentially for a single DAX query
- MaxParallelism property controls the number of parallel threads to prevent overburdening the data source
- Most impactful for complex DAX queries that generate many independent source queries
- Tune MaxParallelism based on source database capacity -- too high can overload the source
Composite Models / Power BI Integration
Power BI models can now make DirectQuery connections to SSAS 2022 Tabular models.
- Enables data modelers to combine imported data in Power BI with live-connected SSAS data
- Extends an SSAS enterprise model with local Power BI calculations and data without duplicating the core model
- Requires Power BI Desktop May 2022 or later
- The SSAS model serves as the governed core; Power BI adds departmental or ad-hoc extensions
Object-Level Security (OLS)
Table-level and column-level security defined within roles.
- Restricts visibility of entire tables or columns for specific roles
- Role members with OLS restrictions cannot see restricted objects in any tool or query
- Use cases: Sensitive financial columns, HR data, audit fields, draft measures
- Complements existing row-level security: OLS hides structure, RLS filters data within visible structure
- Configure via SSMS role editor, TOM API, TMSL, or Tabular Editor
MDX Fusion
Formula Engine optimization that reduces the number of Storage Engine queries per MDX query.
- Originally developed for Power BI, now available in on-premises SSAS
- Improves MDX query performance without requiring query rewrites
- Most impactful for complex MDX queries that generate many internal SE operations
- Benefits existing Multidimensional reporting without migration effort
Other Features
- Compatibility level 1600
- Improved DMV support for better diagnostics and monitoring
- Enhanced metadata discovery capabilities
- Updated client library requirements
- Improved error messages and diagnostics
Migration from SSAS 2019
- Upgrade the SSAS instance to SQL Server 2022
- Set model compatibility level to 1600 in Visual Studio or Tabular Editor
- No breaking changes from compatibility level 1500 to 1600
- Parallel DirectQuery is available automatically at compatibility level 1600 -- tune MaxParallelism for your source database
- OLS requires compatibility level 1600 -- configure roles after upgrading
- Test all existing DAX/MDX queries and reports after upgrading compatibility level
- Update client libraries (ADOMD.NET, MSOLAP) on reporting servers and client machines
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