About Marco1

Marco1 · 03-31-2021

Hello all, I'm a newbie. I need to realize a model that link together two or more fact tables.For example Movements and Orders.Both the facts have in common the SKU Dimension, and each have one or more specific dimensions:MOVEMENTS_TBL MOV_ID MOV_DAT...

Marco1 · 04-02-2021

yes, I tried it. I thought that Looker was able to automatically generate the above queries, once the sku Dimension was joined to both facts Tables.

Marco1 · 04-02-2021

As you can see, both tables have in common only the column SKU_COD. The goal I want to reach is a dashboard where I can mix Mov Qty and Ord Qty together, maybe at different level of details.For example if in the visualization there will be Brand Cod,...

My Stats

Marco1's Bio

Badges Marco1 Earned

Recent Activity

Model Multi - Fact

Re: Model Multi - Fact

Re: Model Multi - Fact