Level 3 Spring 1 User story 1,6

kunal_311

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?

Accepted answers

ChrisAHeathcote

@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.

All comments

jrimmer93

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

ChrisAHeathcote

@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.

kunal_311

Thank you @jrimmer93 @ChrisAHeathcote for your guidance.

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

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.

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…