Core¶
Overview¶
The Core capability provides the foundation dimensions shared by all other capabilities. These are always included and provide the common analytical context — company structure, calendar, BC global dimensions, and data source tracking.
Semantic Model Tables¶
Dimensions¶
| Table | Description |
|---|---|
| Company | BC Company master — company name, display name, and identifiers. The tenant isolation key for multi-company analytics |
| Calendar | Date dimension — year, quarter, month, week, day, fiscal period, Danish working day flag, and public holiday name. Powers all time intelligence calculations including working-day-based analysis |
| Data Source | Tracks the origin of each record — identifies the BC environment and connection for filtering in multi-tenant setups |
| Dimension 1–8 | One table per BC global dimension. Each provides dimension value code, name, and hierarchical totaling type for drill-down analysis |
Power BI Infrastructure¶
These tables are part of the semantic model but do not correspond to BC data:
| Table | Description |
|---|---|
| Report Measures | Container for cross-capability report measures |
| Number Format | Calculation group for dynamic number formatting — switch between thousands, millions, and full precision |
| Time Intelligence | Time intelligence calculation support for YTD, QTD, MTD, and period comparisons |
Use Cases¶
- Multi-company consolidation — Company dimension enables cross-company analysis with filtering
- Time intelligence — Calendar dimension powers YTD, QTD, MTD, and period-over-period comparisons
- Working-day analysis — Danish public holidays and working day flags enable filtering and counting by actual business days
- Dimension-based slicing — All 8 BC global dimensions are available for any transaction analysis
- Data lineage — Data Source dimension tracks which BC environment and connection each record originates from