-
Summing over time period and list item
Hi, I am struggling to return any values and wondering whether this is even possible? I have created a fake Period End list and can determine according to the day in the time module (ACC04) what the Period End should be. I then created another module dimensioned by Period End and summed Day in Office but its coming up as…
-
Stable User Access Export
Hi all, Has anyone found a way of exporting User Access from a saved view rather than directly from the Users tab? We're feeding the export into Azure Blob Storage and have had a couple of issues recently where changes to the standard Users export altered the filename/structure, impacting downstream processes. Ideally,…
-
Row Count as an ID for ADO
Hi all, I am importing a flat file into ADO. However the flat file does not have a unique identifier. I would like to use the row count as the "ID" Is there a way to create this ADO? Basically how would I do row_number() in SQL?
-
Capturing enhancement requests from end users
Hi everyone. Has anyone built a model designed to capture enhancement requests from end users with a view for CoE to assess, triage & prioritise. Looking to provide end users with a UX page to submit enhancement requests and for CoE team to be able to track.
-
Building a User-Filtered Export from a Module with Multiple Selectors
Good morning everyone. I need to build a module export with some specific requirements: users can select a currency type (USD/Local), Salary Type (1 or 2), Nomina Type (1 or 2), and Version (Forecast, TS, Plan). Currently, each of these filters is driven by an independent system module published in the NUX, each…
-
Can we add new roles from UX
Hi everyone, Could someone please help me understand whether it's possible to allow users to add roles directly from the UX? If so, what would be the recommended approach to implement this? I would really appreciate your guidance. Thanks!
-
Mark list items as subsets with import process.
How can we create an import action for production lists where we can import data and mark it as a subset while importing so that only selected list items get added as production data, and we dont have to mark each item seperately, so that we're able to use these list subsets as dimensions instead of the whole list in…
-
Bulk Copy Failure
The Bulk copy at my org has failed for some reason, The bulk copy was run from the versions tab, and a specific list was used (which is production data ticked). What sort of trouble shooting can one do for this issue? I cant run the bulk copy from the actions tab as it wont show the list (being production data ticked). And…
-
Mismatch on common dimensions
Hello, Would anyone be able to advise why (in very simple terms) when we add CC7 (a mapping list) to the applies to of the value row, we get the error "Mismatch on common dimensions". The LIS used by this module picks up line items from FS1-Regional which in its-self has CC7 as an applies to dimension. Kind Regards,
-
Anaplan workspace
Can someone kindly provide me with assistance. I have completed the talent builder application and was approved access to the workspace. However, i was emailed a link to set up, but the link expired. I have emailed the support team (over 3 days ago) but I havent received a response. Can someone please advice me on what to…
-
Reverse Lookup for a List to List Mapping (more than one mapping)
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
-
Generate Unique Codes for List Imports with Long Text Values
Hi ALL, I'm using Product Category, Product Line, and Budget Type to generate a unique Code for a list. The display string is generated as: Product Category & "_" & Budget Type & "_" & Product Line. The Code is currently generated using: LEFT(Display String, 60) The issue is that Product Category and Product Line contains…
-
How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
-
Native function for Date & TimeStamp
Hi, is there in Anaplan the possibility to retrieve current time (date and time)? I know that now this is possibile only via integrations, but I will need to know if there is a native function.
-
Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
-
Today's date
Hi everyone, I'm looking for a way to retrieve the current date (today's date) directly within an Anaplan model, without importing it from another model or module. We're facing an issue because our application is used by teams across multiple regions and time zones. For example, users in one region may have already moved…
-
Group Workflow Task
Hello Anaplan experts, I have created a workflow template with several group tasks. I have assigned these task to several users. Question: am I understanding correct that a group task is considered complete only when all users have completed it? I have tested and found out that if one user has completed a group task but…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi, I am stuck in trying to get the output of the below: After following the instructions my output is as below. From Jan 25 onwards my fields are empty whilst the desired output above is filled: This if the file i am uploading with both Actual and Budget, however when i upload it does not seem to be uploading the Budget.…
-
Scenario Issue
For some reason, when adding a new scenario, our enrollment numbers double instead of projecting normally. This begin occuring after the roll over process. SS with two scenarios in model. shows the same on base case SS with only one scenario in model Formulas not really sure where the duplication is happening.
-
Modules - Beta Version
I have a question regarding the new Beta module creation experience. In the current UX, when creating a new module, we have the option to create a new Functional Area directly from the module creation screen. However, in the Beta version of module creation, I no longer see the option to create a new Functional Area. I do…