-
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 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 (?);…
-
How to Become an Anaplan Solution Architect
A new overview for the Professional Solution Architect certification is now live in the Anaplan Certification Center. It includes the latest requirements, process updates, and key resources to guide your certification journey. Visit the updated certification overview page »»
-
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…
-
Anaplan AWS Integrate Conflict
Hi! After we integrate Anaplan to AWS servers (https://community.anaplan.com/t5/Anaplan-Platform/How-to-integrate-Anaplan-to-AWS/m-p/63302) we starting to get analitics data conflicts. We grab data from Google Storadge which work with site(here link), grab with Python on AWS. Our bisness analitics have Flask microservice…
-
June 2020 Release Updates
June 2020 Release Updates Did you check out the latest features released in June 2020? Here is the link for full updates and a sneak peek at July June Release and Sneak Peek at July Some of the features that look amazing are 1. KPI Card Sparklines: You can add Sparklines to your KPI cards to spot patterns or peaks/troughs…
-
Optimizer Exercises - Production Optimization
Hello, I have just done the Optimizer exercises Optimizer: Exercise Walkthrough created by @mark_godfrey , and have an error in the Production Optimization Exercises example. While its possible I messed with the base data, I'm getting exactly the same answer as a colleague. I compared my answer to Optimizer: Use Case…
-
Planual Explained - Day 26
"Rule 1.04-02": Article 1, Chapter 4, and Rule 2 – “Utilize Show Content On/Off for Different Functional Areas”. “To reduce maintenance, create separate Functional Areas for dashboards and modules (e.g. Reports and Report Modules). In the Contents tab, turn Show New Content "On" for all dashboard Functional Areas and "Off"…
-
Planual Explained - Day 23
“Rule 2.02-19": Article 2, Chapter 2, and Rule 19 – “Don’t daisy chain”. “Always refer back to the ultimate source if possible, to avoid creating more dependencies than necessary. This allows more parallel calculations to be run increasing efficiency and speeding up calculations. It goes against PERFORMANCE elements of…