-
Getting error message when trying to use lookup
Hi I am trying to use lookup function in one of my module and I am getting the error message ' Format of mapping used for lookup doesn't match any dimension of the source' The formula I am trying to use is 'Comp_config_group_workbench.Config Group[LOOKUP: Config LF ] for the line item 'Config group'. Can you help to…
-
Another Circular Reference Question
I am building a Cost Forecasting Model which uses different methods for calculating the forecasted amount depending on the cost category and the number of years into the future. One of the latest use cases is to be able to taken the calculated cost from the previous year, increase it by inflation and divide by 12 to give…
-
Un-check a box if it fulfills a condition?
Hello, Situation: I have a grid where a user enters in the number of tables they would need for an upcoming event. In the grid, I have a "submit for approval" checkbox for the user to check once they have entered their table demand unit. Then it goes to the Admin to either approve, reject or "put on hold." If it is put on…
-
Publishing Graphs Using Dynamic Cell Access - Is there a Bug?
Hi Planners, While I was working on graphs I found something weird going on while Publishing graphs using DCA. I am not sure if this is supposed to work exactly the way it is or is it a bug in the system. I have a Module with two line items Line A & Line B across monthly timescale I am using DCA Read Only for Jul, Aug &…
-
Planual Explained - Day 29
“Rule 4.01-08": Article 4, Chapter 1, and Rule 8 – “Avoid Refresh Buttons”. Educate the users to use the Refresh option in the toolbar rather than action "refresh" buttons to open dashboards Here is how it was done in Pre Planual Era: We used to create Refresh buttons and publish these buttons on to the dashboards. Refresh…
-
Unable to change the pivot of a module
Hi I am trying to change the pivot for my model by making the line items as columns and comp incoming inprocess demand sequence id as row. After clicking OK in the pivot form, I can see the changes take place. But, if I close the module and comeback,I see the changes are reverted and go back to previous setup. Can you help…
-
Line item type defaults to Number
Hi Whenever I create a line item in a general list or Module, the type defaults to Number and I have to change to the relevant type. As Text is the type we normally use, how to change the setup so that the type defaults to Text instead of Number? Thanks Regards Prabakaran
-
Planual Explained - Day 28
“Rule 4.01-07": Article 4, Chapter 1, and Rule 7 – “Avoid buttons for Navigation”. Use the contents page for navigation rather than clutter the dashboards with buttons Here is how it was done in Pre Planual Era: How often have we seen this kind of layout on our dashboards. That is exactly what should not be done What is…
-
Planual Explained - Day 27
"Rule 4.01-04": Article 4, Chapter 1, and Rule 4 – “Turn off module page selectors”. Show the page selector is appropriate but try and drive the selection from a general page selector. Here is how it was done in Pre Planual Era: We used to have page selectors enabled for each grid of the dashboard What is wrong with this…
-
Level 2 Model Building: Activity: Create DAT03 Historic Volumes Module
Hi guys I am having a hard time importing the Historic Volume file into the module. I think it has to do with the week?
-
Single formula for different list items
Hi, I have a list called Apple having items A,B, A+B. A+B should contain the addition of data of A and B. In the module i have a line item called data and applies to Apple list. I have to write the logic for Data line item such that the module shows up values for A, B and A+B should have addition of values of A and B.…
-
Optimizer - Variables min, max setup
Hi, From the optimizer user guide v01, for variable section, it states the min/max configuration are optional (as below and see the attached full document). So the optimizer has been configured without min/max. However, it flows an error when execute. Then, I configured the Min as zero and it executes successfully. If the…
-
Dropdowns in modules
Could someone help me how to bring in the dropdowns e.g. 'New York' or 'Volumes' into data modules?
-
Waterfall Chart Issue
Hi All, I am trying to build a waterfall chart and issue i am facing is on the End Total. Scenario - Publish a waterfall chart of basis points value ( not absolute numbers ) or you can consider the percentage value. We have a baseline and division wise input as basis point, we have show the movement across divisions and…
-
this is the order I have selected. It is correct with fronttoback design. what is wrong here?
NA
-
Suggestions for Creating a Data Point on a Version, Based on alternate Version
Our model has three key types of Versions - Actuals, Baselines, and Custom Scenarios. I have multiple Baseline Versions and many more Custom Scenarios - the end-user will be able to select which two they would like to use. My thought is a drop-down List of the Versions for "Baseline" - all other modules on the dashboard…
-
Assigning No Access for a User. What happens?
I'm trying to understand what this means. What exactly can get deleted as a result of assigning a no access to a user.
-
TIMESUM Function with aggregation method AVERAGE
Hi, I am using TIMESUM function with AVERAGE as aggregation method for specific from-to period. Some of the cells have the zero values in it, but this functions is considering those zero cells also into count . This gives me wrong average. How can we skip zero cells and calculate average only for non zero values with…
-
List : modification
Hello, I would like to create an easy way to add or delete some items from a general list for the end user. I saw that i can create an action button "create" to do that, but i can't find the list Do you know why, or how I can do that ? Thank you,
-
Optimal if statements
I want to make sure that I optimize my if statements, hence some question * If you need to get a maximum of two line items, is it more efficient to use an if statement "if a > b then a else b" or to use the max formula "max(a,b)" * Is there any performance difference in "if x<y then a else b" vs “if y<x then b then a” (in…
-
Retrieve List as Text used in Module
My model has a vintage or "Book Year" dimension which is being used as a list - we model that particular year's performance over time. I'm trying to create a module to result in a Boolean at the intersection of the Book Year and the Calendar year. I'm using a YEAR(ITEM(TIME)) = BookYear. However, I cannot seem to find a…
-
Show the current/logged in user in a single line item
Hi Community, I'm looking for a solution to show the current/logged in user in a single line item that has no dimensionality. The use case for which I'm looking for a solution is a dynamic filter based on the logged in user + to calculate totals based on this filter. More specifically, I have a mapping table dimensioned as…
-
Level 2 Model Building: Sprint 1 - Prepare for Spring 2
Hello, I have finished the Level 2 - Sprint 1, and am in the preparing for Sprint 2 section. I am stuck at the section of importing from the saved views. After I downloaded the model and saved in my own name, there are no saved views to choose from? Am I going to the wrong place for "in the Data Hub model"? Any advice on…
-
Import mapping issue
I have an excel sheet which has to be imported into an module. It has columns A,B,C,D and from E Column it has Time Dim and each of these have data. PFB the screenshot as below. In the Module, A Column, B Column, D Column are lists and C Column is just an text filed which has to be imported. Hence I created a line item for…
-
Loading an Anaplan Model: 504 Gateway Time-out
Hi all, I have recently been facing a lot of 504 Gateway Time-out messages when trying to load Anaplan models. I have narrowed it down to trying to open an Anaplan model and then switching tab on Firefox, so that the tab that is loading the model is not active. I have tested on other browsers and they do not seem to…
-
Mapping group
Hi team, I have problem about mapping between entity, entiy(holding) and group. exp: entity H have transaction with entity G, but they in a different group (H in group 3, and G in group 2), we can elimination if H and G in a same group, but group 3 and group 2 in the same group 1, so how to create auto mapping using…
-
editing module name
Hi Team, Can we edit the name of the module once it is created? eg module name entered is - REV01 Price book module edit version of module - REV01 Price Book If yes, then how to go about it?
-
Customised Time Scale
Hi All, I have a module with customised timescale. In Module A, dimensioned 24 Week Custom Timescale. In Module B with no dimension, I would like to get Sum of 12 Weeks from Module A. Any leads, please? Thanks.
-
How to obtain start month of a financial year?
Hello Experts, I'd like to obtain start month of a fiscal year. What I have now is current fiscal year in number format. And what I want to do is to compare item(time) and start month of a fiscal year, and get boolean for this, if item(time) is larger than start month of a fiscal year. thanks in advance. Regards, Inoue
-
Calculation Inquiry
Hi, PLease see details in the attachment. Regards,