-
Import filter by user
Hello, We are updating a spoke model from our data hub daily, and I need to enable end users to individually update the spoke model for their specific list member (property) only. Currently, imports from the data hub are running daily into staging modules. Now I need a way to allow different users to run a process to…
-
How to differentiate when a line item is input and calc on the same module
Hello! I'm trying to build a module where one of my line items is an input on one hierarchy but a calc on another level of the hierarchy, but I'm not sure if this is possible to build in anaplan, let's have an example: My Hierarchy is: Season Winter Summer On the module I have the following line items: Account Receivables…
-
How to change date format during a module export.
During a module export I want to change the date format into a fixed format instead. Currently, the date format is exported as per the system's date/time settings. Is there a way where I can change the date format so that it remains the same across regions in the csv export.
-
Position of Totals
I have two nested dimensions, A & B, in rows and time and line items being in columns. I want to show time totals (All Period and Qtr) first and then the months but even if I sort, Anaplan defaults back to its general time sequence the moment I put Line Items in Columns. I don't want to manually select and then show time.…
-
Help me with this issue.
I have this two modules: AND I want to pull the territory ref ID sys/fil07 to the inp/ter01 so it would only show territories available for that employee, i have tried to do loots of formulas but they dont seem to pull it correctly, not sure if because inp/ter01 is made with subsets its messing it up or something is wrong,…
-
Fiscal Year Label in Model Calendar
If we change the label will it interfere with any data/imports/exports or is it only a label?
-
Fortnightly time scale in Anaplan
Could you please share any custom day level time scale hierarchy Fortnightly time scale For January (Jan 1 to Jan 15, Jan 16 to Jan 31 ). For Feburary (Feb 1 to Feb 15, Feb 16 to Feb 28 ) @Misbah, @Manjunath
-
How to automatically populate a boolean from a module with a parent list to a module with a child
, Hello, I'm working with 2 modules: Module 1, where I'm using list "Product Family" (and List Employee) and Module 2 where I'm using list "Products" (and List Employee) . The list "Product Family" is parent of "Products". In my Module 1, I have a boolean used to know which product families are assigned to each employee. I…
-
Set up a dropdown that follow hierarchy
Hello all, I have a hierarchy that has Cost Center → Jobs. A Center can have several jobs. I have a dashboard where a user can add a new FTE for a job. When they select a center, it should show only the jobs that come from there. Right now, I have a form that they can fill out and when they select a center, it shows all…
-
How do I find or trim an inconsistent string of characters in a line item?
I am currently importing data with a concatenation of 3 General Ledger identifiers and a customer code. A sample would look like LE10000.LMF10000.1000000 for the first GL indentifiers. Everything is consistent and All LEs are 7 digits, all LMFs are 8 digites and all account codes are 8 digits. I have customer codes that…
-
Get monthly value for base year selected
Hi, I have a module (dimesioned monthly) in which I need the base year values. The user selects the base year. I have created a seperate module in which the user can select the base year. However, when I am using the base year in the lookup, I am getting the full year value, instead of monthly value. Example: if user…
-
Convert date type to period
Hi All, I converted this date format into period using this formular PERIOD(DATE(VALUE(RIGHT(Reporting Period, 4)), VALUE(LEFT(Reporting Period, 2)), 1)) How can this date format be converted to period in Anaplan just like above. It doesn't work with the formula above. Please is there a workaround on converting this to…
-
Data hub - What Data should reside in Data hub
Hi Team, New to Anaplan Modeling. Based on the training, its my understanding that data hub is important to act as source of truth for data that is shared between multiple spoke model. I see data hub as a repository for list, hierarchies and data modules that are shared in more than one spoke models. My question is what…
-
Convert Period to text
Hi all, I just had another query related to my previous one. with the help of an expert I was able to capture the next month on my time system settings. Now I need to capture the Time period into text formatted line item. i need to convert the line item Month text 2 into text formatted for Month (text 2)+1 line item. so…
-
3.3.5.2A Beginning inventory negative balance
Hello Everyone, I have a question, my balance about the beginning inventory is negative. I don't understand why ? As you can see my datas in the DAT01 Beginning Inventory module seems correct : INV01 Inventory Ordering module : Can you help me ? 😅
-
Carry forward a value over several months
Hello fellow Anaplanners, I'm working on a module that has an Approved FTE by month. But the user can go adjust it through a form and add/subract FTEs as needed. It is working great for the current month. Meaning( Mar 2023 has 2 FTE for Job A. User adds 1 more for Mar 2023. I have a Final FTE line item that sums the 2 and…
-
Anaplan Dashboard Colors
Does anyone know the color code for the standard grey in Anaplan dashboards?
-
Exports into .txt file
Hello, I have a module dimensioned by fake time and need to export it into a .txt file. Because of business processes, I need fake time and the line items in columns unested. Is there a way for Anaplan to accomplish this? Thanks.
-
How do I add the name of the parent to a list?
I want to have the name of the Parent shown in each row in a column of a list. How can I achieve this?
-
Growth Assumptions on a consolidated level
Hi Experts, What is the best way to make a growth assuption at a consolidated level and have the same % growth apply to GLs underneath? For example - I need to grow my Salary & wages by 3% and have that 3% apply to all the 10 different S&W GLs underneath it instead of breaking back like 0.3% per GL to get the total of 3%…