About Kanishq17

Kanishq17

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

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 @CommunityMember128096 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

Kanishq17 · ‎08-20-2020

Hi @xin You can manualy map the item of source to target, or alternatively you can use codes for matching , in source model use same code for distribution total and distribution others in target model

Kanishq17 · ‎08-20-2020

hi @tlemond The SYS08 module should have a line item which gives relation between sku and product family that is list formatted to product family, you can then use that mapping as lookup

Kanishq17 · ‎08-18-2020

Thanks Rob, appreciate, however how to do if all periods is not enabled?

Kanishq17 · ‎08-18-2020

@keyyun627 Is the source data hub to Level 2 model?, you need to ensure for level 2 model, for the imports, source model is mapped to the hub model you created, you can establish mapping in source models of settings tab, else you can create a new import if that doesnt work

Kanishq17 · ‎08-18-2020

Hi @jbaudino1 Create another no formatted line item and put it 1 based on true boolean, then aggregate over that numeric line item using timesum

Kanishq17 · ‎08-12-2020

Hi @soukainawaraki You can create line item referring name of the employee and then sort based on that line item using sort ascending and then publish that to dashboard, when you will add a new employee and refresh , it will automatically be added based on sorted position This is my module in the db, Now added a new employee named Eva It got sorted to the required position

Kanishq17 · ‎08-12-2020

@anirudh @michael.chefer Thanks for the update, it seems that after that first sync , if we run a sync again, that issue doesnt come Anyways, thanks for letting me know

Kanishq17 · ‎08-11-2020

hi @praba71 There is an option to show totals at start Go to Data> Totals Position if you do before, it shows high level first and then child items

Kanishq17 · ‎08-11-2020

Hi Community, Since the past 2-3 days, we have had unexpected change after an ALM sync, which caused current period to remove in prod model, although current period is prod data, cant seem to understand why it is being removed. Any suggestions on how to prevent it

Kanishq17 · ‎08-04-2020

hi @bleeds Can you show your safety stock exception formula? because formula is correct for both exception count and then INV02, aggregation by country

Kanishq17 · ‎08-04-2020

hi @CommunityMember111277 , The territory list is already established in the sales planning model, it is a child of countries list, you can find more about it in the forums i guess

Kanishq17 · ‎08-03-2020

hi @tompatrickting Actually numbered list in Anaplan, even if codes are same in the source and target model, it doesnt mean that they point to the same item as numbered list item generated (#1 etc.) is unique for each Anaplan model, and different id is generated at the back for each model, so you need to actually map based on the name item # which will then look for the same # in the target model , So try to use column 2 to map to dum code list num

Kanishq17 · ‎07-29-2020

Hi @Leung What do you need?Can you be more specific

Kanishq17 · ‎07-29-2020

@kunal_311 You need to remove if PO submitted =0 part from the confirmed PO line item as you have already mentioned that PO submitted is 1 when submit PO boolean is true, hence only Post part is needed, for the amount you can use if PO submitted <>0 then post(order value, final shipping time weeks) else 0 Also I think you are missing the final shipping time part as @Misbah suggested