skills.rest
MarioDeFelipe
MarioDeFelipeCOMMUNITY
Explore all skills by this author →
GitHub

Analytic Model Creator

Design and build analytic models for SAP Datasphere consumption.

25|7|Updated Feb 7, 2026
Search Tags:#aggregation#dimensions#measures#currency conversion#analytic model#sap datasphere#sap analytics cloud
One-click install
npx skills add https://github.com/MarioDeFelipe/sap-datasphere-plugin-for-claude-cowork --skill analytic-model-creator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Analytic Model Creator
Source: https://github.com/MarioDeFelipe/sap-datasphere-plugin-for-claude-cowork/tree/main/skills/datasphere-analytic-model-creator
Command: npx skills add https://github.com/MarioDeFelipe/sap-datasphere-plugin-for-claude-cowork --skill analytic-model-creator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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.

Frequently Asked Questions about Analytic Model Creator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build an analytic model in SAP Datasphere for SAP Analytics Cloud dashboards?▼

To build an analytic model in SAP Datasphere, you assemble a fact source with associated dimensions, define measures, configure variables, and apply exception aggregation to ensure your SAP Analytics Cloud dashboards return accurate results.

How does currency conversion work in an SAP Datasphere analytic model?▼

Currency conversion in an SAP Datasphere analytic model works by configuring measure rules to use exchange-rate lookup tables, converting source currencies into a target currency like USD for accurate financial reporting in dashboards.

What's the best way to define calculated and count-distinct measures for SAC consumption?▼

The best way to define calculated and count-distinct measures for SAC consumption is to apply clear aggregation rules within the analytic model, ensuring correct grain for metrics like Unique Customers using COUNT DISTINCT.

When should I use exception aggregation in an SAP Datasphere analytic model?▼

You should use exception aggregation in an SAP Datasphere analytic model when you need weighted averages or point-in-time measures, preventing misleading dashboard results from standard data rollups.

Do I need exchange rate lookup tables to configure currency conversion in my analytic model?▼

Yes, you need exchange rate lookup tables to configure currency conversion in your analytic model, as these lookup tables provide the necessary rates to translate amounts into a target currency.

How do I validate an analytic model before consuming it in SAP Analytics Cloud?▼

You validate an analytic model before consuming it in SAP Analytics Cloud by executing an analytical query and running aggregation testing to verify that measures, dimensions, and currency conversions return expected results.

Related Skills

Explore More Data & Analytics Skills→
MarioDeFelipeMarioDeFelipe
25

Performance Optimizer

Diagnose SAP Datasphere performance bottlenecks in views, queries, and data flows.

Community
Advanced
redhat-etredhat-et
1

check-logs

Query and analyze Kagenti platform logs with Grafana Loki to detect errors.

Official
Intermediate
finsilabsfinsilabs
44

financial-analytics-dashboard

Create interactive financial KPI dashboards with drill-down analysis and threshold-based alerts.

Official
Intermediate
rittmananalyticsrittmananalytics
8

dbt-semantic-layer

Design and validate dbt Semantic Layer artifacts with YAML configurations.

Official
Advanced