-
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…
-
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…
-
Planual Explained - Day 22
“Rule 2.02-17": Article 2, Chapter 2, and Rule 17 – “Put the most common condition first”. “For formula efficiency, put the conditional with the most common occurrence first in the formula. It goes against PERFORMANCE elements of PLANS if you wish to go against this rule Here is how it was done in Pre Planual Era: What is…
-
Planual Explained - Day 21
“Rule 2.02-12": Article 2, Chapter 2, and Rule 12 – “No Hardcoding to List Members”. “Avoid direct references to list item. E.g. IF ITEM(list) = list.xx. It goes against SUSTAINABLE elements of PLANS if you wish to go against this rule Here is how it was done in Pre Planual Era: Hardcoding to list items used to be a norm.…
-
Planual Explained - Day 19
"Rule 2.02-15": Article 2, Chapter 2, and Rule 15 – “FINDITEM on blanks”. “If the list being referenced does not contain blanks, there is no need to check for blanks with IF ISNOTBLANK(List) THEN FINDITEM(List, Text) ELSE BLANK. It goes against PERFORMANCE, NECESSARY elements of PLANS if you wish to go against this rule…
-
May 2020 Release Updates
May 2020 Release Updates Did you check out the latest features released in May 2020. Here is the link for full updates and a sneak peak at June May 2020 Releases and Sneak Peek at June - Anaplan Community There are a lot of features that are released but here are the details about some of the amazing features released in…
-
Planual Explained - Day 18
"Rule 2.02-08": Article 2, Chapter 2, and Rule 8 – “Never use SUM and LOOKUP together”. “SUM and LOOKUP used in the same expression generally cause large formula calculations and may cause intermediate relationship calculations especially if Time is a dimension or when the source and target structures are very different.…
-
Planual Explained - Day 15
"Rule 2.02-03": Article 2, Chapter 2, and Rule 3 – “No Repeated Expressions”. “If the expression is repeated in the formula (or other modules), put it on a separate line item. Calculate once, reference many times. It goes against PERFORMANCE, NECESSARY elements of PLANS if you wish to go against this rule Here is how it…
-
Planual Explained - Day 13
"Rule 2.01-16": Article 2, Chapter 1, and Rule 16 – “Use Data Tags”. ”If not using for any other reasons, use Data Tags to signify the DISCO category”. It doesn’t go against any element of PLANS but why not use it when we have the functionality available. Use Case: As a workspace admin I need to check if ALL Countries are…
-
Subsidiary Views - Synch DB from a module with a specific line item
Hi Team, Anaplan states that 1 of the only acceptable times to use a Subsidiary view is where you are syncing Dashboards from a module with a specific line item Is anyone able to help with an example of this? Thanks! Mark
-
Planual Explained - Day 6
"Rule 1.05-10": Article 1, Chapter 5, and Rule 10 – “Never delete list and reload the list as daily occurrence”. Using a unique key to update to values rather than delete and re-load. It goes against P & N elements of PLANS if you wish to do so. Here is how it was done in Pre Planual Era: When we had to delete the…
-
Basic Authentication Talend Workflow Example
There is a small, but growing, user base interesting in integrating with Anaplan using Talend. Previously, we shared (upon request) a sample workflow, with the launch of our latest API version, I've been working to update this demo. Today, I'm sharing a very simple workflow, which fetches a list of imports from your…
-
Anaplan Live Enablement Series - New UX Session - Zoom Recording
Attached is the Zoom recording from the New UX Session held on April 14, 2020.
-
Anaplan Live Enablement Series - New UX Session - Power Point Presentation
Thank you for joining the Anaplan Live Enablement Session on New UX How-to and Best Practices. We hope you found the session useful and that you're able to apply what you learned to the dashboards that you're building. Attached is the Power Point that Monica presented.
-
Introduction to Data Integration
Audience: Model Builders, Data Integration Specialist Summary: Hungry to know more? Anaplan Advanced Topics are deeper dives into specific areas of Anaplan. Data is everywhere, and our customers are eager to know more about how they can get data from their databases and into their models. This process is called data…
-
Check out Ask Me Anything: New UX
Simon Ritchie, Anaplan's Sr. Director of Product Management, answers popular questions about Anaplan's new user experience. Read the comments below the video to see the questions and answers submitted during our live Q&A session. Click here to watch the video. Note: The live Q&A session is now closed.
-
Informatica cloud connector for anaplan not working
I am trying to use anaplan connector in Informatica cloud and it says the connection got created , But while using it in data synchronization it is not able to load imports and export definitions. APi major version is 1 and minor version is 3 as shown in Turotial videos on Anaplan site Basic authentication is used.