-
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,…
-
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…
-
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
-
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?
-
Data allocation from one level to other in different module
Hi, I have 2 different list (L3 and L6) I have 2 module, 1st module has L3 list is used and 2nd module with L6 list is used. User able to enter data in 1st module (L3 list) and data should be copied into 2nd module at L3 member--- 1st ask and data should be divided into L6 respective child members evenly. Thanks, Asha
-
Bring line item value from parent to child, distributed equally, from one module to another.
Hello, I have a list hierarchy that looks something like this: * Department A (Parent)* Office 1 (Child) * Office 2 * Office 3 * Department B* Office 4 * Office 5 * Department C* Office 6 I have now created two modules, one where Department list is a dimension (Module Department) and one where Office list is a dimension…
-
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…
-
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…
-
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…
-
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…
-
Gigabyte Missing for Workspace Calculation
Hello Anaplanners, I am currently working on a size simulation model. The purpose is to reproduce the "model info" shown in a model and apply some changes (create new module, extend a time range...) to see the impact on the model size. I have already calculated the cell counts of my source model but I am not matching the…
-
Ragged to Balanced Hierarchy
Please can someone give the step by step points in an easy way to convert a Ragged Hierarchy to Balanced Hierarchy in Anaplan. Thanks!
-
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 ? 😅
-
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 to show "Display Name" on the module instead?
I have created "Display Name" with formula inside. How to show this "display" name on the Module I created instead of the regular list (on the left)
-
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?
-
Count items in a flat list?
Hello, I am trying to count how many items are in a list and display it in a module? In the example below we have 3 items in the list. Does a function like this exist?
-
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%…
-
How to get an average time difference between dates for a particular month?
Hi Community, I need to use the difference between 2 different dates B-A & then get the monthly average of the difference for the month B in anaplan. Sample Data is mentioned in the Table below. Average for month (based on the Diff.) Month (Based on Date B) Diff. (B-A) Date A Date B 50 Feb B1-A1=x1 A1 B1 B2-A2=x2 A2 B2…
-
Can you scale the X-Axis in a graph/chart if the X-Axis is the Time Dimension?
Seems like in the New UX graphs and charts axis's can be scaled if the axis is a line item. However, there should be an option to scale any axis even if it is a dimension especially Time. For example, daily data would look neater and present better on presentations/decks if the time scale could be reduced to show SOME time…
-
Handling Gap in Data Stream
Hi all, Due to a 2-3 weeks of gap in the data stream, I need to ignore the data for those weeks from all computations in an Anaplan model that is nearly 50GB in size. If those weeks remain as null/no data, those cells would still remain part of the computation particularly if the logic indicates Sum/#N Weeks or moving…
-
Anaplan-Power Bi Connection using Basic auth-Blank source
Hi, I am trying to connect Anaplan & Power bi, I followed steps metioned on Anaplan community, but I was not able to see data in Power Bi. In Anaplan I have created one test export action. In Power bi I have entered below url in next step, I'm using my Anaplan User name & Password associated with the models. but I'm not…
-
Additional practice models/builds
Hi Anaplan Community! I've completed the certified builder program, but am wondering whether there are any additional practice builds out there that I can attempt? e.g. I'd like to practice building an ICM/SPM model. Thanks!
-
List item has nothing showing in 'Referenced in Formula', but it is referenced?
I have a list that shows no references, and i was removing ‘dead’ lists however, when i tried to delete it i got an error saying it was used in a module. And after looking i found it was indeed used So why does the reference not appear in the list information?
-
Getting Monthly and Quarterly totals in Weekly model
Hello all, I'm building a model with a weekly time scale. The client wants to see the Monthly and quarter totals also. Do you have any suggestions on how to get these totals? I created time filters to get a Month and also manually did a Quarter line item. But when I do a lookup, it doesn't come through.
-
Building a Long Range Planning Model
Hi, I'm a new Anaplan user (completed L1 model builder). I'm starting a project to get our current Long Range Planning model from excel into Anaplan. This is my first project and I'm wondering whether other group members have any similar experiences. There is a template LRP model in the App Hub which I'm considering using…
-
LOOKUP not working as intended
Hi Anaplaners, I'm having an issue with IF ELSE Statement. I expect the ‘ELSE’ part to go accross opposite direction than the ‘IF’ condition. But it seems to not be working using a LOOKUP function but works with a SELECT function. I want to promote it to PROD but I can't do it with using a SELECT BUT INSTEAD A LOOKUP.…
-
User Access Between Schedules and Snapshots
I have a user who has access to schedules but doesn't seem to have access to the corresponding Snapshots. A few things I have tried so far, are: 1.) Confirm their role and that they have access to the schedules 2.) Used my account as a test account to recreate the issue. When I tried to recreate the issue, I was able to…
