-
List and Time Dimension in one row on new UX page
Hello Team, Can we merge List and Time dimension on one row on UX pages. Below is module view when I publish this on UX page and export into excel it show result as below. (in two line one line for list and other line for time dimension) The requirement from end user to have only one row i.e list name and period. excepted…
-
Anaplan should provide a learning environment for Workflow functionality
My understanding is that there is a licensing fee (applied to all non-read-only users within a tenant) that has to be contracted and paid in order to open up the new Workflow functionality. I don't think this is fair, because how are we (as the Anaplan experts and model builders) to understand the technology to be able to…
-
What is the best practice for users creating list members?
What is the anaplan best practice for creating list members? Say…. 200 users say they need to create 15 list members in a spoke model…. Is it best for the users to…. Have them fillout 1 form per member using new UX “form” capability. Add 1 member in dashboard at a time with "Create" List Member action on a numbered list.…
-
getting Error while importing a large file which was successfully uploaded few days ago.
Hi Anaplanners, I am getting error while running a import action by uploading a large size file. The same file was successfully uploaded with the same action 3 weeks ago. I have tried all the ways:- tried after by clearing cache and cookies tried to make new import action with the same file. restarted my system and…
-
An NPV formula that calculates as Excel's does
Description: To have an NPV formula function that calculates NPV exactly as Excel's period-based NPV formula does. Benefit/impact: Current NPV formula returns results as Excel's XNPV formula does (using elapsed days instead of periods). We are in a position of having prospective customers and existing customers use…
-
Circulance References Issue
When apply formula on Confirm Purchase Order Receipt line in the INV01 Inventory Ordering Module i'm getting error
-
% Mix Calculation
I am looking to create a % Mix calculation to create a line item to bring into one of my app pages. For example, I want to create a column next to 'Locked L52wk CY Vol' that shows the % for each MU of the Region (screenshot below). In the example below for MU - CO MT UT WY I would like to see that 133,729 is 35% of…
-
Convert Date Format
I need to convert a date-formatted line item into the YY-MM format. Could anyone suggest a more efficient method or confirm if this solution is optimal?
-
Best practices to clean up models (especially Actions)
Hi everyone, Trying to get some ideas and best practices from this great community on how to clean up unused fields in Actions. I recently deleted some line items that I was no longer using. There was nothing in the "Reference by" column so it made sense. But they were linked to some Actions to Spoke models and I ended up…
-
CloudWorks Enhancements
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Can we add few more functionalities to CloudWorks like ability to Rearrange the columns, ability to reorder Integrations…
-
June 2024 platform releases
Learn about new Anaplan features and enhancements introduced in June 2024: Audit New Audit Events for Comments: You can track and retrieve audit events for comments that have been added, deleted, and exported. You can read about this in Tracked comments events. Modeling Anaplan Modeling Showcase: Model builders can…
-
Produce random numbers
Hi, I was wondering if there is anyway to have random number generator? Thanks
-
RANDOM() function
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y ) generates an integer >= x and <= y It may be worth considering an extension to these functions such as: RANDOM( x , y , z)…
-
8.6.4 Activity: REV03 Margin Calculation Error
I am working on activity 8.6.4 Activity: Add Formulas to Margin Calculation Module I have some different numbers to what are there in the screenshot shared in the lesson after Check Your Work. Can someone guide me on what I am doing wrong I am attaching my numbers screenshot of what I get for output and the blueprint view.
-
How to add unique Serial number to a text string/text key with more than 60 characters
Hi All, I have a transaction level file coming from SAP with Actual records containing more than 50 columns in a module. As per business requirement I have to create a text key line item in that module with more than 30 columns which makes key larger than 60 characters so unable to import it as code in any list weather…
-
Scrolling issue?
Hi all, Does any one have scrolling issue? Let me explain, when I'm trying to scroll to the end othe module with mouse it doesn't show the last 2-3 line items of the module making users belive it iether missing or having some sort of issues. However, when you reach end of the module and press arrow keys down the last line…
-
Actions Used in Pages
Currently we can find , In which Dashboard the Process and actions were published by referring "Used in Dashboards" column in Actions tab. Similar to that, we shall have "Used in Pages" column so that we can find in which Page(s), the given process or action was published.
-
Embed python into looker
Is there a natural way to wrap Python code to display in Looker? The ideal dataflow for my problem is SQL DB->python-> looker, or alternatively, looker->python-> looker. I am hoping to embed a.py into lookML so that I can automate python analysis, ready to display in looker.
-
REP02 Size Margin Report
Hi, I am trying to put the formula in the REP02 Size Margin Report module which is part of 8.8.4 Activity: Add Formulas to Size Margin Report Module. However, while entering the formula I am getting an error. Could someone help me with the same?
-
2.3.10 Activity: Create Demand Forecast
Hi, I am stuck with creating formula for Baseline forecast, I have used formula "IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' But it only seem to work for FY20, I dont see data for FY21. Can somebody…
-
Get training environment access
I am new to Anaplan and wants to learn Anaplan. How can I get one developer/community/training environment so I can do hands on?
-
2.3.13.2 Create a User Experience Page
Hello There, How i can include Time (FY, HY and Month), Account, and Product Family context selectors in My Pages.Shown in attached image.
-
REQUEST: allow for left/right/center formatting on a KPI in Management Reporting
top/middle/bottom, as well
-
[Start Here] PlanIQ overview and resources
* First things first * What is PlanIQ? * Who is it for? * Use case examples * Now, let's go under the hood * To get started * Once you get more comfortable * Deep dive on algorithms * Support You are interested in starting time series forecasting with PlanIQ on Anaplan, but you don’t know where to start? You have come to…
-
formula to get total salary by role and region
Hello, what is the correct formula to get the total salary by role and region? in the source module EMP02, the timecard is "month" and in the target module REP04, it is "year". Aside from the timecard difference, my formula is not correct. any advice?
-
UX Page Search while on a page
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Though one is able to search for a UX page within the App contents, when one is on a page in the UX the drop-down does not have a…
-
How to Prorate Weeks Across Months in Anaplan?
I need to create a monthly filter for a grid that uses TIMESUM in Anaplan. I'm struggling because some weeks span across two months. For example: January (Expected): Start week: Jan 1 (Sunday) End week: Feb 3 (Sunday) Current Value: Start week: Jan 1 (Sunday) End week: Jan 21 (Sunday) How can I prorate the weeks in Anaplan?
-
Selecting the Time to import data from other model - edit prompt
Hi, I have an action to import data from one model to another. When press to start this action I have a prompt page to select the Time, it means I need to choose the year of the budget that I want to import. The year that I need to import does not appear in the Time dropdown list of the action prompt. I checked the modules…
-
INV01 Inventory ordering Module
For some reason i couldn't able to pull the data for beginning inventory line item . My logic and formula for the line item "Beginning Inventory" is right but still i can't pull the data for week 1 FY 20 . refer my ss for work
-
Pushing data from SQL to Data Hub via ADF
Hi all, I am currently creating an environment in ADF to push data from SQL to an Anaplan module which in our current toolset (Informatica) works perfectly via the Anaplan API connector but not so much via ADF having had to do the work manually given there is no connector. Has anyone here done this and if so, do you have…