-
need to hide summary after running a process action button
Hi, Need to hide the summary of a process which is published on a dashboard as an action button from the end users. Any leads on the same. Thanks, Kunal
-
How to cumulate using the display order instead of original order of the list?
While applying the cumulate function on a list, the function works considering the original order of the elements, Is there a possible way to cumulate using the display order instead? This is required when new members can be added anywhere in the list.
-
Identify upgrade/downgrade a record in a list
Hi, Please go through the attached file. here each userid has a plan and start /end date of each plan. User can upgrade/downgrade their plan. here i m looking at the solution where i can identify which is the latest plan for unique userId to consider them for the pricing. Ex : User1 has A plan . after that he has upgraded…
-
Linking Calculated Values Vs Re-Calculations
What’s more efficient ? Linking (using Module.Line Item): A Line Item in the Target Module to a Calculated Value in the source Module OR re calculate the same scenarios in the Target Module as all the requirements for the formula are in the target but you end up with two formulas ( giving the same answer ) in two different…
-
Model Import Failure
HI All, I'm trying to import a model from one workspace to another but I'm getting the attached error. This error is happening only for specific models and not all models to which I have access to. Can you please let me know what is causing this issue. Thanks & Regards, Prateek
-
Convert multi-dimensional form to RDB form
Hi, Anaplan friend I understand Anaplan is capable of converting RDB format to multi-dimensional format, but how about opposite ? Would you take a look at the attached file ? Now I have a module on the left hand side, and this has to be what is shown on the right in order for another system to import. I appreciate if you…
-
Specific Count function ?
I am currently looking to build a line item in a pre-existing module that shows a count of open shift request sent to only one employee. I have the "amount of shifts sent to" data as well as list of employees. Wondering if there were suggestions on how to make this work. Maybe a Count if blah = true then 1 else 0 then…
-
Calculating date 90 days past identified date
Hello - I am looking to calculate the date 90 days past an identifided date. I know there is an ADDMONTH and ADDYEARS calculation, but not an ADDDAYS, which would have been helpful. Is there another approach to do this? Example: What is the date 90 days from 11/15/18. Thanks K.
-
MAKELINK -Should be easy...
All right, I did the very easy Makelink modules and added it to a dashboard. What my "click here" button should do is direct users to a Sharepoint on our network where we made/created documentation related to our dashboards. If I make the URL www.google.com it works. If I put our HTTP://Company Sharepoint URL (example:…
-
Anaplan Connect
Hello Experts I am new to Anaplan . Want to know the sequence of releases for Anaplan. Also let me know any reference document with this details Regards Sam
-
Returning one line items value using other line items
Hi all, I'm trying to find a way to return the value of one line item in a list, using two other line items. Background: I have one large module built off sequence numbers as the rows, and line items as the columns (no page dimensions). Each row is a seperate transaction (either a product being added or a product being…
-
Copying data from one list member to another
Hi I need to copy data for a particular line item (number format) which is a user input from one list member to another. Use case: We have set up a target setting model wherein User will input targets for their Financial Metrics at various stages throughout the year. The stages are performed one after another in a periodic…
-
Importing Line Items with 4 or more dimensions to a Numbered List
In my model I have a number of modules that are dimensioned by 4 Lists, typically Time, Region, Resource and Product (e.g. hours worked by Resource A on Product B in Region C in Week D. I want to save changes to line items in these modules to a Numbered List with Time, Region, Resource and Product as Properties along with…
-
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…