Lightspeed Totals a Gift Card Sale at Zero, Correctly
A customer hands over a hundred dollars for a gift card and Lightspeed writes the sale down as zero, on purpose. The semantic model is where your warehouse learns that is deferred revenue.
Latest
Square Puts Tips on Their Own Line and Replication Folds Them Back In
Square's report puts tips on their own line, because tips aren't sales. Replication lands fifteen money columns and none of the definitions. The semantic model is where revenue gets defined.
In PeopleSoft, a Student's Current Program Is Not a Column
Every program change is still a row in PS_ACAD_PROG, and the tool you reported from dropped them by default. That default doesn't replicate. The semantic model is where the current row gets defined.
Every SyteLine Table in Your Warehouse Holds Every Site's Rows
Every SyteLine table holds every site's rows. The object that filtered them to one plant was a SQL view, and your connector copied the table. The semantic model is where the site becomes a key.
How to Query Infor LN by Company When the Company Number Is in the Table Name
One Infor LN table lands in your warehouse as many tables, one per company, and not one of them has a company column. The semantic model is where the company becomes a column you can group by.
Oracle Fusion Balances to the Cent. Your Warehouse Can't Prove It.
Oracle's ledger balances to the cent because the amounts are decimal. The connector lands them as floating point, and the semantic model is the only place that records they used to be exact.
The Only Place IFS Says What Code Part B Means Is a Power BI File
IFS ships nine ledger dimensions named B through J, and never writes down which one is the cost centre. The semantic model is where that finally gets said.
Two Columns, One SAP Material Number, and the Join Uses the Padded One
Your SAP warehouse stores material 4711 as 000000000000004711 and ships a trimmed copy beside it. Only one of the two joins to anything. The semantic model declares which.
Only Your Semantic Model Knows Whether a Workday Student Row Is a Student
A Workday Student table is one custom report's output, at a grain Workday fixed inside the tenant. The table name was typed by hand. The semantic model is where that grain gets declared.
In Infor M3, Your Custom Fields Are Rows in a Table Called CUGEX1
Infor M3 keeps every customer-defined field in CUGEX1, found by matching the extended table's name in a column called FILE. The semantic model declares that join and its mandatory filter.
Oracle EBS Secured Every Operating Unit in a Session Variable. Your Warehouse Copied the Table.
Oracle partitions EBS by operating unit through a view reading a session variable. A warehouse has no session, so every unit lands in one table. The semantic model makes org_id a required dimension.
The Kantata Link Table That Counts the Same Hour Once Per Group
Kantata has no client table. A client is a group with a box ticked, a project can sit in several, and the obvious join counts its hours under each. The semantic model declares the path that totals.
Data Agent
Eighteen Autodesk Construction Cloud Tables Carry a Status Column. One Is a Foreign Key.
An open issue is the string open. An open submittal item is the string 2. An open asset is a UUID. Five modules, five status vocabularies, and the semantic model is where all five get declared.
Data Agent
How to Count Servers in Ivanti When Your Warehouse Has No Server Table
Ivanti shows a server, a printer, and a vendor contract as separate business objects. The warehouse lands all 35 kinds in one ci table where Server is a value. The semantic model makes it the filter.
Data Agent
UKG's Combined Pay Codes Land in Your Warehouse Beside the Hours They Sum
A combined pay code is the total of several pay codes, and it lands as a row beside the rows it sums. Add up the hours column and those hours count twice. The semantic model draws the line once.
Data Agent
In Your Certinia Warehouse, the Table Named Timecard Is Not the Timecard
A Certinia timecard is a week, and its total is a formula that never lands. The table the API calls Timecard is the child. The semantic model records which one is the week.
Data Agent
Clio Stores Billable Time in Seconds. The Column Named Hours Is Optional.
In a replicated Clio activities table, quantity is seconds on a time entry and a unit count on an expense. The semantic model holds the unit and the row filter that every Clio screen applies for you.
Data Agent
One Maximo Work Order, Five Tasks, Six Rows
A replicated Maximo WORKORDER table holds every task and every closed record beside the work orders. The semantic model holds the filter Work Order Tracking applies.
Data Agent
The Canvas Student Who Doesn't Exist, and the Two Rows for the One Who Does
A Canvas Data 2 enrollments row is a user in a section in a role, and one of them is Test Student. The semantic model holds the class size Canvas computes in code.
Data Agent
Dynamics 365 Finance Keeps Every Dimension Behind One Integer. The Semantic Model Decodes It.
Every financial dimension of a posted Dynamics 365 Finance ledger line sits behind one integer, and the column that decodes it exists only in your tenant. The semantic model names the column.
Data Agent
Why Text-to-SQL Accuracy Slips from 91.2% to 21.3% on Real Company Data
Text-to-SQL scores 91.2% on the benchmark everyone quotes and 21.3% on the one built from enterprise warehouses. The gap is implicit joins, and a semantic model is where they get declared.
Data Agent
How to Sum JD Edwards Actuals Without Adding the Labor Hours to the Dollars
JD Edwards posts dollars, budget dollars, and labor hours into the same F0902 period columns, told apart by a two-letter ledger type. The semantic model names the ledger once, for every query.
Data Agent
In Your Workday HCM Warehouse, PERSON_NAME Holds People Who Don't Work for You
Fivetran lands Workday pre-hires beside workers and relatives beside employees, told apart by one column called type. The semantic model declares which rows each question means.
Data Agent
Ellucian Banner Records When a Major Started. No Column Records When It Stopped.
A replicated Banner lands every column and 99 correct foreign keys on the student record, and still cannot say how many students are in each major. The semantic model chooses the in-force row.