-
Latest Article: Importing with Varied Dimensions
Please read out my latest article on Imports featured under best practices. https://community.anaplan.com/t5/Best-Practices/Importing-With-Varied-Dimensions/ta-p/89698 Misbah
-
Stacked Column Graph
I would like to reproduce the above stacked column graph in Anaplan, but can't get the labels on the bottom axis to appear in the same way. The best I have achieved is this (I have limited the data selection to make the issue more obvious). I have two columns for each month, but it doesn't show which is forecast and which…
-
Building a Cash Flow Model (Need Advice)
Hi, So I'm playing around with trying to build a Cash Flow Model in Anaplan that is on a Daily Time Scale [WeekDay Function I plan to use] and has Line Items of different Accounts in the company that must stay at a min/max balance daily. I want to try and make this an Model that will automatically allocate the money around…
-
Reorder flag
In module 2 sprint 3 it says keep the reorder flag referencing to Suggested order amount. WHile my formula for reorder flag is OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 I cant get it Pls clarify
-
INV 01 inventory ordering final forecast figures
HI My final figures for Forecast Demand in Inventory ordering s not matching with the one shown in training module LEvel2 sprint 3 .Please find attached the screen shots training and mine.i know figures are being pulled from DEM03 final forecast hence pls find below the blueprint view for the same too and let me know what…
-
model building activity 6 add formulas to REP04 module line items
hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
-
Level2 sprint 3
My figures in Inv 01 ordering is not matching with one given in training module I have attached both figures and formulas used please guide whta I am doing wrong
-
Building a Cash Flow Model
Hi, I have started Building a Cash Flow Model for my Excel Spread Sheet and I need advice on how to decide the structure of my Model. So far I have made Module's made after the Yellow Tabs in my Excel Model and made the Line Items of my Modules the First Columns in my Excel Sheets (The things that I need to calculate and…
-
Domain and IP Allow Listing
This content is now available in Anaplan Support.
-
Anaplan Live!—Your Opinion Matters
We're getting ready for our next Anaplan Live! event. As active Community members and model builders, your input is extremely valuable. Our mission is to bring you content to boost your model-building skills, no matter what level you're at today. Take this brief survey, and let us know what you want to learn more about.
-
Job Aids During Discovery Phase?
Hi Everyone, Are there any documents/job aids that summarize the key questions to ask clients during the Discovery Phase? I'm referring to more specific questions than the broad overview in the Anaplan Way. For example, there are great posts here with questions you could ask a client when figuring out what dashboards they…
-
Anaplan Connect Install 1.4.4
I am installing Anaplan Connect for the first time. When I try to run the import script, I get the below error message. I do have the WorkspaceID in there. I also want to runt the script on a shared drive in Unix if possible. Can anyone help? Thank you. ======================================================================…
-
Anaplan Connect Migration v1.4. SQL Server Connection (check sql server driver for jdbc)
When migrating some Anaplan connect scripts from v1.3. to v1.4. I encountered an error with my sql connection. The error I received when running my script was something like 'check sql server driver for jdbc'. I wanted to share the solution for reference as it was not that obvious. In my original script (v1.3) my…
-
What protocol and port(s) does MuleSoft Connector use?
Hi, My current client has selected MuleSoft Connector to orchestrate the integrations between Anaplan and their legacy systems and they are asking what is the protocol and port(s) it uses to connect to Anaplan. I've searched through Anapedia and the Community and I was not able to find the answer, however I assume it uses…
-
NEW UX- BOARD QUESTION
Hi, question please. Would like to ask on why I cannot see the numbers when I open the phone app view while in web I can see the values? I publish KPI and used line item view. PHONE APP VIEW: WEB VIEW:
-
LEVEL 1 MODEL EXAM
Cleared the exam but was not able to get one answer in Activity related to calculating expenses by region and role Can anyone let me know what was the correct answer or whom to contact for the same
-
New UX: Can Context Selectors Drive Parent Choices in Form Created List Members
Hi everyone, I have a very specific new UX question around context selectors and their impacts on the UX. I've created a list hierarchy with a numbered list at the bottom. This numbered list represents something not unlike transactions. I've created a form in the new UX to allow for creation of these new transactions, with…
-
Academy: Model Building Level2, sprint 3, Lesson 3.5.5 question
I have a question for Model Building Level2, sprint 3, Lesson 3.5.5 and the product SKU by Distribution Center panel on the Distribution Center Summary UX page (in My Pages). I got it working, but I want to know if there is a better solution as my screen layouts are slightly different to the prototype. I used a grid and…
-
how to add Export Qlik Extract into an existing report
Hello guys. Can anybody help me to go through this? I need to add * Export Qlik Extract into an existing report thank you.
-
Optimiser Time out error
Hi, I am running an optimizer with Time out limit of 20000 seconds.However post 60 mins it throws the following error: "The solver was cancelled due to timeout, please increase the solver timeout value to solve the problem" Does Anaplan has the limitation of only 60 minutes? Not sure what is the issue. Can anyone please…
-
To build formula which is like PREVIOUS() but references a list item instead of time
Hi All, found out a work around for this, until Anaplan creates an in built function to fetch previous or next values in a list, without referring to Time dimension. Hope this helps Link to Anaplan Idea Exchange: https://community.anaplan.com/t5/Idea-Exchange/PREVIOUSITEM-formula-which-is-like-PREVIOUS-but-refer... Other…
-
Planual Explained - Day 38
"Rule 1.06-03": Article 1, Chapter 6, and Rule 3” Avoid single item subsets If possible, try and avoid single item subsets, if there is a top level in the list, a single item subset will always have two members Here is how it was done in Pre Planual Era. We used to create a subset which includes/houses just a single list…
-
Planual Explained - Day 37
"Rule 1.05-11": Article 1, Chapter 5, and Rule 11” Do not embed Numeric values or Dates within the Code of a list Dates and values are "data" and should not be part of a code Here is how it was done in Pre Planual Era. What is wrong with this method? Dates and Values are data points and should never go to the list as part…
-
GENERAL Information of Anapaln is gets displayed in log file after running the batch file
Hi All, I'm fetching data into Anaplan model using the BATCH file, which is connecting to Oracle Database and fetches into Anaplan model. And i'm writting the bach execution into a log file i.e; example: Load_Fact_PR.bat > runlog.log. After the run finishes while looking at the log there is a GENERAL Information of Anaplan…
-
Dynamic List filter not syncing on Pages
Dear Community, I try to make something work in a Page on the New UX : I have the following : - An input module "Forecast collection" dimensioned by Time / Version / Entity / Cost Center and Project for users ton enter amounts - An Input module identifying which CC can access to which Projects to input costs on it "Cost…
-
Anaplan Export using JDBC properties files
Hi All I have an issue when trying to execute an insert query using jdbc. # JDBC Connection string (Oracle, Mysql, H2, etc.) jdbc.connect.url=******* # JDBC login username jdbc.username=****** jdbc.password=****** jdbc.fetch.size=10 jdbc.isStoredProcedure=false jdbc.query=Insert into flash_rw (Period) Values (?);…
-
Combination Chart for Capacity Analysis
One chart that I would like to be able to more easily create in Anaplan NUX is the stacking resource usage chart that is common in capacity planning. Usually looking something like this: With each stacking bar representing the usage of my capacity by a product or group of products. I have had a workaround for making these…
-
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…
-
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…