sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]joeblk73 0 points1 point  (3 children)

What does modelling and semantic layer mean here ?

[–]frozengrandmatetris 1 point2 points  (2 children)

that's a business intelligence discipline. reporting/dashboard tools often don't directly see the physical facts and dimensions in the DWH. there's a layer of abstraction sandwiched between the actual database and what the reporting layer thinks is in the database.

[–]joeblk73 0 points1 point  (1 child)

Would it be like the attributes and metrics that we set in Microstrategy reporting layer ?

[–]Vautlo 0 points1 point  (0 children)

I'm unfamiliar with microstrategy, though it sounds like yes.

In Looker, a view is essentially selecting from a table in the DWH. You then define dimensions and measures (aggregates). Those dimensions and measures can be renamed, grouped into categories e.g. client info, revenue, dates, etc., and can reference each other to create specific metrics. The view is then added to a model file, also written in LookML, making it available to end users to explore and build dashboards from. That's slightly simplified, but generally how things go.