About Kanishq17

Kanishq17

hi @VigneshStark , since you mentioned that the target has G2 Country as dimension and there is a mapping between SKU and country , the mapping is established in line item as country for each sku , so to populate G2 country with no of exceptions , sum will be used as to consider the exceptions of SKU for that country , so instead of lookup , use SUM to aggregate the values Thanks Kanishq

Kanishq17

Hi @louieczech There are some methods to achieve this , 1. In time settings , If CY is FY22 , you can add future year as 1 , so it will include 2023 in the model calendar ( note this will bring the time to 2022 and 2023 and all modules applied to time will have this timescale ) 2. Other option is to rollover the current year ( change the current time to 2023 ) , however this will mean that fy22 data will be cleared out 3. There is an option to create a time range ( it is a time option available ) , in that time range you can specify the year needed and also the aggregate methods can be different .

Kanishq17

hi @BapinB Most probably 1. Shipping cost is based on default shipping method and 2. Final shipping cost is based on final shipping method ( based on override ?) and then final shipping cost - shipping cost is the variance , Anyways having some screenshots will be beneficial, thanks

Kanishq17 · ‎10-11-2022

Hi @Csta If you want to apply dca to override forecast line item , then it should be an input line item with dca ( in blueprint ) based on boolean like override , so for example when override is checked , then forecast can be entered(write based on true value of override) else it will be locked

Kanishq17 · ‎09-23-2022

Hi @ryan_kohn Oh , thanks a lot , so it is correct then

Kanishq17 · ‎09-23-2022

Hi, formula seems correct as G2 country is parent of G3 location , so it will aggregate , make sure there are no spaces in referring the line item

Kanishq17 · ‎09-23-2022

Hi @Csta , can you show dimensionality of source module ( rev 03 ) , is it dimensioned by (g2 country)?

Kanishq17 · ‎09-23-2022

Hello Community , As a workspace admin , in a module for a line item , even on read access , it is noted that though values cannot be inputted manually , if we ran an action which loads in the line item , it is writing and ignoring the DCA example - source module target module - dca enabled , Running an import which loads from AOP one to forecast ( dca enabled ) Even after DCA is read , the action is updating values . Is this expected behaviour Thanks!

Kanishq17 · ‎09-12-2022

hi @abhishah Well this the best method , if the test is in sync and the functionality is working as expected , means you can move the changes made in dev to prod via ' compare and sync' . In prod model sync , you will be able to see the compatible source model and the RTs available to sync to prod , so you can select which RT to sync to prod ( in case multiple RTs available in dev model after last sync to prod ) , Thanks

Kanishq17 · ‎09-12-2022

Hi @abhishah The revision tag is a structural snapshot of the model and it is used to sync any model changes from dev to test/prod environment , since your test model is in deployed mode , structural changes cannot be made to it hence revision tag cannot be added , Is there a development model which is used to develop the functionality and then synced to test/prod models , if so , then you can directly synchronize the revision tag from dev to prod which is there in the test model as the structure for the models will be compatible if sync has happened in test and need to be pushed to production.

Kanishq17 · ‎09-12-2022

Hi @tonyv As i see in the mapping tab , you have mapped the product code field ( col 2 ) to location dimension and location code (col 1 ) to product dimension , hence Anaplan is unable to map the items as the columns are incorreclty mapped , so just interchange the options i,e map the location code to location and product code to product , then mappings will be populated ,

Kanishq17 · ‎09-12-2022

Hi @dlupasco Can you try to refresh your browser/disable popups etc. , anyways , This is the snip

Kanishq17 · ‎08-24-2022

So , the DCA is working no , it shouldnt allow to write when write dca is false , you can try adding default true as read dca and see if that helps

Kanishq17 · ‎08-24-2022

Hi @marcoscorral The error message highlights that the access to source workspace is not there , meaning that the import is from a model in a workspace where the user is not added , so if the user needs to able to import , you would need to check the source for that import in import settings , then provide the user with the relevant access in that workspace model ( can be read only as well) Thanks

Kanishq17 · ‎07-13-2022

Hi @JEEVAK Essentially if you are using a formula for line item , you would not be able to manually input values , however if your module uses native versions , there is a possibility that the formula can be restricted to be applied to only particular versions (Actual , or current ) etc. Meaning that for the other versions where scope is not applicable , values can be entered manually

