About RavinderB

RavinderB

@chilled0ut For module views, if you use Show instead of hide when creating views, this will only show the line items in question regardless of any line items you add to the module. So this gets preserved in the UX page for module views. Unless something has changed here. Thk you Ravinder

RavinderB

@YuriPinchuk few things to consider here: - importing - https://community.anaplan.com/t5/How-To/Things-to-consider-when-building-a-robust-import-action/ta-p/89067 Import breaks when we move dimensions from rows to columns or pages, and vice versa; as importing mapping/tab options changes; therefore need to understand pivots for importing. this effects the mappings and tabs in the import process; therefore pivots affect the import process views - the general concensus is to create custom views becuase: clear seperation of duties between model builder and end user who can create own custom views reduces model clutter and space, as views are know integrated in UX pages Conditional formating is more powerful in UX pages becuase of custom colours This is the recommended practise. Some advantages of model views: the ability to reuse them for multiple pages less load on end user Hope this helps. Ravinder.

RavinderB

@JagBrar Hi Two things to advise here: Set the summary method to none, which remove the aggregated total for the line item Use a Boolean filter to remove sparsity in the module, so you just see data in the module Regards Ravinder

RavinderB

Thk you @chilled0ut @JaredDolich

RavinderB

Thank you

RavinderB

Hi The general consensus is to create custom views in UX pages,my question: - are there things you can only do in model views in models v custom views in UX pages, or vice versa? I won't to know the limitations of both. Ravinder

RavinderB

Hi I have seen this in L1 also: - firstly explore the aguments required for LOOKUP: https://help.anaplan.com/f8baa402-606d-4764-a349-d8003fa383be-LOOKUP e.g. Values to lookup Number, Boolean, date, time period, list, or text line item - secondly once you beleive your mappings/arguments are correct; look at what you are trying to map : e.g if the list you are referencing does not have a top level, this will cause the error also: Hope this helps. Ravinder

RavinderB

Hi Another option you could explore is to have your time reqts set as lists, and use this instead of the standard TIME dimension. You will have to set these up as lists and import data accordingly; but this is a possible solution. Regards Ravinder

RavinderB

Hi You are correct, the week breakdown for time ranges is not possible. If you had a different calender type e.g. based on weeks; then time functions such as weekvalue, weektodate could help. I will try to explore further. Regards

RavinderB

Hi I would looks at the views created in the data hub and synch with the data in the supply chain model; especially process 9 which refers to 3 actions. As long as the data matches; this is OK. You could run the actions again just in case. Regards. Ravinder.

RavinderB

Hi You could create time ranges to modularize the calender settings ie https://help.anaplan.com/1d28b6e4-184b-4ba2-990c-defcaf65bde6-Time-ranges Here you create specific time ranges based on the time settings you require eg week 1, month 2 etc Regards

RavinderB

Hi Could you provide screen shots with your queries, so we can see what is in your module and what you are trying to do; this will make it easier to understand. You are bringing in product and dist centre data from a file import; the code line item refers to the code of the flat file in general lists Regards.

RavinderB

Hi You should have location data in both the data hub and spoke models: flat files. May need to check your data hub again. Regards Ravinder

RavinderB

Hi Your formulas looks OK, and your INV01 and 02 appears OK, but my numbers are lower in INV02. This could be an issue with data imports in relevant modules and your data hub - I would check this. What is your summary setting in INV02; when you change it to SUM:Closing Balance you should get numbers like mine.

RavinderB

Hi I would explore your inv01 module and your stock exceptions formula and summary setting. This may need debugging. Also sku08 module references to country made in and product family. Screen shots will help here Thank you Ravinder

RavinderB

Hii would explore the formula again, as another SUM is required; sum by product family of each sku ie 2 SUM functions This relates to the dimensions used in the model. Ravinder

RavinderB

Yes, this would be a valuable addition and make conditional formating more stronger for some customer use cases. We discussed this in L2 training today; especially the use of Transparency and colours. Ravinder.

RavinderB

Hi You can explore the below Level 3 Model Building Process Flow & UX Design Thank you

RavinderB

Hi You are using a classic UX here; but you can do this in the new UX using a view: simple create the view in the UX page or model, and customise it. Regrds Ravinder

RavinderB

Hi You will find completed UX designs and schema in the course, in the design lessons before you start your build. Eg prototypes, schemas Regards Ravinder

RavinderB · Re: Error on activity 1.3.10.2

Hi The module sys06 should look like this . May sure the code line item refers to the Country Flat list. You are importing the regions from the country file. I would also check you have created your flat lists correctly e.g. region flat, country flat, location flat.

RavinderB

Hi Not sure what you mean here; these are screenshots in the L2 course - DCA. Ravinder.

RavinderB

For Level 3 you can use your Level 3 Data Hub model as a basis for the Data Hub for Level 3. You can also download the Data Hub model in : 2.1 About the Data Hub Model : in the introduction to the course

RavinderB

In l3 there is a section on designing the User experience ie below; you will see the detailed UX pages required; you can upload your and compare yours with the examples provided. I would would explore these then you can proceed to the actual builds. Regards Ravinder

RavinderB

Hi When you login in the Anaplan Learning Centre, you should be able to see certificate e.g. below. If you can't, please email academy@anaplan.com

RavinderB

Hi The line item is the Role list (a general list and not a hierarchical list, like the size list). When you import the data from the file, the only data you require is the roles; everyhting else can be igonored. When you do this, the roles will appear in the module. Thank You Ravinder

RavinderB

@Markcol Hi I have replied to this in a previous thread and attached the file. thank you ravinder

RavinderB

hi You can use 'Match Names' for your time settings; as these are calender settings you can reference these directly as names. if they were different formats e.g. Y-M then you will need different format settings. Thank you Ravinder

RavinderB · Re: L2.3 3.3.12 Activity: Create Product Replenish...

Hi You will need to filter the main view(INV01) with the planning filters you created in the model: You can see above i am filtering the cust view with the planning period filter I created; so when you choose months in the booleans in the top view; only those weeks appear in the INV01 view Thank You

RavinderB

@SamuelLowVA Can you send me a screen shot of the module you are on and a screen shot of the activity also - this will hep me analyse better. Thank you Ravnder