Level 1 Model Building Training

[alismith]

Thanks, I worked it out, just after my last post.

[KARASAGE]

Hi Guys, 

I am having the same problem on 10.2.2 Activity: Import Data into Non Employee Expenses Module

the Time settings isnt working and I dont understand why because I put in YYYYMM

    

[SatyamArora]

Do you have to make any changes to the options on the right as well?

[PG]

I am going through Level 1 training as well.

I could successfully import the data for this module, however, I see the totals across the cells, instead of individual numbers.

Here is the mapping I used

I can see the data as expected in the preview as shown above. When i import the data, I see a totals for each product (?) all across  as shown below. Can you please help ?

[SatyamArora]

@PG In the import settings, have you further looked into the time settings. Make sure you match the source format (201901) and target (Jan 19). 

[PG]

Thanks Satyam!

Please see the time settings I have used below. I have used 'YYYYMM' - which I thought would line up with 201901 and so on. Should I be selecting something else ?

[SatyamArora]

@PG that seems fine. Can you also share a screenshot of your line items?

[PG]

Please see all the relevant screenshots. Thank you!

[SatyamArora]

Thanks @PG. Your line items seem to have a subsidiary view (you will learn this in future lessons) - that grid icon you see after volumes in the first screenshot shouldn't be there. Basically what a subsidiary means/grid icon appears when your dimensionality for that specific line items varies from your overall model setting (time, version, lists). 

You can read more about it here - https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Subsidiary_Views.html

Try to find out now by looking into this module carefully. Attached is a screenshot for mine if it helps.

[PG]

Thank you ! Is there an easy way to remove subsidiary view ? Sorry if I missed it in the link you sent.