-
Compare value on current logged in user email
I have a module with historicals captured by different users via another Model. My module has one line Item which has the email ID(Customer Email) of that particular user, however this module is not dimensioned by Users. For this module i only have one dimension which is basically the Index for the records, rest other data…
-
How to retrieve Current user
Hi everyone. i read some of the post here regarding retrieving current user but unfortunately cant find the answer. Since retrieving current user without user list dimension is not allowed, how can i transfer the current user from module with user list dimension to a module without user list dimension. thank you.
-
Hot fix
Hi All, I couldn't get clear outlook of implementing hot fix in prod environment, when we have development in progress in dev mode. We don't need the development to go to prod only the issue needs to be fixed and later we must progress with the dev model with out loosing the development. I am unclear of how many revision…
-
Which of the conditions require the use of a numbered list
This seems to be a tricked question, I can not figured how this is not correct [Image Removed by Moderator] This is the reference from Planual: [Image removed by Moderator]
-
why I importad data from csv show 100x bigger than the original file?
hello I tried to finish the L1 training and in the 8.5.2 steps when I import the price book data in the anaplan model I saw values that 100x bigger than the original values in the csv file. like example csv file show: 0,84 in my model I see 84.0. not sure what cause this problem. is it coming from my local xls settings? if…
-
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…
-
source to target data is getting loaded partially via IICS
Hello, i'm fairly new to Anaplan but come from BI products world. I have a situation, an Import action is created in Anaplan dev. This action picks up the .csv file from source location (This has been working perfectly fine in our environment for last 4 years) and loads it in to one of the Modules. This process has been…
-
Links in page tasks in a workflow are not working
Hi all, I have a problem: in a workflow I use a page that contains links. Before when starting a task that takes you to that page you could navigate from those links. Now, the page is "static" and the links do not work when you are in the task page. Is something new? Can it be changed?
-
Management Reporting - notes commentary boxes
Raising for @EmmaPF In management reporting it would be really useful for end users to have the ability to make notes for presentation - similar to the notes function at the bottom of PPT slides that allows users to add a commentary that doesn't appear in the presentation/pdf version.
-
Timesum with Date
Hi I want to use Timesum function. In this page, we can use Timesum function with end date to start date. https://community.anaplan.com/t5/Idea-Exchange/Dates-in-Timesum/idi-p/89565 But in Anapedia page, it is not suggested to use Date. https://help.anaplan.com/13d8b551-4e13-413b-a39f-f25579d21e38-TIMESUM Is there some…
-
Level 3 Sprint 1 9.3 small differences
I have reviewed each step and I dont really know how to get the number of the example… here i have the example given: and here my results after each formula… I have used the next formulas: Percentage %: Initial Account Sales Target / Initial Account Sales Target[LOOKUP: 'SYS99 Lookups'.Target Year] Initial Account Sales…
-
ALM explained—Part 3: avoiding data loss
Introduction In part two of the new ALM Explained series, we discussed the best practices for testing and validating changes prior to deploying them to production models. However, we also know that testing protocols are not always followed, especially if the change is an emergency patch, and sometimes, the synchronization…
-
File format vs Anaplan
Hi, I want to ask for help with why while importing, it keeps on reading my code like this xxxxx+12? Attached photos for reference: File: (.csv format) Anaplan: Thanks,
-
Performance Issue / Page Crashes with Hierarchy Card
We are working on running a Page context using a 9 Level Hierarchy and the idea is to expand/collapse click through the levels while the dependent Grids on 10th Level get updated [ Hierarchy Filter Context Synced] Unfortunately - the card navigation response is a little sluggish and takes 5-6 mins to get the context…
-
Level 2 Sprint 3 3.5.5 Activity: Create Distribution Center Summary UX Page
Hi…I've been trying to create the "Product SKU by Distribution Center" grid in 3.5.5 activityI(L2 Sprint 3). I don't understand why it's showing all the values unlike the expected results. I have applied show/hide for the levels required. Please help. Thanks in advance!! Expected o/p
-
Activity: Prepare Data Exports: Create Demand Export Module and Create a Saved View
Hello, I am doing this activity and below is the request for the activity. and this is how it should look like. Now, below the thing what I have created. but I am not getting the correct output as shown in the Anaplan Training document. So, can anyone help me to understand what I am doing wrong here? Thanks !!
-
Five principles of solution architecture
Author: Arun Thakar is a Certified Master Anaplanner and Vice President in the banking industry. Whether you are just starting out as a solution architect, or you’ve worked on several models you may benefit from a refresher on some of solution architecture’s key principles. It’s important to remember that these are not…
-
Configurable default selection for context selector
I recently had a question from a client who asked if it was possible to set a default list member (or the top level of a list, eg. all products) as the default for the context selector at the top of a page. They wanted to be able to select a particular layer, list member or top level of a list and always have it revert…
-
9.2.6 Activity: Add Formulas to Margin Calculation Module
Can you please help? I coppied formula i think no issue about formula. Expected: Mine
-
CSV Handling - Blank first row
When a CSV is imported if the file does not have headers and the data in last column (or multiple last columns) of the first row is blank the last column is ignored and not available as part of the import. How often is this impacting your users? This impacts multiple clients, when it is an issue then it impacts frequently.…
-
How to do use aggregate value?
Hey everyone, i am stuck at the part where i have to devise a formula for Subtract 1 line item,for that i need the extra value which is 5% in this case ,can be seen in Override-Allocation line item and i need to divide it in those members which do not overriden the values like for LM1,LM2,LM3,LM4 and LM5 which looks like…
-
Is there a way to hide the models from end user on Home page?
Hello, I would like to hide the models from certain end users that will be using dashboards only. Today, when they get to the workspace homepage, they can see all the models and it confuses users. I would like them to only see the App page where all the dashboards are. I know they can use that Show/Hide function but it is…
-
October 2024 Community Member Spotlight: Cianna Bramley
This month, we are excited to feature @cianna.bramley as our Community Member Spotlight! Cianna is a Model Optimization Manager, Community Boss Employee, and has been with Anaplan for over seven years. Cianna, who leads the Model Optimization Team, worked with her team this year to launch an eight-part series in Community…
-
Management Reporting - Undo/Redo buttons
Raising for @EmmaPF In management reporting can we get an undo button? Allows you to undo accidents made during editing
-
Lookup parent values in a non-composite (ragged) hierarchy
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: enable the LOOKUP: of calculated values in a non-composite hierarchy How often is this impacting your users? frequently (every…
-
3.6.1 Activity: Create Roles & Test as End Users
Totally lost as to what the ask and action to take here is. Selective access, enabling the viewing and/or writing of information for lists is determined at the user level, so what has that got to do with Roles?
-
Is there an easy way to clear prior inputs with a roll forward?
When we roll forward our FP&A model to a new year at the start of our budget cycle all the prior year inputs are kept. We have to manually go into each section of the model and clear all the inputs/uncheck booleans etc. This is very time consuming. Does anyone else have the same issue and is there an easy way for us to…
-
Level 3 technical examination
Hi everyone, I was undergoing my level 3 examinations of which I have completed my model building Knowledge exam successfully. However, on the technical examination, I am not getting any answer correct, despite some of the questions being straight forward and can even be picked up from the excel dump provided. (Not that…
-
Polaris - TEXTLIST alternative?
Hi Community. TEXTLIST does not work in Polaris. Planual rule is to avoid using it, however, there are times when the functionality is needed. Has anyone got an alternative or workaround to achieve similar functionality
-
Ability to enter hyperlinks in the Anaplan new UX field card
It would be a great addition to the new UX if you could enter text set up as a hyperlink into the field card. Currently, you need to set the card as a grid to do it, which is not user friendly at all.