About Kanishq17

Kanishq17

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

Kanishq17 · ‎07-29-2020

Hi @kunal_311 So there is an issue in the Confirmed PO formula, PO submitted is 1 if Submit PO receipt is ticked, then you are mentioning if PO submitted =0 then 0 else post PO submitted, so it will check PO submitted for every week and based on that value of Post is applied, since in week 3 Submit PO is not ticked, hence PO submitted =0 , so value is 0 as if condition is getting satisfied , so you dont need the if part as already in PO submitted you have mentioned that, directly post the PO submitted by the final shiping time weeks, as suggested by @Misbah Hope it helps.

Kanishq17 · ‎07-20-2020

@praba71 After finding blank entries in all 3 modules using isblank(config item), you can create a separate list of the items via action and then combine 3 actions(for 3 modules) in a process. In case any same items are there , they will be ignored.

Kanishq17 · ‎07-10-2020

Hi @ifeldman Just use DATA02 Input volume.volume as formula in the rev02 line item as it is direct reference

Kanishq17 · ‎07-09-2020

@ifeldman Hi, I believe you can directly refer from the input data module as there dimension is at P3 SKU and target is at P2 product, so since P3 rolls up to p2 , the value will automatically be aggregated so use input module.line item in REV02

Kanishq17 · ‎07-09-2020

Hi @j_hanfrey I guess the file is available during the sprint 3 exam, have you started the exam, in that there was a question where this file is provided and on basis of that question has to be answered

Kanishq17 · ‎07-07-2020

Hi @Kevinc107 Your source module is dimensioned by department and role and target is dimensioned by employee , so in order to refer value , you need to esatblish mapping between all source and target dimensions , so in the lookup formula, you must use department and role mappings of the sys 08 module ans make sure they are list formatted to the department and role dimensions

Online Status	Offline
Date Last Visited	Friday