About Misbah

Misbah

@ArunManickam Reason I like spending time with our community is that we get to know how one thing can be achieved in multiple ways. Amazing! All the points that you raised are valid. Point 1 is the best case scenario. Point 2 we try to avoid most of the times as it goes against best practices. Point 3 Your approach relied on IsFirstOccurrence. This has its own limitations, can't use this on a data set more than 10 million transactions. Also there is a performance issue if the data set is more than a million. Now that's debatable if we should use IsFirstOccurrence on Transactional data Regards, Misbah

Misbah

@Saksham.Bansal No, there is no such feature to Word wrap it and break it into multiple lines. One thing that you can do is to increase the column settings of the that line item and make it 350 Even Admins don't have flexibility to break the long text in line items into multiple lines Hope that helps Misbah

Misbah

@ArunManickam I think you are missing a point here. How is the GenCon List getting created in your solution? As per @Jsdeloria21 he has unique codes in the source file for Gencon List which will reject all the duplicate entries i.e., 422 will be created just once in the list. I was under the assumption that 422 is just a display name and the underlying code for each 422 is different but that is not the case. Let us know you thoughts. Misbah

Misbah

@Jsdeloria21 I will leave that upto you how are you going to bring duplicate IDs into your list. It can be done in Anaplan but by bypassing the best practices (Combining the properties) which can't be advocated & If and when you do below solution will work for sure. As @rob_marshall highlighted the importance of getting it done within the source system the first priority should be to get it done within the source. Thanks, Misbah

Misbah

@sachin_mohandas You have to be The Anaplan Way (TAW) certified to achieve certified model builder status. Once you achieve that then there will be a level 3 exam/certification (coming soon) which every aspiring solution architect has to pass. Post that there will be one more technical exam for solution architect which I believe will be a paid one. You can track your journey on learning center. Thanks, Misbah

Misbah

@vikas1 Are you trying to duplicate the list? Because you are trying to create a list based on same codes and same parents of source numbered list. If you have any such requirement then you need to assign the same parent of the source list to target list and then import the children. And please do not import from list to list. Instead create a module & then saved view and import the data from Saved view to the target List Had to delete previous reply as I misunderstood your question. Apologies for any inconvenience, if any. Thanks, Misbah

Misbah

@CommunityMember119883 Can you please check if you are going to Data Hub Model. It looks like you are picking Level 2 Supply Chain model as a source when the ask is to get it from Data Hub. Thanks, Misbah

Misbah

@Jsdeloria21 If you are trying to load Gencon lists by mapping codes then what is the diff between your gencon list and inventory list, and why the need of inventory list - both will have unique codes.How are you getting two 422's in the Gencon list? You will have to have two diff codes for two 422's but you can have a same display name. The question that you asked about transaction ID line item - it pulls the display name of the gencon list and not the code of the General list because that's the only way you can have two 422"s in the list. General List is only to change the text formatted line item to List Formatted line item and thence to use SUM & LOOKUP. Regarding your blank results can you please post a snip of your module. Thanks, Misbah

Misbah

@Jsdeloria21 Follow the steps Step 1 - Create a dummy list with transaction IDs. Lets call it (General list). It can be a one time set up, either you load from transaction ID line item of GenCon Module or simpy insert the numbers from 1-1000. You can scale it as per your need. Step 2 - Go to GenCon Module and Insert 6 Line items i.e. a) Count - Hardcode it to 1 b) Find out Valid Transaction ID - This is to convert text formatted line item into list formatted (General List from step 1) c) Sum the count - Use SUM & LookUP here. Remember you can split sum & look as there are some known performance issues with the combo This is only for Demo purpose d) Final Status - Use the logic that you described above. I have written based on what you posted. e) Final Transaction ID - If Final status is not blank then shows the result f) Final Flr Area - If Final Status is not blank then shows the results Step 3 - Import the line items into Inventory Module based on Final Transaction ID, Final Status & Final Flr Area Hope this helps Misbah

Misbah

