-
Produce random numbers
Hi, I was wondering if there is anyway to have random number generator? Thanks
-
Random number generator
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
-
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)…
-
Anaplan Certification Path
In today’s fast-paced digital landscape, expertise isn’t just an asset—it’s a necessity. Our certification path is designed to empower participants with the skills and knowledge needed to excel in using Anaplan. Whether you're looking to deepen your understanding, improve efficiency, or unlock advanced features, this…
-
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…
-
Help to input slabs
i am creating a model for tax calculation and it includes 2 regimes with different slab structure,i am calculating tax for 10 employees on their gross salary ,for regime i have a list includes old,new regime names and i have included a line item for selecting regimes of data type list.But i am unable to get an idea how to…
-
Rename of certification
is it possible? if i wanna rename due to an typo error
-
Integration tool to show Tree Map Graphs in UX or Dashboard
As we know, Anaplan don't have graph like Tree Map Graph to show Distribution decision like picture below Is there any option or integration to represent data from anaplan to Tree Map Graph like picture above?
-
Level 2 Sprint 3 3.3.7.2
I am struggling with adding DCA. Below are the instructions: Their example + formula hint: Blueprint from my AD02 module: And Blueprint from my Inventory module where I have enabled the access drivers: My problem is that when I add the access drivers, I'm not able to control anything in the grid view. For example, I'm not…
-
OEG Best Practice: Pre-allocation in lists (and impacts to model performance)
What is pre-allocation in lists? Pre-allocation in lists is a mechanism in Anaplan that adds a buffer to list lengths. It is not added by default for lists; it becomes enabled when a role is set on a list. Please follow 1.03-01 though. Only add roles when needed. When it is enabled, a 2 percent buffer is added to the list,…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello All, I am currently working on an exercise to import data into the DAT03 Historic Volumes module in my Supply Chain model L2: sprint 2: (2.3.9.1) Can someone please help me fix this import. I cant understand where I am going wrong and why it won't import. The time ranges have been selected as FY19-FY20 for the line…
-
Incorrect decimal placement importing from csv file
Hi, I've noticed strange behaviour when importing into a number formatted cell in Anaplan from a csv file. My csv file is directly exported from a Workday report, and the csv file contains 2 decimal places for some entries, but some entries are rounded to 0.dp where the two d.ps are ".00". Anaplan is incorrectly putting…
-
【2024年6月】プラットフォームアップデート
プランニング&モデリング ・Anaplan Modeling Showcase セキュリティ ・Audit(監査)コメントの新しい監査イベント
-
How to add Button Optimizer in Dashboard
Hi, I want add Button Optimizer (Red Rectangle) like picture below in my dashboard please assist me how to do it. I got this picture on anaplan academy Course Optimizer, but on that course not explain how to add button optimizer into UX Web course : https://learning.anaplan.com/mod/scorm/view.php?id=17307