-
Copying a model
Hi We are trying to find out if we can create a process to copy a model into a new model. Anybody having any idea about this? Basically, we want to autoamte the model copy activity. Thanks Regards Prabakaran
-
Anaplan issuing new certificate on Dec 8, 2018
Update (May 31, 2019) Please see the Anaplan-Generated Certificates to Expire at the End of 2019 blog for more information. Original message: Based on customer feedback and to allow admins additional time to transition to new integration clients, Anaplan will be issuing a new Anaplan certificate on December 8, 2018. The…
-
turn off subsidiary view in module after "version" is added
Hi All, I was wondering if anyone might have experience in this issue I am having. I built out a few modules and am now realizing that I need to add the versions dimension to a few. However, when I apply the versions the module changes to a subsidiary view and therefore eliminated the ability for data to be manually…
-
Time Summary: MoM, QoQ, and YoY on the same line item
Hi all, I am trying to create a "% growth" line item, where this line should be able to represent MoM, QoQ, and YoY on the same line (with or without the use of working line items) As time summary does not allow us to use OFFSET or PREVIOUS, what should be the best workaround for this? (Note: with the creation of new…
-
Months Spread
Hi, I am trying to figure out why my mothly cost will not populate based on the formula I provided. The goal is to show the monthly cost for only a certain time range and for the cost to not populate in the months it doesn't apply to. My issue is the cost will not populate at all. Attached are screenshots of my formula and…
-
Regression Test automated
Dear all, One of my customers is thinking about how to organise regression test. Goal is to run automatically a script for 2 models (on older version and the current version with new changes) and to see if the calculated results are the same. This is to prevent having full integrated each time when changes have applied.…
-
Numbered Lists to Assign Employees to Projects
Hi Everyone, I am working on an internal model where the goal is for employees to input their monthly hourly estimates based on projects they are assigned to. I want employee to be able to go in and input weekly time assumptions based on project. I have created the following lists: Total Company L1, Clients L2, #Projects…
-
Quick reference guide for Data Hub Setup
Quick reference guide on check points to be considered before going ahead with Data Hub Setup * Commit* Any data that goes in and out of Anaplan should use Data Hub - Get an alignment with business users, model builders & IT team that any data that goes IN and OUT of Anaplan will go through Data Hub. * Answer* What Data?…
-
Formula/process to override user select boolean?
Is it possible to have a boolean which is user selectable but that can be also overridden by either a formula or process? For context, in a dashboard I have a module which is read only unless the user selects a boolean to make it writable; the boolean doesn't control the write access directly but rather feeds into a…
-
Very first column width
Hey, I have got some troubles with widening first column containing line items, so they are partialy displayed due to narrow size of that column
-
Count Qty based on the unique identifier
Hi , please go through the attached SS. I am looking for that solution.I have a data module which have a numbered list ref and properties as shown in SS . I am looking for the number of total email sent by the each unique sender based on the sent status in a new module. Please help me out with this asap. Thanks.
-
subsidiary views are blank
I am trying to create a module which is a summary by a single dimension Source: Time, Cost Centre, Account Destination Cost Centre for my destination line item I have Year in the time scale, which creates a subsidiary view. If I click into this I can see the numbers I expect, but the main module has blank rows for each…
-
List Modeling
I have the following lists in a Hierarchy Office L1 Clients L2 Funds L3 I also have 2 seperate lists Entity Location In a module I am trying to show which entity and location that the Fund L3 rolls up into with boolean boxes but my problem is that a single funds can roll up into many Entity's and many locations For exampl…
-
Copy Branch for Selected Line Items
Hi, I have a module with a numbered list. Among the module line items are Submit and Approve boolean, which I use for some kind of worlflow. When I use Copy Branch action to copy a particular numbered list, both booleans are also copied. On the other hand, I just want to copy other line items but the Submit and Approve…
-
Set up filter to select levels of hierarchy to show
I have three lists all in one hierarchy (L1, L2, and L3). How can I set up a filter using booleans to allow users to select which level of the list they want to see? L1 is parent of L2, and L2 is parent of L3. I'm trying to replicate the functionality of "Select Levels to Show" so that I can set the filter on multiple…
-
Need to enter data in three currencies and can also view in three currencies
Hi team I have a requirement in a module where User can have option to enter data in three currencies Curr1, Curr2 and Curr3. So when one user entering data by selecting Curr1 from page selector and the next time when another user wants to enter data in some other currency suppose in Curr2, so when second user selecting…
-
Comparing TEXT values
Hi, Very simple task from the looks of it. I have a line item where user (or formula, I don't think it matters) enters text. I want this text be unique, and if it isn't - I want user to know about it. How do I make a check? If it were cells formatted as list members - I can think of a way to compare those, but many…
-
Count items in a list
Hi, I want to do something that seems simple, i have a list (Complaint list), and it has a field (text) called custRef which is not unique. I am in another module and when a user enters a CustRef (text field) i want to then count how many times that appears in the Complaint list. As the CustRef is not from a list, and just…
-
How to create a lineitem-dynamic graph and chart basing on a driver lineitem/list
Hi, everyone, I have an requirement from client that users select a standard/method (may be list types) from a drop-down in a lineitem (list formatted), and the graph/charts will automatically change the data items accordingly. Let me put it in more details with some examples. Driver (parameters) Image:…
-
nested ifs
I have the following nested if, for the highlighted line item (see picture): IF NOT 'exclude' AND 'Sum fill rate gallons actuals' > 0 THEN 'Sum fill rate gallons actuals' ELSE IF 'Sum fill rate gallons PY' > 0 THEN 'Sum fill rate gallons PY' ELSE IF 'fill rate gallons FOR movement avg' > 0 THEN 'fill rate gallons FOR…
-
Can I configure a chart to respect a dynamic Time filter?
I have a chart with Time on the x-axis. The saved view used to create the filter has a filter applied to Time. The initial view published on the dashboard respects the filter. However, when I change the selections in my driving filter, the chart is not updated. See example screenshot below.
-
Is there a way to use SUM with Rules, such as IF
Sorry for the wall of text, I am attempting to articulate fully what my inquiry is, and due to information privacy, I am using sudo names as place holders. I am attempting to generate a summary module. I am using 2 independant heirchies, with one of the line items/fields in the first heirarchy matches a value in the second…
-
Minimum item in a list grouping
Lets say I have a list to map any day in the year to an accounting month, because our accounting months don't always begin or end on calendar month boundaries. Accounting Period Date List (sample) Parent Code Accounting Month ... ... ... ... 5/24/2018 May 18 5/25/2018 May 18 5/26/2018 Jun 18 5/27/2018 Jun 18 ... ... ...…
-
Reducing Model Size – Introduction to Sparsity
Summary: Unnecessary model size has a large impact on your Anaplan environment from using valuable space to slowing down key processes. Sparsity is one of the biggest causes of inflated models. Understanding what sparsity is and how it impacts a model is the first step in knowing how to reduce it. Course Objectives: By the…
-
SELECT unavailable
I have come across an issue where a line item is dependent on dimensions not part of the Module makeup, I would like to use the 2021 by month line item in a new summary module but seem to be forced to add in Reinvestment Group as a dimension where in reality I want only the top level view summarised only by GL account cost…
-
Using No data line item to enter comments (Admin)
Hi, a short tip ad trick to document the blueprint. I use No Data Line items, hidden in dashboard, to define distinct /homogenous chapter / parts in the blueprint. No Data line item are supposed to be No data, and they are, BUT you can nevertheless enter a formula in them. I use this feature to enter a text formula which…
-
How we can concatenate two number line items?
I have got two number line items as shown below. LineItem1 , LineItem2 , Result 1 2 1(2) 3 4 3(4) 7 10 7(10) I want to get the result as shown above for the two line items. Ideally i need a concatinated value. Could you please assist me in achieving the same in Anaplan.
-
Group option in RANK Function
Hi, I have a module with 3 or more lists, and Value and Rank line item. I want to rank Value for each combination of items in those 3 lists. However, I find that RANK function can only accommodate 1 list in the Group option. How can this be done? Regards, Andre
-
Schedule Module as Report
Beginner Question: Is there a functionality to schedule the export of the current view of a module to a specified user?
-
Show Total in Module even after applying filters
Hi All, In one of my moduel having a column "Rebate Payment Amount" which has values, and also we set the show TOTAL on Above for giving total aggregated values as single value, it works only if we didn't apply any filters on the remaining columns in the module. How to show the 'Total' i.e. sum of all rows for the column…