About swapnil_J

swapnil_J

@JaredDolich Thanks for the clarification and for the solution as well.

swapnil_J

@JaredDolich thanks for the solution, I would like to understand the erratic behaviour of the substitute function.

swapnil_J

i have list with codes in a test module I am trying to replace last digits of code by +1 using substitute function but i am getting result- A1B1_1 ->A2B2_2 ----incorrect A1B1_2 ->A1B1_3 ------correct A1B1_3 ->A1B1_4------correct A1B2_1 ->A2B2_2 -----incorrect A1B2_2 ->A1B3_3 -----incorrect A1B2_3 ->A1B2_4------correct first, i am extracting number after "_" then incrementing it by +1-> incremented value line item substitute function--> substitute(code line item, logic to find character after"_" , incremented value line item) please suggest approach to address this ....

swapnil_J

Hi @MarkWarren there is requirement I have main list where I have all list items A1,A2, B1, B2, C1,C2.. I am capturing data with opposite to each list item, but based on the percentage i need to allocate the cost of A's and C's in B (ignore percentage for now) so I have created mapping module to map All A and C to B Here In cost line item I am entering cost specific to B In Total line item i want to sum B and cost of A and C into that specific B.

swapnil_J

Hi, I have a list with items A,B,C the data of A should be mapped to B and the data of C should be mapped to B. and it is 1:N mapping A1->B1 A1->B2 A2->B1 A2->B2 C1->B1 C1->B2 C2->B1 C2->B2 I have done the above mapping by creating a concatenated list but I am not able to fetch the data by using this mapping to target module dimensioned With B (list subset). need alternative way to solve it.

swapnil_J

@Suneela yes, data can be populated using one of these two line items.

swapnil_J

Hi @Suneela First, you need to populate data in list formatted line item -. Product flat line item using list property. now to populate the data in P2 product you can make use of the Product flat line item in finditem function. https://help.anaplan.com/en/1933a49b-40a1-4575-8dd8-0b859fd3a05b-FINDITEM

swapnil_J

@Misbah Actually I don't want to create subsidiary view because using this two line items i'm creating two booleans and based upon their value 3rd boolean will be true/false. but when i create subsidiary view i'm not able to access the boolean which i have created using line item X [not able to access boolean value of c,f using lookup ]

swapnil_J

I have List items of list X- A,B,C,D,E,F List items of list Y- A1,A2, B1,D1 ,D2, E1 (Child list of list X) here item C,F don't have any child . I'm using List Y in a Test module line item1 - displays all list item at child level (i.e list item of List Y ) line item 2- I want to display all list item from list X issue-> i'm only able to fetch only those list item from list X which has child (tried using parent function) how can I fetch all the list item from parent list in this module?

swapnil_J · ‎01-29-2021

Sorry for the confusion List items of list A- A,B,C,D,E,F List items of list B- A1,A2, B1,D1 ,D2, E1 So here item C,F don't have any child. Boolean 1 will be true for A1,A2, B1,D1, D2, E1 Boolean 2 will be true for C and F and Third Boolean will be true based on Boolean 1 or Boolean 2

swapnil_J · ‎01-28-2021

Problem with this approach is that I am only able to fetch the list items from parent list(List A) which has child in List B, But instead of that I want to fetch those list item from list A which doesn't have any child.

swapnil_J · ‎01-28-2021

@CarolWG In your Data Hub Model in SYS07 Location Details Module apply a filter to get Distribution centers, then show Default Shipping Method line item, you need only this line item -save this view. Import this into SYS07 Distribution Center Module

swapnil_J · ‎01-28-2021

Module dimension List B Boolean line items 1)checks child is present 2) parent with no child 1)checks child is present -> List B 2) parent with no child -> dimension List A (subsidiary view)

swapnil_J · ‎01-28-2021

