-
Compounding Monthly Growth
Relatively new user and am struggling to build a ramping growth model based on monthly expansion. Am using the lag function in this context: Avg Deal Size = LAG(Avg Deal Size, -1, AEC Salesperson Assumptions.Starting Deal Size) * (1 + Deal Size Growth) My Deal Size Growth is positive and my overall Avg Deal Size is…
-
Data Types Conversion - manual
Hi everyone, A new video tutorial on how to convert most used data types is available here. Hope this will be helpful, Egor.
-
Import users from DEV model to PRD (Deployed) model
Experts! We implemented ALM and imported DEV model to create PRD model. Please suggest what is the best way to import users and their access from DEV model to deployed PRD model?
-
boolean related line item s
I am not sure how to explain this. We have a module with several factors (line items) we ask our end user to project forward for a year on a monthly basis (i.e. twelve periods). However quite often they will forecast the same factor for the whole year. We would like the abilitiy for the user therefore to enter in their…
-
Delete items from lists using actions - manual
Hi everyone, A new video tutorial on how to delete items from lists using actions is available here. Hope this will be helpful, Egor.
-
linitem options (Start of section, Brought forward)
Help me please with use cases for linetem options: Start of section, Brought forward In Anapedia it's said they are rarely used and I couldn't get enough from explanation think if they present in blueprint it will be helpfull to understand where could I use them
-
How to filter line items
Hi, We have hierarchy type lists of Market Unit and Country Group (Market Unit is parent.) and Country Group list is specified as a dimension of a module. In the module, the line item 'B' is applied to Market Unit.('Applies to' of the line item 'A' is left default.) In such a situation, if user selects one of the Country…
-
How to put formula in one list item and keep blank in the other
Hi Given that we set a list which has two items of A and B as a dimension of a module, we would like to put formula in a list item A. On the other hand, we want to keep blank in a list item B so that end users can input data. How can we implement this? Regards, Maki Yasuda
-
Formula for blank value in lookup function
Hi I am using the below formula for one of my line item in my module 'Demand'. I am doing a look up in another module 'Open Qty by Bucket ID' by Bucket ID and SKU to populate the open qty value in the 'Demand' module. Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF] The issue I see here is,if there is…
-
Access to 102: Intro to Model Building?
Dear Team, Since Yesterday I have been attending to Anaplan Training more precisely 102 : Introduction to Model Building but today Morning when I logged on first I have not seen yet the courses Menu on my session . Could you please help me access to the courses ? Could you please explain me the models source on my today…
-
Selective Access to Lists for Roles (as well as Users)?
Is Selective Access for Roles (as well as Users) technically possible / practicable to implement? While Selective Access for Users is of course useful, my experience tells me that it would be even more useful for Roles, particularly for a numerous user base. If the answer is no, then is there any workaround to meet the…
-
How to delete a Model
Hi All, Can any one please let me know how to delete a model which is created or installed through Anaplan app hub..? Thanking you in Advance Regards Sashidhar
-
Tableau 10.2 to make advanced analytics easier for enterprises
Tableau 10.2 adds advanced mapping capabilities that claims to make data analytics easier and more scalable for enterprises. Intro: Data visualization company, Tableau software, has announced the overall availability of its new version, Tableau 10.2. The organization states that the release includes advanced mapping…
-
Can you change a numbered list back to a non-numbered list?
I have just ticked the box for numbered list and now when I untick it, the unique id column does not disappear?
-
Help with NPV Function: Anaplan differing from Excel
I am having trouble with the results of the NPV function in Anaplan versus that of Excel. In anaplan, I cannot control the scope of the time periods being passed into the NPV function. I am expecting a value beginning in Q2 FY18. However, the calculation returns a value beginning in Q1 FY17. My client is expecting the…
-
Profile Example
Can someone provide the example of using Profile function in Anaplan, I need to spread the value between two dates? for eg: Start date 1/Jan/15 to 1/dec/2015 - value is 12, spread should 1 each month. regards, yagna.
-
Turning the status of subset list ON without import
Hi, In a module with the dimensions of product list which has a subset and line item of sales amount, only if the sales amount of a product item is not zero, is it possible to turn the status of subset list ON not using import function? Thanks and regards, Maki Yasuda
-
Load Data To Anaplan
Hi, I would like to understand if we can pull the data from an Oracle Database to Anaplan by writing some script. When I was reading about the Data Integrations it doesn't talk about Oracle Database. Am I missing any link to look at? Please share some information on this! Regards, Raghuveer.
-
List subset by formula
Dear gurus, I'd like to create inventory report and included "Item master" as dimension. However, since there is no stock in 50% of item master, it is obviously waste of cells. So, I'd like to create list or list subset based on "existing stock only". One of idea is to create simple module with item master, and…
-
how i calcuate duration(in months) between two months
hey, i have an issue that is related to calculation of month. actually my line item which name is start month and End month that format is month(year). so with this how i calcuate duration(in months) between these Months. With this post i am attaching Screenshot Of Blueprint of my module.
-
Ghost Models?
I don’t think I can see all the models in my workspace and I am a workspace administrator. Is it possible there are older models from former colleagues that I cannot access live in this workspace? Is it possible to somehow made all the models accessible to me, so that I can review them and archive or delete?
-
Leveraging Excel File with Formulae
Hi all, I am in possession of an Excel file which for the purposes of documentation, has a list of all accounts and their respective formulae. For example, a line may have: Name: Code: [OpStatement100] Formulae: [Opstatement50 x Opstatement75] (anything within square brackets is the literal text of what is withing the cell…
-
Child to Parent Ratio based on Planned Input Number
Hello I have a set of Actuals(FTE) by Level 3 rolling up to a Level 2 in turn rolling up to a Level 1. I need a formula that calculates the ratio to its immediate Parent first . I also am looking for a mechanism where someone enters a new value at level 2 (immediate parent) the new planned numbers for service level 3…
-
Demand Planning
I am looking to build a demand planning app and had decided to use the Statistical Product Forecasting app from the App Hub. However all the data is only in monthly buckets. My process needs to have weekly data and forecasts. I have looked through other available apps as well but any app that does forecasting seems only to…
-
Yearvalue and select
Dear all, is there somehow the possbility to use the yearvalue- and the select-function together? I want to transform year values to a monthly schedule and thereby just select a certain case from a list. Thanks you all in advance, Best regards
-
Copy month data
Dear, I have two questions regarding an implementation I'm currently working on. To give a little background information, it is a financial planning model for the coming 3 years and has a budget version and 4 different forecast versions. My questions are the following: [list=1] * Copy data from one month into all months* I…
-
Semi solution
I have been thinking about the issue and I found a solution, however to keep it feasible with formula's limiting the IF-function, I need a bit more help. Currently my solution is to recalculate the percentages in the final module, however I need IF function for every line item, as all of them are calculated differntly. For…
-
Synchronization using ALM
Hi, I want to move a structural change (adding properties to a list) from one model to another using ALM features. I'm not sure how to operate that, so are step-by-step instructions and screenshots on comparing & synchronizing available anywhre in anapedia? It would be very helpful for me. Thanks and regards, Maki Yasuda
-
Salesforce Connector
[img alt="Harisha.Mo" height="40" id="_x0000_i1025" style="border-radius: 5px; height: auto; line-height: 100%;" width="40"]http://www.gravatar.com/avatar/8794d4330529f879433f7490a8f5c294?size=40&default=https%3A%2F%2Fassets.zendesk.com%2Fimages%2F2016%2Fdefault-avatar-80.png&r=g[/img]Hello, How can I add a Salesforce…
-
Merit Increase Formula
Does anyone have formula string they like to use to calcualte merit increases in a specific month? As an example, if my merit increases every March, I would want my wages line to increase automatically by a % every March.