-
Is star schema is best or snowflake schema in Anaplan
Hello All, Can anyone suggest me which one is better between star schema and snowflake schema in Anaplan? I don't have much knowledge regarding both of these comparisons. Please suggest to me.
-
Planual Explained - Day 30
“Rule 4.01-09": Article 4, Chapter 1, and Rule 9 – “Publish charts will full filters initially”. If the chart has a filtered axis, set the filter such that all items are shown, then publish the chart. Then set the filter criteria back as desired; the chart will then respect the filter Use Case: Based on the selected month…
-
How to build a logic in Anaplan to solve the attached problem
Need suggestions on how to build the logic in Anaplan to solve the problem in the attached file. Negative CF is to be adjusted first from the previous weeks and then if balance amount is there then we have to look into the future weeks for the adjustments. For a specific week, you can go back by "m" weeks for adjusting the…
-
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…
-
level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line
level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line items. Open the REV03 Margin Calculation module. Toggle to blueprint view to enter the following formulas for each line item: Line ItemFormulaRevenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Sales Price * (1 + Sales…
-
Import same value from 2 dimension module into 4 dimension module
Hi, Have a small challenge - I'm trying to import line items from one module with 2 dimensions and into another with 4 dimensions. The 3rd dimension in the latter is set to ask on import but the 4th is irrelevant, i.e. the import should basically import the same line item values into the module for every item in the 4th…
-
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
-
New Filter Option: "Absolute Value" and "In Between" Filter
It would be very helpful to have a filter option added that allows a user to filter on absolute value as well as to filter by defining a top and bottom range that returns amounts in between the range. Currently, we have built line items as a work around, but these tend to take a lot of space. This functionality should be…
-
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…
-
PLEASE HELP--- Importing a value in the list
Hi Friends, I have a module abd SYS Mod 1. It has no list but only Line Items. I want to import, the Line Item value (ie. Jun 20) in the list. Kindly assist.
-
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…
-
NUX: Enlarge freely a Text Formatted Line item published as a field
In the old UX, when you published a Text Formatted Line item, you could make the text box as big as you want. In the NUX, when you publish a Text Formatted Line item as a field, the size of the text box is limited. I would like to be able to freely choose the size of it.
-
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…
-
Clear launchpad filters without selecting reset
Description of the enhancement required: We would like the ability to remove filtered values individually, instead of clicking 'Reset' and refiltering the entire model list from scratch each time to wants to remove a filter value. An example of the enhancement: Login to Anaplan.com > Within the launchpad, click Filter to…