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