# BI Semantic Layer Generator

> Generates semantic layer definitions for BI tools from dimensional models

- Skill: `a5c-ai/bi-semantic-layer-generator` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add a5c-ai/bi-semantic-layer-generator`
- Raw SKILL.md: https://api.skillmd.com/api/skills/a5c-ai/bi-semantic-layer-generator/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: a5c-ai (https://skillmd.com/u/a5c-ai)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/a5c-ai/bi-semantic-layer-generator

---


# BI Semantic Layer Generator

## Overview

Generates semantic layer definitions for BI tools from dimensional models. This skill automates the translation of dimensional models into platform-specific semantic definitions.

## Capabilities

- LookML generation (Looker)
- Tableau data model generation
- Power BI semantic model creation
- Cube.js schema generation
- dbt metrics layer integration
- Calculation and measure definitions
- Hierarchy generation
- Security filter generation
- Join path optimization

## Input Schema

```json
{
  "dimensionalModel": "object",
  "targetPlatform": "looker|tableau|powerbi|cubejs|dbt",
  "businessGlossary": "object",
  "securityRules": ["object"]
}
```

## Output Schema

```json
{
  "semanticModel": "object",
  "calculations": ["object"],
  "hierarchies": ["object"],
  "securityFilters": ["object"],
  "documentation": "string"
}
```

## Target Processes

- Metrics Layer
- BI Dashboard Development
- Data Warehouse Setup

## Usage Guidelines

1. Provide complete dimensional model definition
2. Specify target BI platform
3. Include business glossary for consistent naming
4. Define security rules for row-level filtering

## Best Practices

- Maintain consistency between semantic layer and source models
- Use business glossary terms for user-facing labels
- Implement hierarchies for drill-down analysis
- Configure appropriate caching strategies
- Document calculation logic for maintainability