-
month to day
i have month dimesion table i want to change day dimension table example before apr19may19june19 12 3 after apr1apr2apr3111
-
Formula or Function to calculate a trend from historical data
Hello, I am currently trying to calculate a future trend based on actual historical data and was wondering if someone knows of a function or formula within Anaplan that works best for this? Thank you
-
Sum or count the number of recurring entries in a list
Hi everyone, first post and hoped that someone could help me as I have been racking my brains to try and do this So I have a list which is called tbl_masterdata, within this list is a field called BVFSKU which is text formatted. I have the BVFSKU's in a list (LK_BVFSKU) and this is used to populate tbl_masterdata on an…
-
Allocation
Hello, I have some questions regarding allocations. Hope I can get some advice from you. Thank you so much in advance! Here is the background information: * Source Module: Flat file without time dimension. STATE WSLR BRAND LINECODE PDCN MONTH TARGET 1 MO BUD 3 Jan 19 1,000 2 1216 BDL 3 Feb 19 2,000 3 1111260 Mar 19 3,000…
-
Wrong Calculation when using selective access
Hi Anaplanner, I have module like a picture In module Final I'm using list level 3, and I give user selective access in level 1(Indonesia), and in the module group amount I take amount form module final and sum by variable, so why amount in group amount not the same with module final? Thank you
-
can we add time dimension to existing module?
If answer of above question is no then check below scenario- I have to check Boolean format line item named "current year?" in the module which doesn't use time dimension. It has to check from other time period (month) formatted line item "Month" in the same module whose data has been uploaded through sheet. How can we…
-
Value referenc Price effective date
Hello, I have some questions on one of my models. Hope you can give me some advice. Thank you so much in advance! @DavidSmith Here is the background information: 1) Source Module: Flat file without time dimension UNIQUE ID PRODUCT CODE MONTH NO WEEK NO EFFECTIVE DATE END EFFECTIVE DATE FOB 115331062155501-OCT-18 1153…
-
Continuously polling and downloading data(every minute) from operational model
Hi All , I have a requirement to continually poll(every 1 min) and export data from an operational Anaplan model . I expressed my concerns about locking / slowing down model therefore to test it out i wrote a script which runs every min and downloads data from an operational model . Data to be downloaded is relatively…
-
How can I 'sum' non numeric fields to pull data through from one module to another?
I am trying to pull non numeric data through from one module to another. I have found that "If your mapping table contains the Source List and maps to a Target List-formatted Line Item or List-formatted Property, then use SUM in your formula." but how can I pull this information through when the data I need is text…
-
I am unable to circular reference in a module.
I am unable to use circular reference in a module(with "If Else")
-
Sum from one numbered list module to another numbered list module
I have imported my transactional data as a flat table using a numbered list. Something like this: I want the user to go into a second module where they can select drop-downs for City, and it will sum the sales. This second mapping module must be a flat table too (numbered list) because if I were to dimensionalize it, the…
-
Discounted cash flow with data out to 2080
Hi Everyone, This is my first post. I am a relatively new Anaplanner and I'm currently making my way through Level 2 Model Building but I am also trying to work on some real life modelling at the same time. Apologies if this is the incorrect place for this question but I need some help. I have an issue with a current model…
-
Ranking Project - One Category at a time
Hi All, Hope you are having a great day so far! I have a requirement to rank projects based on specific criteria of Profits from each of them. However, they need to follow a specific order to be considered for Ranking specified below- a. Mandatory Projects should be ranked first based on their individual profits b.…
-
How to import multiple header rows into a module?
The import file is an export file from a module that I am working on. There are several header rows that I need to import into the module. How can I do this? Jan 19Jan 19Jan 19Jan 19Feb 19Feb 19Feb 19Feb 19Mar 19Mar 19Mar 19 ActualActualForecastForecastActualActualForecastForecastActualActualForecast…
-
Dynamic chart-2 Time line
Hi! I have 2 line items: 1. Actual revenue, data for the period: from jan19 to Sep 19 2. Budget revenue, data for the period: from sep19 to dec19 I need to build a chart, that will have one actual graph from Jan to Sep and another plan from Sep to Dec The problem is that Anaplan uses values (which are zero) for the budget…
-
Formula to number months within a quarter?
Within Q1, January is the first month (1), February the second (2), March the (3rd). Then Q2 starts, and April is the first (1), May is the second (2), and so on. Is there a good way to set something like this up? I ask because I want to build an IF AND statement, in which IF a value exists within a cell AND that cell is…
-
Shared Search Criteria
Hi, I have a module that displays our full Masterdata list, with 3000+ products. I have a search module with some of the fields (12) from the Masterdata module. Allowing the user to narrow the list down to relevant fields by using a boolean formula and filter to display just the items they need. It works exactly as…
-
SUM on a list attribute that varies with another list?
Is there a clever way to SUM on an item's attribute when that attribute varies depending on another list? I have two very large flat lists ... Items and Groups .. and another small picklist, Operation, with three members Add, Subtract, and Ignore. Data module "DAT 1 - Input Data" is dimensioned by Item and Time (Month).…
-
Formula Assistance
I am trying to build a formula to pull in fringe benefit rates based on the department/unit and employee works for. I attempted to build an IF Then formula but Anaplan keeps telling me it is invalid. See my formula below. IF Dept Code >= 0000 and Dept Code <= 5999 OR Dept Code = 6500 OR >= 7000 and Dept Code <=7199 THEN…
-
Clear the data for more than one period in one action button.
Hi, We have a module , need to clear data from the module based on Period selection but one more than period should be selected at one go. One possible option is to copy zero value from a second module and select the period to clear while run time but this allows us to clear only one period in one run, so if I want to…
-
Date of version start
Hi, please help I've got versions with switchover: 1.Actual 2.Budget-mar 19 switchover 3.Forecast-June 19 switchover I need to have 2 line items showing: 1. Budget start date 2. Budget end date
-
Does Anaplan allow different formula for each levels within the same list?
For example, my entity list has 4 levels as follows: Country->Zone->Region->Area->Branch and it is a production list. In this case, how can I use the different formula for each levels? I understand that we can have a different formula for each level by having a separate modules for each level or by having separate line…
-
preference to the conditions in Optimizer
Hello Anaplanners, Working on optimizer and want to know if we can give preference to the conditions or constraints i.e. First Preference to skill followed by availability and then to Rates? Regards, Chamanpreet
-
Import from File vs Module
I’ve been running the Model Optimisation training in recent weeks and one of the benefits of Data Hubs we talk about is that Model to Models imports are faster than exporting to a file and re-importing from a file. The question is always “by how much?”, so these are the details of a test we did in April Performance test of…
-
Anaplan Community Search Function - not working?
Hi all, It seems as the the Anaplan community search function (Search bar at the top of the page) is not working - is anyone aware of this? Best, Callum
-
Delta record view from a file load
Hi All, I have a request to load a file to a master list and module, but prior to run this load I want to see what are the delta changes coming in the new file. So, I thought to park the new file in a temporary list and module and then compare it with master list and module to view the kind of changes I,e New node added,…
-
How to comapre Data from different Module and has Different Diemension
Hi, I have a module A with List A, and Module B with List B. Both the Lists are almost similar. But they are 2 different List. I have line Item PARENT_NODE in both Modules. I have new Line Item compare_Parent, were I need to compare and the result as "similar" or "different". In ModuleB I have written below formula but its…
-
Dependent Dropdowns + Selective Access (hierarchy)
Hi all, I am trying to create dependent drop-downs (picklists) for a Region/Sub-Region/Country hierarchy on an input dashboard, with selective access applied. Ideally, users should only be able to select Regions to which they have access, then Sub-Regions within the specified Region to which they have access, then…
-
Publishing List as Page Selector Without Parent Levels
Hello All, When I try to use a list as a page selector in a dashboard, I get all the parent lists that are above the selected list in terms of hierarchy. For example, let's say if my geographical hierarchy which consists of 4 lists: Business Unit, Continent, Region and Country. Region is the parent for the Country,…
-
What's the workaround to sort nested dimensions?
All, I'd like to find a workaround to be able to sort nested dimentions. (as currently it's not natively possible). I know that I can sort manually the list however as we have new members created everyday, I'm looking for an automation. I cannot either delete and reload this list everyday as I have some data at that level…