I am Working on a Test Module dimensioned with List B which is child of list A; There are some list items in List A which doesn't have any child. In Test Module I have created two Boolean which 1)checks child is present 2) parent with no child and I have created 3rd Boolean which will be true when 1 or 2 is true, but I am not able to fetch 2nd Boolean values as there is mismatch in dimension(because parent list items don't have any child so parent function is not helpful). Slight hint will be helpful Thanks

swapnil_J · ‎01-16-2021

HI @rob_marshall Take the same example and suppose I want to do the import based on the last list item that I added into that list (the extra list (dimension) in the target module) then what should be my approach? I believe it is not user friendly to ask end-user for which list item he has to save the snapshot when your list has more than 20 list items.

swapnil_J · ‎01-06-2021

Got It @Misbah Went through the user story again and caught the error, Initial and Final Country Sales Target Should not be Changed.

swapnil_J · ‎01-06-2021

Hi @Misbah As per the user story, the Numbers for segments should come after Final account Sales Target but in check your build they have provided the numbers based on Initial Account Sales target. What numbers should I take to move ahead? User Story 1.6 As a Regional Sales Executive, I need to see how a country’s Final Account Sales Targets for the year are distributed across the different account size segments (Small, Medium, Large).

swapnil_J · ‎01-04-2021

My Approach is - calculate Redistribution Factor based on initial Account sales target,Hold and Override Value in TAR03 Country Account Calculation Module, and then use the Factor in TAR02 Account Review module but when I am trying to Access the Factor line item for calculating Final Sales Target with respect to country in TAR02 Account Review module getting Circular reference error, need the slightest hint to avoid circular reference error.

swapnil_J · ‎01-03-2021

It can be done this way also, but have to work with multiple lookups.

swapnil_J · ‎01-01-2021

Instead of changing the formula of ID line item you can make use Product Flat line item to find P2 Product.

swapnil_J · ‎12-09-2020

@rob_marshall Thanks Rob.

swapnil_J · ‎12-09-2020

@rob_marshall Thanks Rob, I am not able to visualize " what you have to do is "hide" the creation of the code action in another process.

swapnil_J · ‎12-08-2020

What Happen with code of child list when we assign list item to Parent using assign action?

swapnil_J · ‎12-04-2020

Hi! You should keep Safety Stock Exception Count line item. It will give you total number of exception occurs during the period.

swapnil_J · ‎11-17-2020

@Akhtar.shahbaz Thank you for the solution, I was not getting the actual values because my summary method was set to none for both -main summary and time summary in the Data module.

swapnil_J · ‎11-13-2020

@AWhitworth I have already tried above formula but not able to get the values, so I changed that formula to - if start()<= currentperiodstart() and IF ISACTUALVERSION() then DATA01.Line Item else Source.Line item but still not able to get the values for FY19.

swapnil_J · ‎11-13-2020

@rob_marshall Hi rob, thanks for the version part apart from version there is mismatch in time dimension as well My source module is dimensioned with time range FY20, FY21 and target module is using time period FY 19, FY20, FY21 Data module has time FY 19. and in target module for FY 19 I am trying to populate data from Data module, but it shows 0 and for FY 20 , FY21 cells are correctly populated with source module line item.

swapnil_J · ‎11-12-2020

@Misbah As there is a mismatch in Time and version in both modules, I am not able to get the desired result. Earlier in my target module, I have tried this formula - if start()<= currentperiodstart() and IF ISACTUALVERSION() then DATA01.Line Item else Source.Line item

swapnil_J · ‎11-12-2020

My source module does not have version and has time range FY20, FY21 and target module has version-actual, forecast and time period FY 19, FY20, FY21 I want to reflect data from Data Module in the actual version of FY19 only, while data of FY20, Fy21 Data from source module should reflect forecast in the target module AS per my understanding same Data from source module will reflect in all version of target module, while data for fy 19 will show 0. Current period is SEP 19.

swapnil_J · ‎10-09-2020

hope this might help you, but first, you need to apply a filter for the line items