@vikas1 If I may ask why is there a need to import a list from another list. One there is no filtering out options from source list & you will be replicating the target list, second Anaplan will create an error log if there are any ignores/failures which are highly likely in this scenario. I would suggest you to create a module based on the source list, create a saved view by filtering out what you don't need and then load the target list from the saved view. Ofcourse by having Code in the saved view and mapping code only, keeping your Name blank or unmapped on the mapping page as it is a numbered list Thanks, Misbah

Misbah

Hi Frank, Thanks for giving us an opportunity to interact directly with you. Would like to take this opportunity and ask a question about NUX. Since we are moving away from classic UI and inching towards full fledged NUX how confidently should we advocate New UX to our clients, considering there are a lot of things that are yet to come in NUX including drill down feature on Cell value and ALM functionality. Is this is time when we say we completely do away building UX in a classic way going forward? Thanks, Misbah

Misbah

@sandeep_bk It should reveal the module name as well. Here is the snip of the export (See blue highlighted ones) Thanks, Misbah

Misbah

@Varshni One question on your query, why are you bypassing the aggregation that Anaplan does for you. In Child module you would have composite hierarchy (Child List) as a dimension which will sum all the child values into parent ( Bottoms up approach). Having other input module at the Parent level you will have to have the disaggregation logic in place (Top down approach) considering your Target Module will have Child List as a dimension. Lets say for example - If your P1 has 500 in P input module & C1 and C2 has 200 and 250 respectively in C Module what do you want to see in C1 and C2 of Target module. Thanks, Misbah

Misbah

@sandeep_bk There is no specific way that you can achieve that in Anaplan. Couple of options that you have already tried are having a code for line item and Checking Modules ->Line items glossary. One more option is taking the export of all line items and filter it outside Anaplan Thanks, Misbah

Misbah

@shadmani Can you post screenshots of the error message and Import mapping page. Thanks, Misbah

Misbah

