-
Use formula to integrate data at multiple levels of list hierarchy
Hello, my model has a list hierarchy of "FND01 Fund" and "FND02 Series". FND01 has a top level of "All Investments." The model also contains three modules with data values at each level of the hierarchy - Total, Fund, and Series - and I want to integrate this data into a unified report as shown below: I need to write a…
-
Why can not close a dashboard in Anaplan?
One end user can not close the dashboard in Anaplan and get above warning. But on other dashboard did not meet such issue. What happened on it? Please advise.
-
Importing is not updating correctly
Hi all, I can't figure out why my importing is not updating correctly. the mapping is correct but when i cheek it, the ligne item is not updated. pic attached for more details.
-
L1 Model Building - Lesson 7 Data Mapping issue.
Hi Everyone, I am stuck at 7.2.3 Activity: Import Data into Employee Details Module. The instructions are not clear how to map E2 Employee# list ,which is a numbered list, to the .CSV file. There is Hint in the lesson which clearly says this: * HINT: The E2 Employees# list is a numbered list and each record is assigned a…
-
Formula - limiting values returned
Looking to limit the values returned within a module, which I've made a start on the module showing in the right hand side , where limiting by currency. However, if I then also wanted to limit by say GL Category or GL code, how would I go about this? Any help would be welcomed on this
-
Integration Question
Can I know if the Anaplan Bulk API connector for integration is being used, will it send the log report (like we do in manual upload)? I need to know will the user receive the notification of success/fail (error log report) from SAP - > Anaplan. Not from the history I wanted to check because it is a daily process running…
-
Can I use Lookup Formula in this case ?
Hello all, I'm currently working with a model that provides weekly forecasts for all products. My goal is to obtain forecasts categorized by product type (S or W) instead. However, when I attempt to use a lookup, I encounter this error message : "Format of mapping used for lookup doesn't match any dimension of the source".…
-
Managing expenses as positive, reporting as negative
we have a client that manages expenses at GL account level as positive numbers. they rollup the GL accounts to reporting lines (they have multiple GL accounts for salary and report salary on a P&L). the reporting lines are hierarchical (total income and total expenses aggregate to profit before tax). they would like to use…
-
Can Anaplan Connect with batch scripts append data?
Hello, I'm using Anaplan Connect with batch scripts to integrate data into my Anaplan models. I'm interested in understanding whether Anaplan Connect supports the ability to append data to existing records in the models. Could you please provide information or guidance on achieving data appending using batch scripts in…
-
Restore archived model of a deleted workspace
Hello, It is possible to restore an archived model included into a deleted workspace. Thank you in advance for your answer! Regards
-
3.3.5.3 Check your Work
My numbers are slightly off for some of them. I am not sure if one of my formulas is messed up, or what the issue is. If anyone can maybe point me in the right direction.
-
About deleting module data
Hello, I want to delete the module's data efficiently. With 100+ modules, manually removing them one by one would be too time consuming. Don't you know how to do something? Thank you
-
Today's Date
Hi, How can i refer Today's Date in a formula so as the values would change every day based on that days date. For e.g. if its 09th june then the formula should give result as 09th june . The next day i.e. 10th june the value should get updated to 10th june. Is there any such functionality or formula available inside…
-
NO Time dimesin module to Time dimension module
HI I want bring the data from non time to time module. as mentioned screen shot
-
Can I have a code in a list mapped to different parent between two time periods?
I wonder if someone have come across of this use case: Our reporting hierarchy is based on Cost Centres i.e. Cost Centres are mapped to Business Units (Parent/Child relationship). There was a request to move a Cost Centre between two Business Units in July going forward, meaning that history remains unchanged. When I…
-
How to get the average of a previous month in the current month ?
Hi I have a grid where in I need to calculate the average of the commissions selected for a couple of months and then to send it to another grid of a different month. How do I do it ? PFA screenshots Need help urgently Thank you
-
Time mapping for daily data imports
I am importing data into Anaplan from a csv file. I am used to seeing the following screen for time mapping: However, this particular upload is daily data and I am seeing the following: Am I doing something wrong with the module setup or is this how imports usually look for daily data? Any advice on best practice for daily…
-
model search
Is this search feature buggy? I don’t think it is working as is. For example see below: I search for ‘calc’ I only want results with calc in it Below also gives results with references that contain c AND a AND l AND c This is not correct. The search is limited here. The Boolean logic behind the search does not seem…
-
Did anyone faced this issue, why Anaplan is not allowing me to fetch Items using FINDITEM formula?
I have a list named Custom Weeks, and applied FINDITEM formula to get items against 'Next Start Date Text', but except Week 40 FY22 and Week 49 FY22, FINDITEM is not fetching items from the said list. Need help. Formula for 'Next Start Date Text' : TEXT(MONTH(Start Date + 7)) & "/" & TEXT(DAY(Start Date + 7)) & "/" &…
-
How to deal with 3 dimensions having many to many relationship?
I am having some trouble connecting dimensions because I have a relationship with many-to-many and therefore I can not use LOOKUP as I am used to. I feel like I had some trouble explaining the problem before so I will use some screenshots. I have a model for a book retailer, and my final goal is to determine the…
-
Process Ignores one of the Action in it
We have one automated process which has five actions in it which clears the list and reload the new items in the hierarchy. When the automated process runs it ignores the last action which reloads the list. Upon checking we found that the Server has the necessary access to run the action and also the source system(i.e.…
-
Period Function is not giving the desire output.
Hi Anaplaners , I am using the PERIOD function to populate the month from the date-formatted line item. In my case, it worked fine till FY26, but it is not returning anything after December 31, FY26. My hunch is how Period works with model calendars?
-
1.4.3.2 Import Data & Add Formula
I'm getting an error for Sku and Product Code after importing Sku csv Does anyone understand why this is based on my screenshots? Thanks!
-
SYS08 Product Family issue in Level 2 Sprint 2/3
In rebuilding for the 2nd time due model loss, I am having an issue with getting the products to be assigned to their product family so I can get the correct values in SYS08 SKU Details and then use it in DEM03 Demand Forecast. Images are what is in SYS08 and the Blueprint of it. Where am I going wrong, it has become a…
-
Is it better to use CODE(ITEM( SKU List)) or to use SYS SKUDetails.code?
Hello, I need to concatenate two codes because I am generating a combined list. My first instinct was to utilize the function (CODE(ITEM()), but the example I saw in ANAPEDIA used the the systems module Line item [SYS SKUDetails.code]. Given that I don't even have a system module, I'm unsure if doing it this way is a bad…
-
List Item Change
Hi Guys, I have a change in the list item in Anaplan, the list is marked as a non prod list, I have to check the references for the SVs direct update in Filter, is there a quick way to do it? Though I have checked for the list references. Thanks, Anmol Sarna
-
Running multiple processes with one click?
Is it possible to run multiple process with single click and also be able to define the sequence of process. Similar to Actions
-
Selective access: Sum/Total does not work!
Dear all, My company is at the end of the project and we've just found out the Selective access cannot show the total budget amount! Particularly, we have many expense category and for example Labor expense include personnel costs (owner is HR department) and non-personnel costs (owner is general affair department) and…
-
How can I go from 2 dimensions to 3 with a many to many relation?
I have a model for a company that sells books, with the following relationships: [Store - School] - many to many The books from one school can be sold ate many stores, and each store sells books from many schools (used a boolean model with dimensions store and school) [School - Subject- SKU] - many to one For each subject…
-
Using the same DEV for 3 different production models
Hello All, I use the same DEV model for three different production models that represent three different divisions at the company but pretty much the same design. Recently, I needed to add new developments to one of the models, but I do not want to push that functionality to other two models. Now, I need to make a new…