Level 3 Sprint 1 4.6.3 Data Hub Model: SYS14 module

Deekshitha29
Deekshitha29
in Academy Discussions

Hi All,

I am struck in below question.

For Data, I have used the below formula

Data? (Boolean) filter to determine if ANY data for product SKU under the product 

  • If you are using the Level 2 Data Hub model: reference the SYS12 SKU Details and SYS13 Account SKU filter
  • If you downloaded a new Data Hub model at the beginning of Level 3: Use a formula that references entire timescale of the DAT05 Historic Revenue by Product module to filter for revenue greater than 0

Data?- TIMESUM('DAT05 Historic Revenue by Product module'.'Quarterly account/Product data') <> 0

However Unable to crack the rest.

Manual? (Boolean) will be used to create relationship between product and account

what relationship should be created?

  • Valid? (Boolean) confirms if either Data? or Manual? line items are true 
  • Code will display combined code of account and product codes (example: A001_P001) if Valid? is true
  • Product Code use to create subsidiary view to display only the product code - Should we create Subsidary view?

@Dikshant Would you be able to help on this please

Answers

  • sobaid
    sobaid

    Hi @Deekshitha29

    Manual: Its a Manual boolean checking availability, think an end user/ dev wants to override and wants a particular combination to be included in the saved view, as opposed to Data line item which id formula based.

    Valid? and code - you get the formula hint from the description itself

    Product Code- Yes a subsidiary view should be used

    You are creating a relationship of Account and Product in Datahub as the lesson portray

    Lastly What dimensions are you using?

Categories