Finance Hierarchies Functionality
- The finance hierarchies are designed to organize and structure financial accounts in a way that supports both detailed analysis and high-level reporting. This functionality is primarily built on two components:
FinanceAccount
- This dimension contains all financial accounts imported from the ERP system, including both posting accounts (used in actual transactions) and total accounts (used for aggregation). While only posting accounts are directly linked to financial transactions, total accounts serve as structural elements in the hierarchy.
FinanceAccountReport
- This component defines how financial accounts are grouped and displayed in reports. It includes the hierarchical structure of accounts, allowing users to view financial data at various levels of granularity (e.g., account → group → category). It also supports custom mappings and ERP-specific structures, enabling flexible reporting across different systems.
Together, these components enable:
- Drill-down and roll-up capabilities in financial reports
- Consistent aggregation of financial data across multiple levels
- Cross-system compatibility through mapping and schema definitions
Global Dimensions Functionality
- The global dimensions framework enables flexible and scalable filtering, grouping, and analysis of data across multiple business perspectives. It is structured around two key components:
Dim_DimensionSet
- This table acts as a central grouping mechanism for all global dimensions. It follows a snowflake schema, where all fact tables (e.g., sales, finance, inventory) relate to Dim_DimensionSet, which in turn connects to the individual global dimension tables. This design ensures consistency and reusability across the data model.
Dim_GD_
*These are the individual global dimension tables, such as:
- Dim_GD_Department
- Dim_GD_Brand
- Dim_GD_BusinessUnit
Each table contains a key, a name, and optionally a hierarchy that defines parent-child relationships within the dimension. These dimensions provide the semantic context needed for slicing and dicing data in reports and dashboards.
Key Features and Benefits
- Centralized filtering: Use Dim_DimensionSet to filter all fact tables.
- Common Configuration Table: Makes onboarding easier.
- RemoveInactiveDataSourcesAndModules: Cleans up unused data structures.
- Updated Exchange Rate Logic: Handles currency conversions.
- Dynamic column determination for NAV and OnPrem: Adapts to different setups.
- Delta Load: Loads only changes for faster updates.
- Clean Views updates to timezones: Ensures correct time alignment.
- Simplification and cleanup: Streamlines data models.
- Performance Optimizations: Improves speed and efficiency.
- Accobat Business Central Extension optimizations: Enhances extension performance.