Level 1 Model Building Training

Highlighted
Contributor

Re: Level 1 Model Building Training

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

Highlighted
Frequent Contributor

Re: Level 1 Model Building Training

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

 

satyamarora85_1-1584560066044.png

 

Highlighted
Occasional Contributor

Re: Level 1 Model Building Training

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

 

Mapping.JPG

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 ?

 

Module View.JPG

Highlighted
Frequent Contributor

Re: Level 1 Model Building Training

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

Highlighted
Occasional Contributor

Re: Level 1 Model Building Training

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 ?Time Settings.JPG

Highlighted
Frequent Contributor

Re: Level 1 Model Building Training

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

Highlighted
Occasional Contributor

Re: Level 1 Model Building Training

 

Please see all the relevant screenshots. Thank you!

 

Blueprint.png

 

Volume Import.pngProduct Code.pngPivot.pngLocation code.JPG

 

 

Highlighted
Frequent Contributor

Re: Level 1 Model Building Training

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.

Highlighted
Occasional Contributor

Re: Level 1 Model Building Training

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

Highlighted
Frequent Contributor

Re: Level 1 Model Building Training

what you can do is create a new (test) module rev02 and test. By default, it doesn't create a subsidiary view when you create a new module. If works, you can delete the subsidiary view one.