Hi Community, we want to integrate SAP and Anaplan, but client has asked not to use any files for integration, so is it possible to load the data from SAP to Anaplan with API in json format? and how to map the fields. Please suggest
... View more
Hi my model has 5 versions Rofc, Forecast. Budget, Simulator1, Simulator2.(list) Rofc contains data of actual month and future month (similar to native switchover). I am creating forecast between jun-sep every year using Rofc data of the current year and locking the forecast data of that year. Forecast can be created multiple time during this period in an year. I have to store last forecast creation date in every year(4 years). Can you please suggest an approach.
... View more
@ssicefox In finditem(list, text formated lineitem) function you are asking anaplan to find the list item in the list based on the text formatted line item which can be (display name or code) property of the list
... View more
Hi @jasonfortunato Both syntax are correct. In first you are asking anaplan to sum up the values across the time period of the module and then to check where the sum is not equals to zero. TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 In below syntax you are using three more arguments(start period,end period and aggregation method) along with Number line items. In current scenario it is not required to have these 3 arguments. TIMESUM(TIMESUM line items.Number, 0, 4, SUM)
... View more
Hi Anaplan, I have completed my L3 certification, I would like to know how much days it takes to reflect L3 Certification Badge in community profile. I have completed the certification on 22nd June.
... View more
Hi I have 3 Versions, and time as a dimension 5 years in modules. For Test Version1 I should see FY 19 and FY 20 past and current year. For Test Version2 & Test Version3 I should be able to see all time periods. For that I have created one filter(version and time specific filter) line item to filter the time based on the version selection This filter is working fine in the modules where time is in columns but I'm not able to apply this filter where time is in page selector. In new UX when I'm trying to apply this filter on time It is asking to select one of the version from the version list but it should be applicable for all version. Need workaround. Thanks in advance.
... View more
Hi I have 3 Versions, and time as a dimension 5 years. For Test Version1 I should see FY 19 and FY 20 past and current year. Test Version2 & Test Version3 I should be able to see all time periods. So I have created logic for Version and time combination and applying it in all the modules.
... View more
HI Abhay, I tried that as well but I'm not able to apply that as well, when I applied that filter on time It is asking to select one of the version from the version list but it should be applicable for all version.
... View more
Thanks Abhay for prompt reply, Based on the version selection the time period should vary. Actually I tried this in saved view but its not getting applied.
... View more
I need to filter the data in modules for Test Version(1) in current year. For that I have created one filter(version and time specific filter) line item in to filter the data for current year and Test Version(1). This filter is working fine in the modules where time is in columns but I'm not able to apply this filter where time is in page selector. Need workaround. thanks in advance
... View more
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 ....
... View more
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.
... View more
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.
... View more
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
... View more
@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 ]
... View more
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?
... View more
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
... View more
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.
... View more
@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
... View more
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)
... View more
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
... View more
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.
... View more
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).
... View more
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.
... View more
