-
Data loss issue
I've encountered a strange issue in our model. To give you the context - We run a scheduled process through REST API to copy data from one version to another version. We tried running this using cloudworks, it did not work (I'm assuming because once of the action in the process has filter based on User Write Access). So we…
-
Issue in LIS where one line item is shown as a parent of another.
Hi, I have created a LIS from two different modules with a total of 3 line items. The two line items I selected from the first module however are having a parent child relationship when I use the LIS as a dimension in another Module. This should not be the case as all the line items are independent. The First Image is the…
-
How do I audit a specific line item that is used for DCA access?
Hi, I am trying to trace all line items in a model that reference a specific line item in a specific module for DCA access. Is there a function in Anaplan that allows you to do this?
-
Filtering for Month or Quarter or Annual Totals
I'm trying to do dynamic filtering of the periods in a report based on another module where I enter report start and report end date. I want the option to: Show only months between date 1 and date 2 Show only the qtrly totals between date 1 and date 2 Show only the annual total between date 1 and date 2
-
Erlang C- Application
Hi! I am leveraging Erlang C for a staffing model. As I use Erlang C the service level that Anaplan is calculating is producing inconsistent results. Has anyone had this similar problem?
-
Anaplan Login Landing Page
Is there a way to set a default login page for a user? Like when a user login. It takes him/her to a certain page of an app
-
End Users being able to see all Users in a User dimensioned module
I did think that this didn't used to be the case but it would seem that a module that's dimensioned by user an end user can only see themselves when viewing it. If you're a workspace admin you can see all the users - which when you want to push out user-level DCA isn't particularly helpful. Clearly I can create a fake user…
-
Import action failed while running through Cloudworks
According to the given screenshot, error thrown by Cloudworks is - "Hierarchy import has both Name and Code unmapped". Although, manually the import action is running fine. Need some help. Thanks,
-
Look up question
Hi team, I need assistance with pulling values from one module to another. As you can see, some of those fields are related (in the same color) so all I need is to pull the Opp # from Module 2 into Module 1: Thanks a lot in advance.
-
Automatic Export of 60 pages
Hello guys! Can anyone solve this? I have a module with 60 pages, and I need to export each one of those pages into a different excel file. Does anybody know a way of automate this process? I mean, facilitate the manual process of selecting pages 60 times and export each one of them individually? Is there a way to iterate…
-
How to count the number of times a month shows up minus 1?
Hi, I'm trying to create a logic into the line item "End". My goal is to count the number of times a specific month appears without including the first occurrence. If November appears 4 times, I would like the "end" line item to display 3. Similarly, if December appears 5 times, I want "end" to show as 4. I want to use the…
-
Delete Multiple Users from the Model in one shot.
Hi, Is there a way to delete the multiple users in one shot from the model. Thanks, Ashoka GK
-
Data import
Here is the table i want to import to anaplan Here is what i have in the blueprint mode May I know if i set this up correctly? I have been having issues loading things in.
-
& concat is broken
May I know what's the reason it's returning me the same value when i have added a "_" at the end.
-
Align the size of the pie chart
I have two pie charts - is there a way I can ensure their size are the same? now they look very imbalanced. Thanks
-
Assigning List item based on Text line items and looking up - COMPLEX
Hi Community, To give the backstory of this - I have a module, where I first import one data file into, with Loan-Hedge ID List) and line items as the dimensions. The second file I import is a similar one, also with Loan-Hedge ID (List) and line items as the dimensions. When importing the first file, these Loan-Hedge IDs…
-
Trying to find equivalent of INDIRECT in Anaplan
My specific problem is referencing a line item by name from another module using a text value as the name. For example, if the line item is "1011" in module "Module A", how can I reference this line item dynamically within another module "Module B" using a separate input that matches "1011". In excel, I could use the…
-
Numbering format
Hi, Is there a way to change the numbering format for certain users when they access dashboard example - 100,67.98 to 100.67,98 Thanks AB
-
2.3.8.4 Create DEM02 Volume Growth Rates by Week module
Hello All, Once I copy the DEM01 to DEM02, I am noticing two things. My Weekly data is empty. My DEM02 Growth Line Item indicates that it is a subsidiary module. I do not think that is how it should look like. Any and all help is appreciated. Thanks.
-
Calculation based on variable selection from a user
Hi team, Got a problem I am trying to work through and have hit a roadblock. I am working on a forecasting tool and having trouble with dynamic selection of variables for basing my calculations on. For the purposes of this I have a list of accounts which is 62 members long. I have a driver module it is dimensioned by time,…
-
Is there a way to export a module into excel with each line item on a different tab?
I have a module dimensioned by time and a store list, with cost lines as line items. I'd like to export into excel with each line item as a separate tab. We don't have widespread use of the excel add-in so I'd prefer a way without needing to use that if possible.
-
Using Maps and the Longitude and Latitude seem to be out
I am mapping volume using the new Marker layer in maps, and have all the 'correct' longitude and latitudes for UK Postcode regions. However when I add these as a layer, ALL of them are out of place (to the right and above where they should) so some end up in the sea. The top red circle is supposed to be York ( The latitude…
-
Anaplan calculates 0.000000000000000111022 value but it should be zero.
Can someone help me or point me to if there are already discussion around this topic? In Anaplan, I am doing a moving sum prior 11 months and it looks like it returns a 0. As seen in the screenshot for Sep 23. But when I copy and paste the value into Excel, it is showing 0.000000000000000111022. Copied SEPT 23 into in…
-
Text to Column feature in Anaplan
Anaplanners, Is there a way we can convert a text to column like how we do in excel. Example below: You can see Column A (member name) and Column B (Projects Involved/textlist). Using Texts to Columns we can convert column B dynamically to different columns. As its dynamic some members have 3 projects while some may have…
-
Nested Graph & Graph/Chart color based on value
Dear Anaplanners, I'm stuck on this particular case wherein Is it possible to get nested graphs ? Any workarounds, i did see them posted in ideas exchange. Secondly would like the graph to have a dynamic color scheme based on the values. Example: Refer below table, 4 teams, each could have dynamic members and each member…
-
Puzzled by a CUMULATE formula...
Hi All, I've picked up this formula at work, and I simply do not understand it. The formula is for the line 'Switchover month', and reports a '1'. IF CUMULATE(IF Switchover THEN 0 ELSE 1) = 1 THEN 1 ELSE 0 'Switchover' is an unticked Boolean, The actual month is October in a FY starting in January. I get the CUMULATE…
-
How to get the value in between native dimesion
-
How to set up action that will change the boolean (in form of tickbox) for selected periods?
I have a module that contains Cost Centers and Accounts and time dimensions. When user unticks a box called Override (line item), the values for combination of Account and Cost Center will be automatically populated using last 3m average values. If the box is ticked, then user is able to manually submit their own number…
-
How to make a user-accessible history
Hello! :) Is it feasible for the user to store and access previous versions of a module directly in Anaplan? This concerns the module SKU details that the end user uploads at the start of the year. There are usually a few errors or corrections made in the first few weeks, and I would like to offer the user the opportunity…
-
Not able to Insert multiple Items on a worksheet
Hello fellow Anaplaners, I have set up a worksheet (tenancy schedule). I have no issues with right clicking and inserting multiple items. But for my client, the option is greyed out. He is not able to insert List Items. What I have checked so far: -Numbered List: Production Data checked -Editing on worksheet is enabled…