chrishuffman5/analytics-ssas-2019
skills/analytics/ssas/2019/SKILL.md
Version-specific expert for SQL Server Analysis Services 2019 (compatibility level 1500). Covers calculation groups, native many-to-many relationships, query interleaving, and governance settings. WHEN: "SSAS 2019", "SQL Server 2019 Analysis Services", "compatibility level 1500", "calculation groups", "calculation items".
$ install --global
skillsauthnpx skillsauth add chrishuffman5/domain-expert analytics-ssas-2019Install 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:31 AM24.7s1 file scanned
SKILL.md
- name:
- analytics-ssas-2019
- description:
- Version-specific expert for SQL Server Analysis Services 2019 (compatibility level 1500). Covers calculation groups, native many-to-many relationships, query interleaving, and governance settings. WHEN: \"SSAS 2019\", \"SQL Server 2019 Analysis Services\", \"compatibility level 1500\", \"calculation groups\", \"calculation items\".
- license:
- MIT
- version:
- 1.0.0
- author:
- christopher huffman
SSAS 2019 Version Expert
You are a specialist in SQL Server 2019 Analysis Services, compatibility level 1500. Released November 2019.
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 2019.
Key Features
Calculation Groups
The headline feature of SSAS 2019. Addresses measure proliferation in complex BI models by defining common calculations once as reusable calculation items.
Problem solved: Without calculation groups, time intelligence patterns (YTD, QTD, YoY%) must be duplicated across every base measure. A model with 20 base measures and 5 time intelligence variations requires 100 measures. Calculation groups reduce this to 20 base measures + 5 calculation items.
How they work:
- A calculation group is a special table containing calculation items
- Each calculation item defines a DAX expression applied to any measure via
SELECTEDMEASURE() - Calculation items support custom ordering for consistent display in reports
- Created via Visual Studio 2019 (VSIX 2.9.2+), TOM API, TMSL, or Tabular Editor
Example pattern -- time intelligence:
- Calculation items: Current, YTD, Prior Year, YoY Change, YoY %
- Each item wraps
SELECTEDMEASURE()with the appropriate time intelligence function - Any base measure (Sales, Cost, Margin) automatically gets all 5 variants
Limitation: Row-level security (RLS) cannot be applied to calculation groups directly or indirectly.
Native Many-to-Many Relationships
Direct support for many-to-many relationships in the data model without bridge table workarounds in DAX.
- Requires compatibility level 1500+
- Created via Visual Studio 2019 (VSIX 2.9.2+), TOM API, TMSL, or Tabular Editor
- Simplifies modeling patterns that previously required complex DAX (e.g., students enrolled in multiple courses, products in multiple categories)
- The engine handles the many-to-many filter propagation internally
Query Interleaving
CPU scheduling improvement for high-concurrency workloads.
- Prior behavior: First-in-first-out (FIFO) scheduling meant fast queries could be blocked behind slow queries
- New behavior: Concurrent queries share CPU resources with short-query bias, preventing fast queries from being starved by long-running ones
- Configurable via system settings for tuning concurrency
- Most impactful in environments with mixed query complexity (dashboards + ad-hoc analysis)
Governance Settings
- ClientCacheRefreshPolicy: Controls when client-side query caches are refreshed after model processing
- Originally an Azure Analysis Services feature, now available in on-premises SSAS 2019
- Allows administrators to manage cache invalidation timing
Other Features
- Superimposed relationships
- Online attach for read-only workloads (reduces downtime during model deployment)
- Power BI dataset connectivity improvements
Migration from SSAS 2017
- Upgrade the SSAS instance to SQL Server 2019
- Set model compatibility level to 1500 in Visual Studio or Tabular Editor
- No breaking changes from compatibility level 1400 to 1500
- Calculation groups require compatibility level 1500 -- set this before creating them
- Test all existing DAX measures and reports after upgrading compatibility level
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