level 1 activity 10.2.2

ShreyaR

Hi,

 

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

 

Misbah

@ShreyaR

 

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

ShreyaR

@Misbah 

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.

Misbah

@ShreyaR 

 

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

 

Misbah

Miz Logix

ShreyaR

@Misbah 

still not resolved.Receiving error after selecting YYYYMMDD.

Misbah

@ShreyaR 

 

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

ChrisAHeathcote

@ShreyaR 

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.

 

ChrisAHeathcote

Also, use YYYYMM fixed position pattern with periods selected from the options in the top part of the time mapping screen.

ShreyaR

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

Rohit1986651

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.

ChrisAHeathcote

The default calendar should be 2020 not 2021... with 1 prior year and 1 future year.