Level 3 Spring 1 User story 1,6

kunal_311
kunal_311
in Modeling

kunal_311_0-1618336952085.png

kunal_311_1-1618337118454.png

I am struggling to understand what I need to do for this activity. 

 

I created a module with G2 Country and Segment dimension but I am not able to populate this module. 

Am I missing something? Attached screenshot 

 

Is this what the activity is asking for?

Tagged:

Best Answer

  • ChrisAHeathcote
    ChrisAHeathcote
    Answer ✓

    @kunal_311 

    I believe you have built the correct model with the correct dimensions.

    Did your formula generate any errors?

    If not then there a number of possible reasons why no data is flowing through.

    1. TAR02 time dimension is YEAR and TAR04 is MONTH. If my memory is correct TAR04 should be YEAR.

    2. TAR02 contains no COUNTRY mapping used to inform the SUM function.

    3. TAR02 contains no SEGMENT mapping used to inform the SUM function.

     

    My guess is that you need to change the MONTH time to YEAR as time defaults to MONTH when first created and does not generate an error. It just returns no value. 

     

Comments

  • jrimmer93
    jrimmer93
    Hi Kunal - you may want to think about how time may impact this calculation. Good luck!
  • kunal_311
    kunal_311

    Thank you @jrimmer93 @ChrisAHeathcote  for your guidance.

    Got it correct by changing the year and mapping reference for the SUM function.

  • Nikunj
    Nikunj

    By 1. TAR02 time dimension is YEAR and TAR04 is MONTH. If my memory is correct TAR04 should be YEAR.

    I get the solution.

Categories