@CommunityMember117741 Not sure if I get the statement when you say " due to the line items having different format I cannot apply the logic". I have created a small mock up for you. Let me know if this helps. 5f Official Customer ACV Module - Dimensions are Accounts(Let's assume), three data related Line items and one line item Customer formatted as Customers List OC Expected Renewals Module - Dimensions are List A, Customers, Hand. Now if I have to pull the data based on the Customers I will have a formula written as below. This assumes that the Customer List which is the dimension of this module is exactly the same which is present in the List Formatted Line item of Previous module.Nested IFs can be avoided in these scenarios as this is just for demo. Now if you are saying that the Customer lists are different then you will have to create a mapping table between these two Customers List and Use SUM&LOOKUP to pull in the values. Thanks, Misbah

Misbah

@CommunityMember117741 Apologies in advance if I misunderstood your question. If you are trying to pull in the data from 5f Module into OC module & if Dimension of the OC module is same as the List formatted property of the 5f module the you should use SUM instead of Lookup & your formula should be If 'List A'.Blades THEN 5f Official Customer ACV. Target value [SUM:5f Official Customer ACV. Customer ] ELSE BLANK & NOT If 'List A'. Blades then 5f Official Customer ACV. Target value [lookup:5f Official Customer ACV. Customer ] else blank. Let me know if that wasn't the case. Thanks, Misbah

Misbah

@iWonder You will have to create one line item for each list and create a process to delete all the accounts and their associated parents. Step 1 - You have developed it already. Step 2- Create another Line item dimensionalized by Parent of Account and pull the information from previously created line item in step 1. Make sure the summary of Line item 1 is kept as "All" and NOT "Any" or "None". You can have a subsidiary view in the same module or you can build another module. Step 3 - Repeat Step 2 for Parent of Parent Accounts and so on and so forth Step 4 - Create a Deletion process in the same order Hope that helps Misbah

Misbah

@arti.kalekar Not sure if there is any documentation available for it, I will let other champs chime in here. However here is a small video on Hyperconnect here https://community.anaplan.com/t5/On-Demand-Courses/HyperConnect/ta-p/54528 Hope this helps Misbah

Misbah

@UMAMAHESH123 There is a reason why Anaplan wants you to confirm if you want to take model out of deployed mode - it is risky. As explained by @Jitendra.Vishnolia you can do it either way. If you don't want to restore the history and then you can go to Prod Model - Revision Tags => Revert to Last Revision. It will undue all the structural changes in the Standard Prod Model, post which you can put the model in deployed mode and that should solve your issue. But If there was a RT created directly in Standard Prod model then you will have to make a new Dev model from the "Create model from Revision" Option under Revision Tags and use that for ALM. Hope that helps, Misbah

Misbah

@atoh No, haven't experienced it or haven't heard anybody highlighting it until now. I mean there are other issues with Add in 3.3 but not the crashing one. You can do few things - You can uninstall it and then reinstall it and see if that fixes the issue. Check your .Net Framework and make sure your .Net Framework is 4.7.2 or above If nothing helps then it might be worth raising a ticket with Anaplan Support (support@anaplan.com) Thanks, Misbah

Misbah

@CommunityMember115525 And the Answer is "To Version or Not to Version?" by @DavidSmith. https://community.anaplan.com/t5/Best-Practices/To-Version-or-Not-to-Version/ta-p/51410 You can thank him:) Hope that helps Misbah

Misbah

@Sasikanth.Busanagari If the user needs Read Access to Component A and Write Access to Component B you can achieve that by Navigating to Users and apply Read Access on Component A and Write Access on Component B Thanks, Misbah

Misbah

@Sravan_Kumar Ctrl+Z Function should help Thanks, Misbah

Misbah

@anirudh Thanks for Crafting this. I would say that this can definitely solve the issue but l would still recommend not to go with this approach. Reason being we are bypassing Best Practices at two places: 1. Creating unique keys within Anaplan using combination of properties. It can work fine as long as there are a few transactions but it might hamper performance as soon as the list increases.You are also prone to create text formatted properties. As we know we should try to minimize the usage of texts in Anaplan. 2. Deleting the list holding data using "Delete from list using Selection" function. This function has to create a log everytime action is run and increases the processing time and goes against best practice. Thanks, Misbah

Misbah

@swoods93 As far as I understand you will have to create another column to fill in the blanks and use that for rollups as you rightly mentioned. Hope that helps Misbah

Misbah

@rdixit Yes you are right on track. One thing I would like to add though,create a copy of Dev Destination model from RT of Prod Destination model and then change the mapping in Import Data Source of Prod Destination model. This way you will retain the mapping of Dev and change only for Prod. Hope that helps Misbah

Misbah

@mooreta First of all thanks for putting it out You already have posted great solutions. I will personally go with approach 1 because that is typical case of "why should we aggregate the data in the source system or outside Anaplan. Yes, we can handle it with approach 2 or 3 but I will stay away from these approaches because holding data in the list properties or creating text formatted line items to hold the data & Converting them goes against best practices. Would like to hear @rob_marshall 's take on it. Thanks, Misbah

Misbah

@ArunManickam Here I have created 4 Line items i.e., Line item 1,2 3 & 4. Line items 1 and 2 need to be zeroed out and Line items 3 & 4 needs to be updated. Below snapshot is before loading the File Step1 - I load the file as usual into the module. Snapshot of file is as below Data gets loaded into the module as usual. All the cells gets updated as of now Step 2 - I have created two more line items i.e., Line item 5 & Line item 6 with No Data format. Step 3 - Created an import which mapped Line item 5 & Line item 6 to Line item 1 and 2 respectively & ignored Line item 1 and Line item 2 in the source Step 4 - Create the Process of both these imports and put them in the same order and Run it. Step 5 - See the results in the Target module. Line 1 and Line 2 are zeroed out and Account 3 and Account 4 are updated in Line 3 & 4 Thanks, Misbah

Misbah

@wquan 1- 2 Years Actuals 3 - 4 years forecast CPG, IT PB&F, S&OP Off lately we came across one use case which was talking about having timescale upto 2080 for DCF. Read this out. https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Discounted-cash-flow-with-data-out-to-2080/m-p/54365#M8598 Thanks, Misbah