Level 3 Sprint 1 4.6.3 Data Hub Model: SYS14 module

Deekshitha29

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

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?