Level 3 Spring 1 User story 1,6
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.3
Hi Kunal - you may want to think about how time may impact this calculation. Good luck!1
Thank you @jrimmer93 @ChrisAHeathcote for your guidance.
Got it correct by changing the year and mapping reference for the SUM function.0
By 1. TAR02 time dimension is YEAR and TAR04 is MONTH. If my memory is correct TAR04 should be YEAR.
I get the solution.0