LVL 3: 4.6.3 Data Hub Model: SYS14 module

kunal_311
edited November 2022 in Modeling

Dear Team,

 

I got stuck in one place while building SYS 14 module, i don't have my old Data Hub model bcz of which i downloaded from training.

 

1) If it was DH model - then Data? has a simple formula to see whether SKU Filter system module has data and if yes then check if any Product is 

their 

 

2) If DH is downloaded from training - it was to use a formula that references the entire timescale of the DAT05 Historic Revenue by Product module to filter for revenue greater than 0.

The entire time scale of DAT05 - FY19 QTR?

Do I need to refer DAT05 Module with rev>0? 'DAT05 Historic Revenue'.Revenue > 0

I tried but I am missing something here. Kindly guide.

 

kunal_311_0-1617476944631.png

@Misbah 

Tagged:

Answers