# using-mapped-dimensions

> Claude/Codex skill by [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars · Updated 2026-10-23

Execution skill. Use when modeling dynamic or time-dependent hierarchies, card metrics for flexible reporting (e.g. headcount by team/function via BY-arrow mappings), or any scenario where reporting breakdowns must differ from the structural dimensions on the metric.

## Install

```sh
git clone https://github.com/gopigment/ai-plugins /tmp/ai-plugins && ln -s /tmp/ai-plugins/skills/using-mapped-dimensions ~/.claude/skills/using-mapped-dimensions
```

## From README

Using Mapped Dimensions Mapped dimensions (time-dependent hierarchies, slowly changing dimensions) model parent-child relationships that change across periods. Past periods keep the old parent; future ones reflect the new assignment. Choose Between Static Properties and Mapped Dimensions | Criterion | Dimension-Type Property (static) | Mapped Dimension (dynamic) | | --- | --- | --- | | Relationship changes? | Rarely or never | Changes over time or by version | | History preservation | Updating the parent moves all history with the child | Each period retains its own parent assignment | | Where it works | Metric formulas, aggregation, views | Views only (Joined Pivot); core metrics stay lean | | Examples | Product to Category, Store to Region | Employee to Team (monthly), Cost Center to Department (re-org), Product to Promotion (seasonal) | Rule of thumb: if the parent-child mapping is the same for all periods, use a dimension-type property.

## Links

- HTML page: https://omgskills.com/library/gopigment/ai-plugins/skills/using-mapped-dimensions/
- GitHub: https://github.com/gopigment/ai-plugins
- Author: [@gopigment](https://omgskills.com/library/gopigment/index.md)

## More from this repo

- [aggregating-view-data](https://omgskills.com/library/gopigment/ai-plugins/skills/aggregating-view-data/index.md) — Execution skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars
- [architecting-multi-application-solutions](https://omgskills.com/library/gopigment/ai-plugins/skills/architecting-multi-application-solutions/index.md) — Planning skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars
- [auditing-a-pigment-application](https://omgskills.com/library/gopigment/ai-plugins/skills/auditing-a-pigment-application/index.md) — Execution skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars