topic Re: level 1 activity 10.2.2 in Academy & Training https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125004#M3486 < P > < LI-USER uid = " 64036 " > < / LI-USER > 

 

Weird! Check what is H01 Location in the list and try to find the number against it in the module.

 

Note: I thought date format in source file was YYYYMMDD, because it looks like it is. I might be wrong & you right by having it as YYYYDDMM. 

 

Misbah

Miz Logix

 Tue, 16 Nov 2021 15:11:27 GMT Misbah 2021-11-16T15:11:27Z level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124927#M3474

Hi,

 

I have imported correctly, without any errors but data is not displaying.

 

 Tue, 16 Nov 2021 04:12:11 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124927#M3474 ShreyaR 2021-11-16T04:12:11Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124935#M3475 < P > < LI-USER uid = " 64036 " > < / LI-USER >

 

Can you check any other city. Bring city dimension into rows and check if all of the rows are showing null values.

 

If Yes, please share the source file and screenshot of import mapping.

 

Misbah

Miz Logix

 Tue, 16 Nov 2021 05:53:54 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124935#M3475 Misbah 2021-11-16T05:53:54Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124958#M3478

 

checked with different cities still showing null values. Not able to bring G3 location dimension in line items .please find screenshot of import mapping and source file.

 Tue, 16 Nov 2021 09:31:01 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124958#M3478 ShreyaR 2021-11-16T09:31:01Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124961#M3480 < P > < LI-USER uid = " 64036 " > < / LI-USER > 

 

Found it! It is in Time - You have to select YYYYMMDD and NOT YYYYDDMM in your import mapping

 

Misbah

Miz Logix

 Tue, 16 Nov 2021 10:26:48 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124961#M3480 Misbah 2021-11-16T10:26:48Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124985#M3484

 

still not resolved.Receiving error after selecting YYYYMMDD.

 Tue, 16 Nov 2021 13:34:21 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/124985#M3484 ShreyaR 2021-11-16T13:34:21Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125004#M3486 < P > < LI-USER uid = " 64036 " > < / LI-USER > 

 

Weird! Check what is H01 Location in the list and try to find the number against it in the module.

 

Note: I thought date format in source file was YYYYMMDD, because it looks like it is. I might be wrong & you right by having it as YYYYDDMM. 

 

Misbah

Miz Logix

 Tue, 16 Nov 2021 15:11:27 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125004#M3486 Misbah 2021-11-16T15:11:27Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125322#M3506 < P > < LI-USER uid = " 64036 " > < / LI-USER > 

You have select the 'Total' line item.

 

This needs to be formula driven as it is the total of all the other line items.

 

Add a formula to sum the other line items and the data will display correctly.

 

 Mon, 22 Nov 2021 09:29:37 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125322#M3506 ChrisAHeathcote 2021-11-22T09:29:37Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125323#M3507 Also, use YYYYMM fixed position pattern with periods selected from the options in the top part of the time mapping screen. Mon, 22 Nov 2021 09:31:39 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125323#M3507 ChrisAHeathcote 2021-11-22T09:31:39Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125324#M3508

Hi,
Thanks for response but the issue is resolved for this question.Need help with level 1 exam activity 4.

 Mon, 22 Nov 2021 09:32:07 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/125324#M3508 ShreyaR 2021-11-22T09:32:07Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/128315#M3610

Hello all,

 

i am facing similar kind of issue .

Discription - After importing with attached mapping method , my data is not populating to all the columns (Attached).

And, also total is not showing.

Please help.

 Mon, 27 Dec 2021 18:27:30 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/128315#M3610 Rohit1986651 2021-12-27T18:27:30Z Re: level 1 activity 10.2.2 https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/128325#M3614 The default calendar should be 2020 not 2021... with 1 prior year and 1 future year. Mon, 27 Dec 2021 21:54:29 GMT https://community.anaplan.com/t5/Academy-Training/level-1-activity-10-2-2/m-p/128325#M3614 ChrisAHeathcote 2021-12-27T21:54:29Z