-
L1_MB_BalajiBirur
Dear Team I have created a model in the space provided. Now i have forgotten hw to go back and access the model created. Could you please show me the path of the model which i have created. I want to access my model L1_MB_BalajiBirur
-
Issues in populating the start date and end date fir SYS08 Employee details
I tried to import the Employee details sheet into SYS08 Employee details module.. Except for the start and leave date, all other data got imported. I tried the Custom format for Date as well, it did not work.. If anybody has any soluton, pls help
-
Evenly Spread Amounts
Hello- We have two modules one for planning miscellaneous revenue and other for planning for OTPS. When a user enters an amount in the FY21 column the amount is not spreading evening for the forecast period. The forecast period is 6 months. Please see the attachment. I am not sure what I need to do to fix this.
-
Error - Array index out of bounds
Hi, I have a OUTPUT module that has 10 line items - I made a LISS out them and created a SYSTEM module with the LISS as a dimension in order to map the LISS to a list. I then go back to the the OUTPUT module and reference a CALC module for a number, and do a LOOKUP on the SYSTEM module. This works for all line items except…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello, I'm receiving the attached error for step 9.1 - Model object "'DAT03 Historic Volumes'.Export" could not be located. 9.2 and 9.3 seemed to work fine. Thanks, Sean O
-
6.8.6 Activity: Add Formulas to Location Details Module
My Changes Please guide to resolve the issue , actually i am getting extra drill down feature next the Module name Not coming as required output Expected output Regards, Srinivas
-
Level 1 Model Building : Question 2 not clear
not getting the answer of this question. Please suggest the answer of this question.
-
Import Data into DAT04 Distribution Center Parameters Module
Hello, I'm trying to import Weekly Safety Stock Csv file into the DAT04 Distribution Center Parameters Module. I'm not sure if something is wrong with my mapping, because I'm not getting any error, the import is being successful without data from the Csv, import results tab says ignored, why is my import getting ignored?…
-
L1MB Activity 5
Hi Team, Looking for some guidance on L1MB Activity 5. I built the following code: IF Employed? THEN Salary * 'EMPO3 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYSO8 Employee Details'.Department, LOOKUP: 'SYSO8 Employee Details'.Role] ELSE 0 But get the following error message: "Automatic sum of 'EMPO3 Employee Drivers By…
-
REP02 SIZE MARGIN REPORT VALUES NOT APPEARING
Hello Everyone, The values for 'Revenue and Cost of sales' are not appearing in the REP02 Size Margin Report Module. Please find attached screenshots for your reference. Please help me.
-
How to get the first year from a Boolean
hi! I want to get a year. If there is a Boolean value at the beginning throughout the year, we get the year How do i do? Please help me!
-
max date
Hi Anaplan expert, The module below has a numbered list and some line items. The formula on the Max Date field is Date[MAX: Date]. I didn't get any results. Could you please tell me how the formula to get the max date from the Date field is? Regards,
-
Level 3 UX Prototypes
Hello, For the creation of UX Prototypes in Level3 MB, kindly suggest how to start designing the UX. For Assigning to Accounts Territory I am unable to design. Please advice. Thank you, Sneha.
-
Logics can be used for repetitive Users
Hi I am having a module with Products list as dimension and Users(Default Users formatted), Status and Boolean(Target Line item) as line items. I need Boolean to be checked for the Products wherever Users are same and Status is Inactive. UsersStatusBooleanproduct1User AActive Product2User AInactiveTRUEproduct3User…
-
Target Adjustment
Hi Community, If regional sales executes adjust an accounts data manually, then should we adjust the remaining accounts targets in an proportionate manner to meet the overall country target? Is that a fair assumption ? Thanks & Regards Badam
-
Level 1 Model Building Exam Model Building Activity 6
I need a little help figuring out why I’m getting the the message pictured when entering my formulas.
-
Get Last data in all time
Hi, I use week General as Time setting. I want to get Last day in all time. Module A Time2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/7Num1111111Offset(Num,1,0)1111110Last day 2021/1/7 I can get last day in Module A. But I couldn't get in Module B( has no time, has Product List) Module B ProductLast…
-
SUM Function and List ALL
I want to aggregate the order From Table A to B. Table A RegionProductamountax100 y10bx200 y20 Table B Regionaggregatex300y30 I input the formula as below. Aggregate = Amount [SUM:Region] But I could not calculate it. If I have RegionALL as Region's top level of item, I could calculate it. We should use Top level of item…
-
how to use Lookup when source module has no dimensions.
My source module has no dimensions so How do I use lookup to transfer my data to result module. My Source file My Result module Data should onlu inserted in ABS not other two.
-
Exam Activities
Is there any way to get back on track. I think since I didn't get the right set up for the Activity 5, All of my answers have been wrong since even though I am adding new modules. Do I have to scrap the example? because I also made the mistake of having my model open and some things were built out in there by mistake.
-
8.2.2 Activity: Add Volume Inputs Module
Hello, I am getting this annoying error. I have looked up into community but haven't found any solution.
-
Which aggregate function is good at performance
Hi, I want to use aggregate function. I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module. Date Lineitem has Date format. I use " OrderA.Date[Max:Product]" as Formula. And I can also use "Fristnonblank" and so on because Date Lineitem is common in module. Which Formula is good at performance? Each…
-
Summing data in a ragged hierarchy (just for reporting purposes)
Is there a way to sum data in a ragged hierarchy that will only be used for reporting? My source module is a Data Load module with all my GL transactions. The target module will be an output report dimensioned by a ragged hierarchy. I can get the data to sum on the lowest levels of the hierarchy but Anaplan does not seem…
-
comparing list items and changing value
Hi, In a module I had a list (A1,A2,A3,A4) and a line items Value,type(list formated line item),change value if two list items has same type and status as inactive then change value for inactive list item should get active list item value EX: valueTypeStatusChange…
-
SYS08 Employee Details Import Issue
Hello everyone, I am struggling to get it right. Could anyone help? Here are the snapshots. I have added all of the snapshots for your information.
-
Many to Many Sum in a single step?
I am in the middle of a model build and am running into a situation where I feel like there should be an efficient option to do a calculation, but I can't figure out a way to do it without a 'staging' line item that bloats the model. As the title says, I have a 'Many to Many' relationship - a single Deal can be tagged to…
-
Isolating Top Level Parent in a Boolean
I am having an issue that I'm not sure is able to be solved, but wanted to ask the community to see. I have a hierarchy as follows: Top Level = Total Company BU L1 parent = Total Company BU L2 parent = BU L1 In a boolean line item dimensioned by BU L2, I've tried a million ways to try and get the "Total Company" box to…
-
FINDITEM formula gives blanks whereas I expect values
Hi Anaplan Community, I have a strange behaviour in Anaplan. I use finditem in 4 different line items (Site 1, Site 2, Site 3 and Site 4) . The finditem formula is similar for each line item, it just refers to another text-formatted line item to perform the finditem. The result of the Site 1 formula looks good. However,…
-
indention and Summary using LIS
Hi Community, I would like to ask question, since I have not encountered this matter before. Below is a sample report with indention and Summary style. In this sample report, the items on the row are all Line items. For example the list below is a line item subset. Will I still be able to have indention if I am using an…
-
Holiday Time Filter
Hi, Trying to create a Line Item in my SYS Time Setting Module that filters out all of the Business Holidays that we are not operating. This is a Daily Model and not sure how to approach writing the Formula for this. I need to Eliminate the following Holidays (New Years Day, MLK Day, Memorial Day, Labor Day, Thanksgiving,…