Analytic Model Creator

What problem does it solve?

Converts raw fact and dimension schemas into consumption-ready Analytic Models for SAP Analytics Cloud, removing manual work around measure design, variable configuration, currency conversion, and exception aggregation so dashboards return accurate, performant results.

Core Features & Use Cases

• Fact and Dimension Mapping: Choose a fact source and attach contextual dimensions with correct associations and hierarchies to ensure correct grain and drill paths.
• Measure Design: Define simple, calculated, restricted, and count-distinct measures with clear aggregation rules and exception handling (weighted averages, point-in-time measures).
• Currency & Exception Handling: Configure currency/unit conversion using exchange-rate lookups and set exception aggregation rules to avoid misleading results in dashboards.
• Use case: Create an Analytic Model for SalesOrders to deliver Total Sales, Unique Customers, and On-Time Delivery metrics for an SAC sales performance dashboard with multi-currency support.

Quick Start

Create an Analytic Model from the SalesOrders fact with Customer, Product, and Date dimensions, add Total Sales (SUM of Amount) and Unique Customers (COUNT DISTINCT CustomerID), configure currency conversion to USD via an ExchangeRates lookup, and validate with a sample query.