-
Anaplan Dashboard Colors
Does anyone know the color code for the standard grey in Anaplan dashboards?
-
Exports into .txt file
Hello, I have a module dimensioned by fake time and need to export it into a .txt file. Because of business processes, I need fake time and the line items in columns unested. Is there a way for Anaplan to accomplish this? Thanks.
-
How do I add the name of the parent to a list?
I want to have the name of the Parent shown in each row in a column of a list. How can I achieve this?
-
Growth Assumptions on a consolidated level
Hi Experts, What is the best way to make a growth assuption at a consolidated level and have the same % growth apply to GLs underneath? For example - I need to grow my Salary & wages by 3% and have that 3% apply to all the 10 different S&W GLs underneath it instead of breaking back like 0.3% per GL to get the total of 3%…
-
How to show "Display Name" on the module instead?
I have created "Display Name" with formula inside. How to show this "display" name on the Module I created instead of the regular list (on the left)
-
Anaplan Optimizer - minimize products used
Hi Optimization Pros! Would you be open to providing some input on whether this can be done in Anaplan Optimizer? I want to minimize the number of SKUs picked for shipment (i.e. we would prefer to fill a shipment by picking one SKU rather than two SKUs). These are the two designs I’ve tried with no luck. Variable: SKU Qty…
-
How to get an average time difference between dates for a particular month?
Hi Community, I need to use the difference between 2 different dates B-A & then get the monthly average of the difference for the month B in anaplan. Sample Data is mentioned in the Table below. Average for month (based on the Diff.) Month (Based on Date B) Diff. (B-A) Date A Date B 50 Feb B1-A1=x1 A1 B1 B2-A2=x2 A2 B2…
-
Gigabyte Missing for Workspace Calculation
Hello Anaplanners, I am currently working on a size simulation model. The purpose is to reproduce the "model info" shown in a model and apply some changes (create new module, extend a time range...) to see the impact on the model size. I have already calculated the cell counts of my source model but I am not matching the…
-
Can you scale the X-Axis in a graph/chart if the X-Axis is the Time Dimension?
Seems like in the New UX graphs and charts axis's can be scaled if the axis is a line item. However, there should be an option to scale any axis even if it is a dimension especially Time. For example, daily data would look neater and present better on presentations/decks if the time scale could be reduced to show SOME time…
-
FP&A Budget Allocation Best Practice
Hi All Wanted to make sure I am thinking about the infrastructure of our Anaplan build correctly. We are going to build driver models which are going to contain the line item detail and dimensions which will be summarized into our spoke models which then in turn will be further summarized in a consolidation model. This…
-
List item has nothing showing in 'Referenced in Formula', but it is referenced?
I have a list that shows no references, and i was removing ‘dead’ lists however, when i tried to delete it i got an error saying it was used in a module. And after looking i found it was indeed used So why does the reference not appear in the list information?
-
Anaplan-Power Bi Connection using Basic auth-Blank source
Hi, I am trying to connect Anaplan & Power bi, I followed steps metioned on Anaplan community, but I was not able to see data in Power Bi. In Anaplan I have created one test export action. In Power bi I have entered below url in next step, I'm using my Anaplan User name & Password associated with the models. but I'm not…
-
Additional practice models/builds
Hi Anaplan Community! I've completed the certified builder program, but am wondering whether there are any additional practice builds out there that I can attempt? e.g. I'd like to practice building an ICM/SPM model. Thanks!
-
LOOKUP not working as intended
Hi Anaplaners, I'm having an issue with IF ELSE Statement. I expect the ‘ELSE’ part to go accross opposite direction than the ‘IF’ condition. But it seems to not be working using a LOOKUP function but works with a SELECT function. I want to promote it to PROD but I can't do it with using a SELECT BUT INSTEAD A LOOKUP.…
-
Schedules Mapped by Entity Name in Anaplan
In Anaplan, I have a schedule that needs to have the name of an entity name change to the English version. I was put on notice recently, that the schedule is being mapped by the entity name. Can anyone provide guidance on how I would be able to see in Anaplan exactly how that schedule is being mapped by entity name and…
-
User Access Between Schedules and Snapshots
I have a user who has access to schedules but doesn't seem to have access to the corresponding Snapshots. A few things I have tried so far, are: 1.) Confirm their role and that they have access to the schedules 2.) Used my account as a test account to recreate the issue. When I tried to recreate the issue, I was able to…
-
SKU to Format, Flavour, etc
Hi Guys. I have the following issue with our Anaplan implementation. Our SKUs can be rolled up either to Format (FO), Flavour (FL), Volume (VO), etc. All these have parents such as F1 > F2 > F3. The common denominator between all of them is the SKU. I have created a SYS module that has all of these as properties, therefore…
-
Handling Gap in Data Stream
Hi all, Due to a 2-3 weeks of gap in the data stream, I need to ignore the data for those weeks from all computations in an Anaplan model that is nearly 50GB in size. If those weeks remain as null/no data, those cells would still remain part of the computation particularly if the logic indicates Sum/#N Weeks or moving…
-
how it work for sales manager
how our platform work for a sales manager who is responsble for profit and loss account of food products marketing company
-
Sum based on Parent in Hierarchical List
Hi, I have a hierarchy of lists, L1>L2>L3. My module is dimentioned by L3 and has two line items, Input value and Input %. Input Value is entered by user. Input % = Input Value/Sum of Input Values for all list items of L3 under a L2 list item. How can I calculate this sum, as it is the sum of all items in L3 under L2 a…