-
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…
-
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
-
UX page 2.3.13.2
I need help on two things- Unable to add account selector on the top context selectors. Unable to change the line chart to show baseline and initial demand. Do you see any other issue? Thanks for your time and help. Happy Learning!
-
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 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
Step 1: Level 1 Model Building Step 2: Level 2 Model Building Step 3: The Anaplan Way CERTIFICATION: Anaplan Certified Model Builder Step 4: Level 3 Model Building Prerequisites for Level 3 - Before beginning the Level 3 Model Building training program, it is highly recommended that you have: Successfully completed Level…
-
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…
-
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…