About Kanishq17

Kanishq17

hi @mlecrivain this error is because when you add list items , it increases the size of the model in the workspace and when loading this list , the model size is exceeding the workspace size , so you can either reduce the model size in dev model ( summaries etc ) nd then link to uat model or enquire if workspace size where the model is located can be increased.

Kanishq17

hi @Sagar123 So , purpose of DCA is to limit the access of users in a module at a line item level (read / write ) based on boolean line items , so AD02 is a module where you will add line items that act as DCA for the inventory ordering modules take a reference of override shipping method? , so if the boolean of override ship method of a sku is checked , then only you can override the shipping method in the override ship line item else it is non editable , that is controlled by dca (write / read ) so in AD02 DCA module , you will refer the this boolean into the formula for setting DCA of override ship method line item then you will use that boolean in AD02 as write access driver for the override line item , similarly for the others , hope this helps a bit

Kanishq17 · ‎06-10-2021

hi @neg177 You can use the MONTHVALUE() function to pull month value across each day under that month .

Kanishq17 · ‎05-21-2021

Thanks Misbah for this

Kanishq17 · ‎05-21-2021

hi @abhay.kanik Tried that but new items are added in numbered list from the next index even if items are deleted

Kanishq17 · ‎05-21-2021

Hi Community , Wanted to ask if anyone encountered a case of list index exceeding limit of 1 billion for a numbered list which lead to items not adding to the list due to that and what is the workaround for it

Kanishq17 · ‎05-21-2021

hi @LStinsa Yes since you gave yourself write to 'ALL products ' , so you will have automatically write to all child items hence l2 is disappearing because you have write at top level can you refresh the page after providing SA to yourself , maybe the grids will refresh

Kanishq17 · ‎05-18-2021

hi @mstanisic You can omit the time dimension from the module , the 'has data' boolean has timesum formula which checks whether for any period the value is there in source or not , so the module from where you are taking timesum (source should have time dimension) , here value will come if you exclude the time dimension from blueprint for the target module

Kanishq17 · ‎05-18-2021

@LStinsa Thanks a lot .

Kanishq17 · ‎05-18-2021

hi @abzenkner in the new ux , the dimension as page selector are called context selectors which can be specific to only a particular grid as well as common for the entire page which is like synchronize selection for all grids in the page . Currently your context selectors are linked to the entire page .

Kanishq17 · ‎05-18-2021

Hi @LStinsa So the selective access is related to limiting what items user has access to on list level , it is independent of the role , even if you have full access role , if for a list selective access is checked , then for the user , you need to go in users section and provide write / read access of that list to the user . Role access is related to modules / actions which the end user can see. So as you told you had selective access enabled at p2 level , so yo need to go to users tab , there you will see p2 write / read against each user and provide access there For eg - this is list for which selective access is enabled and i have full access so wherever that list is used as dimension , you cant view the data if access is not given to user irrespective of role go to users tab and you can see for the list mark as selective access , column come for each user , so you can select write / read for that user and according to that data will come . hope this clarifies , for more knowledge on SA , please check this link https://help.anaplan.com/0d2d8efd-6112-484f-953c-4d017cafefbc-Selective-Access

Kanishq17 · ‎04-15-2021

hi @charlotte.chiasson , Actually the concept of production import / import sources doesnt impact on the action , so basically like production data can be edited in prod model , similarly any import which is production import can have mappings changed of import and it doesnt depend on the import mappings of the action in dev model , so if you change the mapping in dev for a import marked as production , it will not impact production as you can change the mappings there , if your underlying data is changing due to sync in RTs , it means that the data is related to non - production dimensions in the model , import wont be impacted

Kanishq17 · ‎03-05-2021

Hi , @MaheshKosuri use sum instead of lookup

Kanishq17 · ‎03-01-2021

Hi @Anaswara can you send screenshot of what you are trying to achieve?

Kanishq17 · ‎02-23-2021

Hi @lcapon Can you share screenshots for the same , check dimensionality between source and target modules , in your case , you need to set a mapping for users dimension in target module using list formatted line item and then use lookup

Kanishq17 · ‎02-12-2021

Hi @neg177 , you can create a second line item and multiply the imported value by -1, and use that calculated line item

Kanishq17 · ‎01-20-2021

Thank you all, Its amazing to be part of this lovely ecosystem

Kanishq17 · ‎01-18-2021

Hi , You can create a new line item and use formula , if value<>0 then value else previous(value) and then in module refer that line item[select time.'dec 20'] to get value of last month of timescale which will be last non zero value, alternatively , you can use all periods and select time summary as time:closing balance

Kanishq17 · ‎12-08-2020

Hi @TulasiNayak Kindly check the mapping for time in mappings tab, if file is in mmm-yy format, it wont map with match names parameter as in anaplan time is mmm yy, so you need to choose custom mapping option and write "MMM?YY" in the custom mapping, so mapping is established correctly, something like this

Kanishq17 · ‎12-08-2020

hi , in lookup parameter, dont use next(), next() is itself a time function, directly use next(line item) to fetch next months value, alternatively, offset() can also be used

Kanishq17 · ‎10-08-2020

Hi @razvanalex99 You can use combination of account name and territory name as unique key to import in the list

Kanishq17 · ‎09-23-2020

Hi @neg177 Yes the formula is correct

Kanishq17 · ‎09-04-2020

Hi @CommunityMember131357 It should work fine, as @Misbah , instead click on the top level item of the production list

Kanishq17 · ‎09-04-2020

Hi @Sampriti.Anand You need to use the parents code to map to identify parent as it is a numbered list

Kanishq17 · ‎09-02-2020

Hi @MadhabikaM Alternatively, you could have used movingsum with any aggregation method PFA the snip, Hope it helps

Kanishq17 · ‎09-02-2020

Hi @Pankhuri Is levels list a property of account items list or levels is a separate list and present as List formatted line item in account item module. In that case , if you to aggregate level values by account, you need to find account name using finditem, and create a number formatted line item and convert levels number which is list formatted to a number format using value(name(levels)), then aggregate based on account in the target module

Kanishq17 · ‎08-31-2020

Hi @sandrajcp You can create a line item formatted by time and map it to dec, then create a line item to select phasing value for the mnth if non zero else lookup the dec month line item value

Kanishq17 · ‎08-24-2020

hi @sguptatalkingrain Ensure in the source view from where you will import, all columns are there which are needed to import to, in case distribution center is not coming, ensure you have that column in the source model view

Kanishq17 · ‎08-20-2020

hi @Jojo88 You can create an additional line item list formatted to the C4 list, and map the 3030 line item to the 2020 item and map rest as is, then in target module, do sum based on that line item

Kanishq17 · ‎08-20-2020

Hi @TomQueens It seems correct, just ensure you are using post instead of offset for Confirmed PO line items , you will get a file to upload the boolean submit po?, which will enable beginning inventory to correct