-
Decoding Anaplan Errors in Model Building
Anaplan is a very smart and intelligent platform, and it educates its model builders/developers brilliantly about the mistakes or errors made. Here are some of the common errors that may occur while model building—decoded. ERROR 1: Automatic Sum of “Module.Line item” over “List hierarchy” is not possible, as “List” doesn’t…
-
Formula Help
Hi Community , Can anyone help me describe how to use RANKCUMULATE function with an example , I understand the function syntax and all but I want to understand a use case of where this function can be used. Thank you!
-
"Use Switchover" & Version Switchover Change
Bit of a weird thing happened in a model today whilst preparing it for the next round of forecasting. Change the switchover date of forecast from Oct-21 to Jan-22... and 6 minutes of toaster time followed by an invalid line item message. Really quite weird, as this hasn't happened before - so I check the line item and the…
-
RE conditional Formatting in Level 2 MB Sprint 2
Hi , Please help me how to create conditional formatting for below. Thanks Abhishek
-
3.3.6 Changing OFFSET to LAG
Hi all, Having some issues changing the OFFSET function to LAG. Using the following formula; LAG(PO Submitted, Final Shipping Time Weeks, 0) My Final Shipping time in weeks is 1 for the PO submitted column, the lag I am seeing is however 2; The only way I can get the LAG to show up correctly is by checking multiple…
-
Configuring Write Access Driver by Drop-down
Hello, I am trying to configure the write access driver of an item to build something as follows: If drop-down item is selected, then the write access to a column is revoked. Else, you have write access. Can a write-access driver be configured to dynamically change once a drop-down item is selected? All the examples that I…
-
3.3.5.2 Question of Preference/Efficiency
Concerning the "Confirmed Purchase Order Receipt" field. The "Hints" suggest; IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0 That is working fine. However, I was thinking about using POST, as I do in the "Confirmed PO Delivery". Instead of using an IF THEN…
-
UX: Ability to remove hierarchy level shift in grid
That would be nice if I, as a model builder, will be able to diasable hierarchy level shift: Now I want to describe my problem. Suppose, there is a simple list with various levels in one: No parent hierarchy: This is required to have proper calculations on summaries. After selecting a module with this list appied on a…
-
Give the MB the ability to Report with a click when they hit an error.
REQUEST: give the MB the ability to Report with a click when they hit an error like this one. It would give the error logs along with the ClientSessionID.
-
Access to Workspace
How do I confirm whether I have access to workspace and if I have workspace administrator permissions?
-
Waterfall Chart
Hello, I have Query related to waterfall chart in Anaplan. I have a below modules with line items mentioned. Want to create water fall chart with Actual Contribution line item acting as a total in the Chart. Since Actual Contribution line item does not have simple sum of above line item. It doesn't allow it to act as total…
-
3.3.5.2
Can anyone guide me as where have I gone wrong in this activity
-
Level 1 Activity 4
Employee Details csv is clustered and not showing up in columns.
-
Add MEDIAN Function to Anaplan
As we expand our use cases within our org, we are faced with more and more times that we need to calculate a Median within a data set (ex. Revenue, Median Deal Value, Median Salary, etc.). There is a quite elaborate workaround that is posted on the community, which has been a lifesaver, but it takes up to 13 line items to…
-
Christmas Brain Freeze or Summing from a module when you don't have time as a dimension
Hi, I have a module (SER) with simple data for a PO, value and a year period by customer In an invoice module (that does not have time as a dimension) i want to see the total value for that customer for the year. The invoice items has a Year based on its posting date. SER.Value[SUM: SER.Customer] This gives me the total,…
-
Save Space With Snapshots
When it comes to model size, few components add space quicker than versions. This is particularly true in use cases that rely heavily on scenario planning and what-if analysis. For example, a supply chain model may need to generate a monthly forecast with a best, worst, and average set of inputs. Especially when time…
-
Product Summary Method
It would be useful to have the option of Product as a summary method. For example, if you have a list of % discounts that all apply to one sales order then they need to be multiplied together in order to give the total discount.
-
Level 2 Model Building Completion
Hi, I finished the level 2 training and I have submitted my model(Tuesday, December 28) and I have completed the survey. However, I didn't get any confirmation or anything stating that the level 2 course is completed. Request to please let me know what are next steps i need to do to get the certification and have the…
-
How to learn anaplan
Hi I got workspace access of anaplan, please guide how to learn anaplan step wise.
-
Selective access
Can Selective access be applied in case of Dependent filter and list has not been considered in dimension?
-
How to get last day of the month
Hi everyone. I would like to get last date of the month when certain data is entered. Image: I would like to get only the last day of each month that meets the conditions. Item is List format. Please tell me good solutions. Best regards.
-
Level 2: Sprint 1 Activity: 1.6.3.3
Hi, I am unable to get the result as per the screenshot with respect to Create Saved View for Export (1.6.3.3). I gave Time dimension as Half-yearly only. But still the columns FY19 & FY20 appears in my module (DAT04 Distribution Center Parameters). Please find the screenshots for reference. Thanks in advance.
-
Submit Button
Hi Community, Is it possible to create a submit button either in the old user experience or new user experience in talent builder workspace (i.e Anaplan learning workspace) Thanks & Regards Badam
-
RE verification of line item formula from SYS01 Time Setting by week module
Hi , Please guide me if i used wrong formulae for below line item. Thanks
-
Submit Button
Hi Community, I need to build sales planning process, where region heads should be able to submit the once they are done with the planning process and it should flow to the CEO. As a part of it I need to create a submit button in the dashboard. Is it possible to create such buttons either in the old dashboard or new user…
-
Level 1 model building exam question 4
Hi, I’ve imported all the data on employee expenses with no error. However, when I want to see the medical costs for finance department, the bonus, car costs, phone costs and medical costs are empty. Attached screenshots of the formulas. can anyone assist me please?
-
Level 1 modal building exam medical costs
Hi, I’m attempting the question to update the formula for pulling allowances from SYS08 module. However I got the error “data type mismatch. Format other than LIST or DATE being referenced as a relation” may I know what does that mean? the formula I have keyed is: IF Employed? THEN Salary * EMP03 Employee Drivers by…
-
Confirmed PO Delivery - OFFSET
Hello, 3.3.5.1 Create Inventory Ordering Module I'm having the hardest time understanding which line item to use in the Confirmed PO Delivery formula. The threads I've read keep referring me to the POST function, but I'm not at that point in the training yet. The following set of instructions are confusing me: * Set the…
-
8.6.4 Activity: Add Formulas to Margin Calculation Module.
Hi Community, For this activity in my model I don't have the dropdown selectors. What am I missing? This is my model: This is the lesson page: I don't have the drompdown for city or product. Please help. Thanks.
-
Need help with 1.5.7.2 Add Formula to SYS13 Line Item
Hi All, I am struck at this point. I have followed the notes carefully Add the formula for the Has Data? line item in the SYS13 Account SKU Filter module. Considerations for the formula: * How could you sum the data over all time periods? * All Periods is not an aggregation method at the model-level timescale. * The…