-
How to apply different logic for parent and child in non composite list
I have a module with countries and time in the page selector and products in row and line items in column. I need to calculate the CM% for my products but calculation should only applicable for (L1 and L2-b). formula will be Rev/CM. I have created the logic with lookup, but that logic is applying only to L2-b and its not…
-
Can't access my workspace.
Can anybody tell me if Anaplan Workspace is working or not? Actually I can't see my models from level 1 and 2 anymore. And also I can't access anything. I heard that Anaplan Workspace will again be available after 31st March 2024. Is It True? Can someone please tell me?
-
Conditional Formatting Help
Hi All, Checking the possibility of conditional formatting for FY 24 -GAP as shown below. I don't want the BP or Fcst to be formatted. 2. Is it possible to extend the Color formatting to only certain line items label (like net revenue, GM and GM %) needs color formatting 3. Is it possible to have spacing between Forecast…
-
Fake Time (1-31) or Time Dimension
Anaplanners, We're in the process of creating a use case for capacity planning. Users have mentioned the projects they have working on. We will be converting the allocation into hours. Say I'm occupied for project A and Project B 75% & 25 % respectively, I will have 6 hours for Project A and 2 hours for Project B assuming…
-
Move data between Anaplan & SAP
I am looking for possible & efficient ways which can be used to move data between Anaplan & SAP. In the past i have used SSIS to do same between Anaplan & MS Dynamics365/SQL Server, by using Anaplan API to execute import & export actions. Is there a tool which can give me a similar approach for SAP as well?
-
Best practices to clean up models (especially Actions)
Hi everyone, Trying to get some ideas and best practices from this great community on how to clean up unused fields in Actions. I recently deleted some line items that I was no longer using. There was nothing in the "Reference by" column so it made sense. But they were linked to some Actions to Spoke models and I ended up…
-
When to use lookup/sum versus when to refer cells in anaplan
I find a little bit confusing on when we would use the lookup or sum function rather than refer the cells in anaplan. Can you help me to explain more about this? I also note that lookup is for looking up non-repetitive value on the source file, while sum is for summing up repetitive value on the source file. Depending on…
-
Date Import not working
Hi All, Need some quick help I want to import a date from 1 module to another module using Import action, however I'm error as "Invalid date" Module 1 - 1 line item (date1) | date format> currentperiodstart() Module 2 - 1 line item (date 2) | date format Now, when I'm trying to import date from module 1 into module 2, I'm…
-
Is there a way to reset the List Ids to reorder it correctly?
Hello everyone, I am building a date range filter to allow a use to select weeks and then have it filter to the days belonging to each week. I did this by having a report days being a child of Report weeks and using an Time calc to set up the range. It is working like I want by showing the correct list items. But they are…
-
Browser Slowness when Model Building
Has anyone else noticed that after 15-30 minutes of model building activity (opening modules, opening lists, updating formulas, opening split views, toggling from blueprint to module view, etc.) that browser tabs slow down and stop responding, and has to be restarted. Been an issue for a few weeks now. Hardware and…
-
How do i stop Summaries being sorted in a new UX grid
HI, i have a grid in the New Ux and i have data summarised by the Country in the hierarchy If i sort the data by Change the summaries get sorted amongst the data, and that is not useful. I want the summaries to remain at the top, and the other line items to be sorted. How would I do this please?
-
What is Data Management System that was talked about during Anaplan Kick-off this year?
-
How to get Range of Values between two Booleans that are time formatted?
When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.
-
I need to add new item to Tree View (General List)
There is no option to enter a name to 4060 item line. Can someone help please?
-
List to module, most efficient way?
Hi Do anyone know what the best way to link a module to a list is? Cause in our models we keep databases in lists, to be able to keep track of the history. The end useres are uploading a data file, which is then stored in the list, with needed column data saved as properties. My question then goes on what is the best way…
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
dimensions look up
I have a REF module dimensioned by a list of vacations: this module represents with a hierarchy, a column of start date and end date. (the "vacation list" is a child of "team"). I have a second module dimensioned by Team, which I'd like to model by day, so that I can boolean-select the days off. I've set a formula of :…
-
link text-formatted line item
Hi All, I have a question from a partner.., Can you please confirm that it is not possible to link to a file destination in Anaplan using a link text-formatted line item. The link text-formatted line-item defaults to http// and the file destination our client uses has a different prefix using backslashes (\\). The links…
-
Query on Efficient List Creation Method
I'm seeking advice on the quickest method for creating lists in Anaplan: using the UX Page "Form action" or the backend Actions for Creating List Item. Which approach is more efficient?
-
Do you feel it will be good to have Supply Chain related functions ?
Since Supply chain use cases are picking up, do you feel it will be good to have supply chain specific functions in Anaplan. If yes, then kindly promote the new idea I posted.