About Misbah

Misbah

Here is the list of feature that were released during April 2021. “Ignore Unmapped” Button for Imports: Working with User List: It is now possible to work with User List and perform calculations. New calculation functions include SUM & all other aggregation functions like TEXTLIST, FIRSTNONBLANK, LASTNONBLANK, ANY, ALL, AVERAGE, MIN, MAX. You can also use LOOKUP, CUMULATE, ISFIRSTOCCURRENCE and RANK with Users List SUM Example: “Update Current Period” Action: New Action has been added to the Action section taking the tally to 11 different Actions. With this action you will be able to update Current Period on the Main Time Page of the model. Here is what you need to do to set up this Action New Order of Columns in Module Blueprint: More Intuitive with your needs with Format being the first column followed by Formula, Summary, Applies etc. New APIs for ALM: These APIs reduce manual effort, increases flexibility & allow for greater integration with source systems. With these APIs you can Change a model’s online status - Use this endpoint to change the model’s status between online and offline Create a model sync task - Use this endpoint to set up and execute a model synchronization task (model sync task) Retrieve latest revision - Use this endpoint to retrieve the target revision ID needed for your model sync tasks Retrieve compatible source model revisions - Use this endpoint to retrieve and select the source revision ID needed for your model sync task Retrieve model sync task info - Use this endpoint to check the progress status of your model sync Also none of these features which were targeted for April 2021 have been delivered. I will update this thread if I see any discrepancy.

Misbah

@YuyaoWang It says that for 11 transactions departments were not identified by the system. Now this could be because of the difference in the names of those departments. Verify if the departments in the file are matching exactly with the departments that are in the E1 Departments list - if not then correct it. That should resolve the issue Misbah

Misbah

@YuyaoWang Formula looks ok which means either the inputs are not correct in SYS08 module or else Calcs are not working as expected in the EMP02 module

Misbah

@rob_marshall None from You? 🙂

Misbah

@brettnish Point 1: Yes even I think so that we should have an ability to move the tabs. You can share your idea on idea exchange forum Point 2: Good one but could you please explain what benefits will it bring to the table i.e., to have their own tabs rather than going back to their respective commands. Modules need to reference General Lists and/or LISS hence the need to open them side by side so that it becomes easy for model builders to point and click. Misbah

Misbah

@JussiLi Agreed. You were not alone

Misbah

@andrewtye It was a tough choice for me to pick those two. I had these at 3 and 5 respectively. Ctrl+Shift+F is a powerful feature - For wider audience this feature allows us to quickly search and open any artifact (Modules, Lists or Dashboards) within the model. Loving it:)

Misbah

@ChrisHeathcote I don't think we can or atleast I am not aware of any such feature being released. We surely can use certain calculation functions with the User list but I don't think we can extract first name and last name properties of the list. Misbah

Misbah

There are so many things that I loved about new modelling experience but here are my top two picks which I loved the most. 1. Ability to open Lists, Line Item Subsets, Modules and Dashboards in their own tabs. This removes the need to go back and forth between Modules->Lists->Line item subsets. 2. Line item Subsets(LIS), being carved out of General Lists Section & getting their own well deserved place. What's your favorite?

Misbah

If you have been using New UX for quite some time you would have probably realized by now that Models and Apps are two different entities/sections within Anaplan and they are not connected to each other by default unlike Classic UX where Dashboards were part of the same model and were always connected or attached to same model. If you had to archive the model and bring another model online for end users that was pretty simple an exercise. In New UX that is not the case because New UX is sitting outside of Anaplan Models. Currently, as soon as you archive the model all the underlying pages of the app that use the model vanish from the app or the entire app gets vanishes if the whole app is based off of only one underlying model. This article covers how you should change the source model of an app if the model needs to be archived. First of all let’s understand what happens when the model gets archived. Screenshot of a Page - Before the model was archived Page - before the model was archived Screenshot of Pages Section – Before the model was archived Pages Section – before the model was archived As soon as the model gets archived, End user gets to see below error message if they have this particular page open and if they refresh the browser or move back to Page Section of an App the page vanishes from the app. However If you wish to bring back your archived model all the pages of an app or the entire app becomes visible to end users without any issues. But what if you want to bring another model back live and archive the current production model. Here is what you need to do Step 1: Before you archive the model (Model A), create another model (Model B) from the latest revision tag option. This is an intermediate step which is required so that you can change the source model of a page/s to this newly created model. Step 2: Change the source model of a page from Model A (that needs to be archived) to Model B (that was created from the latest revision tag in step 1) Step 3: Archive Model A. Step 4: Bring the new Prod Model (Model C) live for end users Step 5: Change the source model of a page from Model B to Model C Step 6: Repeat Step 5 for all Pages within the app that were using Model A as an underlying model.

Misbah

@SwathyShankar Unfortunately you can't pick and choose your changes within the Revision tag. However there is a process which we generally use in hotfixes. See this article below - it should help you Save Incomplete Changes when Synchronizing in ALM - Anaplan Community Misbah

Misbah

@sarah.esguerra In the Test Model If the lists (which you uploaded) were marked as Production Lists before the upload then this error shouldn't have come but if that is not the case then this change is considered to be the structural change which basically means that your Test Model is not compatible with Dev model anymore. What you can do now is that You can go to the test model -> Revision Tags-> Create Model from Latest Revision and create a new Dev Model. Misbah

Misbah

@brookec See if this helps I am checking Last Occurred Value based on the Cost Centers. Here I am using Anaplan system generated ID's to get to the highest underlying number