Kanishq17 · ‎06-16-2022

Hi @143kishornaidu Sorry could not understand what you need to filter in target module

Kanishq17 · ‎06-07-2022

Hi @IrfanMohammed Summary "Formula" at the summary level means that the same logic which is used to evaluate at lower levels will be used at the parent levels . formula summary is used for percentage since percent should depend on the calculation values even at higher levels .

Kanishq17 · ‎06-07-2022

Hi @jspascual You would need a between the list 2 and list 1 and then use lookup to refer the corresponding display name for the second line which is mapped to the first

Kanishq17 · ‎05-23-2022

Hi @Zhiying Well list subset cannot be automatically checked , however you can create an import to load valid items of that list 1 which satisfy the subset of list 2 . Basically you can find which items in list 1 are valid for the subset based on the list 2 formatted property and then use a filter to create a view for list 1 which shows only those items which are valid , then import in the subset

Kanishq17 · ‎04-22-2022

@rohithnarayan Maybe you can use alternative like TY(This year) , LY(Last Year), LLY(Last Last Year ) etc. and in a landing page mention in a text like eg when switchover is done so F22 - TY , F21 - LY and so on.

Kanishq17 · ‎04-21-2022

Hi @Yueyi As i see you are loading master data information to system module , so time dimension is not needed in the module where you are loading , so you can set time setting to not applicable , this will remove the time dimension from the module , in this way

Kanishq17 · ‎04-08-2022

Hi @rob.arce Formula is coming as invalid since there should be quotes in the module name 'emp 03..'.'bonus%' , quotes are missing to enclose the module name and line item name

Kanishq17 · ‎04-05-2022

Hi @ryan_kohn Oh , thanks for the update , for the workaround yes it should ignore these values and should show 0 . Can you guide on this I would ask support on this

Kanishq17 · ‎04-04-2022

Hi , can you assist me in following , so i am loading a file with a column into a number formatted list property , in the csv file along with numbers some entries have text only while some entries have text along with number(as shown) , when i load this file in model , so all text lines are ignored , but somehow anaplan is taking only numbers from the lines where alphanumeric property is there after running the action for this list item , the property is 2411.2 , please guide as to how is this happening and what is workaround for this case

Kanishq17 · ‎03-30-2022

Hi @Magali so the logic is given in the descriptions and you need to use hold override from the target review module to derive the account target to be changed at country level in the country module , from there the factor will be used for the accounts to calculate their final targets From TAR02 account review , based on hold / override , you will calculate these lines , then they will be used in TAR03 Country calculation , factor will be (target - held or revised )/ to change , then this factor is multiplied to the account target for to be changed accounts to get final sales target

Kanishq17 · ‎03-24-2022

hi @neg177 The color coding highlighting indicates the numerator to be used and the denominator denominator is the sum of initial targets of all the accounts which will be redistributed ( not hold and not override ) Advise is to use the hold , override , to change line items of TAR02 account review to calculate the factor in TAR03

Kanishq17 · ‎03-17-2022

hi @tspoon So if you see the dimension of REP04 is on region , role and department , but your formula uses sum only for region and role , you need to use department mapping as well after that so that it is correctly assigned to department Hope this solves the issue

Kanishq17 · ‎03-10-2022

Hi @ntrddragn WHat you can do is create a list with "fruit , citrus and tangerines " as items , which will be the parent of the product line list then you can assign the product lines to the category via parent field , so values at parent level will aggregate automatically . Alternatively , if it shouldnt be a hierarchy , then you can establish a mapping between product line and category in a separate module (use category as list formatted ) and then aggregate in a separate module to the category list via SUM

Kanishq17 · ‎03-10-2022

Hi @PoojaGupta There are no leaf level items ( accounts ) , you need to add accounts to the list to see the data

Kanishq17 · ‎03-04-2022

HI @zaibhamid81 You can understand this better with the topic of security and management using roles , selective access , Please find attached for reference https://help.anaplan.com/8c495688-216e-49c4-aa56-a4b70487e5d7-Control-user-access-within-models the model roles and selective access tabs will help you out Regards Kanishq