News for hackers. Stuff that matters.
Re:Why Semantic Layers Matter (and how to build one with Duc... by sschnei8 on Tuesday August 19, 2025 @05:54PM (#44956631)
I love a semantic layer as much as the next guy...

Pivoting a decent sized BI shop toward using one instead of splashing the same SQL all over the place is *tough*. It's one of those: "the analyst could have been building important report for director and you want them to create re-usable logic??? we'll do that later, get report done now. Just copy/paste that SQL over here"

This is how you end up with the the 1000 model, "the numbers don't match up", hot mess situations that gain momentum and are hard to slow down.

Re:Why Semantic Layers Matter (and how to build one with Duc... by mritchie712 on Tuesday August 19, 2025 @07:17PM (#44957153)
this is why I liked Looker. The only way to build reports was from the semantic layer which was easy to use and built into the BI.

we took the same approach when we started https://www.definite.app/.

Re:Why Semantic Layers Matter (and how to build one with Duc... by secondrow on Wednesday August 20, 2025 @11:21AM (#44962751)
This is why I liked BusinessObjects
Re:Why Semantic Layers Matter (and how to build one with Duc... by halfcat on Tuesday August 19, 2025 @06:13PM (#44956741)
The flip side is, you often don’t know what needs to be reusable until you’ve had some iterations. Wrong abstractions can be way worse, and also gain their own momentum.
Re:Why Semantic Layers Matter (and how to build one with Duc... by dietr1ch on Tuesday August 19, 2025 @07:15PM (#44957140)
The problem is that often these quick or maybe not reusable are written in such a haste that there's no breadcrumbs left to do the right thing whenever you are done getting that urgent thing out (most likely never because "everything is urgent" :( )
Re:Why Semantic Layers Matter (and how to build one with Duc... by sschnei8 on Tuesday August 19, 2025 @10:05PM (#44958046)
Exactly. “Everything is urgent” is the great burden of our time lol
Re:Why Semantic Layers Matter (and how to build one with Duc... by anon84873628 on Tuesday August 19, 2025 @08:42PM (#44957585)
That tracks. The semantic layer is like a capital investment that pays off over time. So it can be hard to justify the initial investment if people don't grok the payoff.
Re:Why Semantic Layers Matter (and how to build one with Duc... by efromvt on Wednesday August 20, 2025 @08:29AM (#44961295)
Yeah, minimizing the gap between the semantic layer authoring and adhoc is what you need to do to close that - there has to be a progressive model both for consumption (take this semantic layer, slightly extend/tweak it in an adhoc fashion) and for organically promoting up the adhoc works to the layer.

Right now a lot of semantic tools introduce a big discontinuity in both workflows that keeps the two worlds separate.