Misbah

@ankit_cheeni Yes I confirm that is the current behavior of Anaplan. WSA bypasses the selective access security - Idea has already been shared on idea exchange forum not to bypass this. It seems to be on the roadmap. Import action should not ignore Selective Access f... - Anaplan Community Misbah

Misbah

@ankit_cheeni You can have Users as a dimension and the using the action. Also It is not the good practice to allow users to use that kind of action (even without user dimension) which does all sort of heavy lifting. I use this exercise mostly for optimization purpose only and I usually I ask admins to take care of that. Have you thought about using selective access on the state list so that only the user who is supposed to override/delete the values should be able to do it. And for overriding you can create a line item (Formatted as NO DATA) and run the import action. Hope that helps Misbah

Misbah

@Giovanni4 Looking at SS, it doesn't tell anything - could you please share the details section of Import error log. I would say it might be because of the Saved View - which is displaying the parent values as well. And those parent values are getting extracted but getting ignored in your target module Misbah

Misbah

We Know that the Roles->Lists Section need to be checked when there is a need for an end user to edit the list and the list here would mean Production List. Idea I am proposing is to lock down the Roles->Lists enabling feature for all Structural Lists so that WSA's don't get the option of enabling it. This way Anaplan will not pre allocate the buffer space due to the mistake the WSA's make while applying model security

Misbah

@neg177 Could you please share the screenshot of your module. Excel formula looked simple but Anaplan it is pretty complicated

Misbah

@dsoomar002 I swear I have been writing on this for a few days now. See post below but to answer your question yes it doesn't search with code as of today Unleash the Power of Find Feature on New UX - Anaplan Community Misbah

Misbah

If you are an avid user of New UX you would have probably noticed it by now that there are many search functionalities (seen as magnifying glass icon) on a page be it Board or Worksheet. There are similar features on the Home page as well which searches thru all the models, apps and pages. However this article covers only the search feature on pages. Let’s try to understand each of these with one use case. Option 1: You can see this feature on top left corner of the Worksheet page & every grid card of the Board Page. This feature allows you to search thru the entire grid of the page. Remember this feature works on one grid and not the entire page. If you have secondary grid on the worksheet or multiple grids on the Board you will see those have their own magnifying glass on top of it. Worksheet: Board: Here are some of items that can be searched: Line items in the grid Any items of the module dimensions. It can be list and/or Time, Versions as well. You can search with the Code as well as the Name of the list item Parents of any items of the dimensions. You can search with the Code as well as the Name of the list item. What you can NOT do with this search is to find what’s within the grid or module (Numbers, Texts etc.) Option 2: This feature allows you to search thru the the context selectors. If it is a dimension then its items and all of its parents can be searched but only with the Name. You can NOT search here with Codes. This can be found on both Worksheets as well as on Boards. Now let’s talk about the use case Problem Statement: There was a two level Product Hierarchy (Product-> Quote) and Customer was an attribute of Products. The client had asked us for the feature that would allow them to search with the attribute of the list (Customer) in a hierarchy. Solution: It could have been done via filter but that would mean additional selection from the user on top of the hierarchy selection which was not good for End User Experience. Here we unleashed the power of Find Feature of Worksheet. Before we could use it we made a small change and that was we suffixed the Product code & Quote code with the Customer (concatenation of the Product code with the Customer & concatenation of Quote code with the Customer). Now when the client searches with the Customer he gets all the Products and Quotes associated with the Customer. And all this in just one click without going into context selectors for selection

Misbah

@CommunityMember125605 Do you want to normalize it or just calculate the seasonality within the same Year? Share your use case here with examples, will try our best to see if that can be achieved. Misbah

Misbah

@fabien.junod Should be here soon. Update Current Period: This is the action that was added to the ACTIONS section of Anaplan. You can create this action by supplying one SYS module (with No Dimensions) having one Line item formatted as Time period. For more info see this Link 2. Perform Calculations with User Lists: Here I performed a few calculation using SUM, LOOKUP. You can also use FIRSTNONBLANK, LASTNONBLANK functions with USERS list. However you will not be able to get the top level information of USERS list. EXAMPLE 1: LOOKUP with USERS Source Module Target Module EXAMPLE 2: SUM with USERS Source Module Target Module: You might see something on this from @rob_marshall as well. Hope that helps Misbah

Misbah

@fabien.junod No, You are not alone - it Indeed has changed. Format is the first column now. Updating Anapedia takes a day or two - lets give them this much time and see if we have this updated by tomorrow Misbah

Misbah

@rob_marshall Late, because I was creating Screenshots for @dsoomar002 .You have everything ready.

Misbah

@dsoomar002 Just turn the summary option off (by disabling then Boolean in Blue print view of that module) for Number 4 line item .That should fix it Misbah

Misbah

@zolzaya In mapping window, click on the boolean checkboxes, it will open up date formats. Pick the format as YYYYMMDD in both these line items and then run import. Also you need to create another line item for Active? - Keep it boolean formatted and map it. Misbah

Misbah

@Akhilesh1011 Production data as in Input data that end users input from planning perspective. There is a way to get that back too - but with careful series of steps.

Misbah

@LeeC There is just one mistake. Instead of Picking Fixed Line item mapping pick Column 1 against EMP03 Line items Misbah

Misbah

@Akhilesh1011 You can not retrieve the Production data.

Misbah

@Akhilesh1011 Although it looks like the limitation on the product side. Here is what you can do You can make the negative number into Positive, Apply POWER function to it with "-" sign. Misbah