DataFocus · Journal

Ideas to explore. Practice to build on.

Ideas, methods and progress in enterprise context, business ontology and agent applications.

RSS
DataFocus

Why Finance and Sales Report Different Revenue: Five Choices Hidden Inside Every Metric

Two reports disagree on one metric because each re-implements it and makes five unlabeled choices: filters, date column, grain, join path and source system. A worked revenue reconciliation, a triage order and what an executable, owned definition requires.

Read article: Why Finance and Sales Report Different Revenue: Five Choices Hidden Inside Every Metric
DataFocus

Is Text-to-SQL Enough for Business Users? Raw SQL Generation vs Governed Ontology Queries

Public enterprise benchmarks show raw text-to-SQL still fails on most real warehouse tasks. The gap is mostly missing business definitions. Here is how definition-bound queries that show their SQL compare, and when plain text-to-SQL is fine.

Read article: Is Text-to-SQL Enough for Business Users? Raw SQL Generation vs Governed Ontology Queries
DataFocus

Connect MySQL, Oracle or SQL Server to OT Flash with a read-only account

OT Flash's r57 manual lists 26 external source types, from MySQL and Oracle to Hive and Iceberg. The secure path is a dedicated read-only account, a tested connection, and a scheduled import into OT Flash's own store. Here is each step, and what the manual leaves to you.

Read article: Connect MySQL, Oracle or SQL Server to OT Flash with a read-only account
DataFocus

Business Ontology for AI Agents: What It Is, What It Contains, When Not to Build One

A business ontology models one business area's objects, relationships, rules, actions and permissions in one model people and agents share. Agents need it to close three gaps a schema cannot: context, boundaries and an approval path. Plus a rule for when not to build one.

Read article: Business Ontology for AI Agents: What It Is, What It Contains, When Not to Build One