-
generating sequential numbers
Hi everyone! I have a numbered list that has code as a property ( when importing i use combination of properties to create this list items ) . and there are items that has same codes and names. but same items have different BCs. for showing that which BCs belong to which item, we create a module using an index list and…
-
Security: one user only allowed to update data
Hello, I need to customize a solution for one user only. In particular, I want this one user to be the only one who's able to check the "Update VAT Number?" boolean and type in the "New VAT number" cell. However, the rest of the module needs to stay editable for all the user. The UX will then display all the columns,…
-
Sprint 3 6.4 Check Your Build
I am trying to get the number for this section however i am having a slight missmatch It seems that in some of the representative to product mapping i am not exactly matching it 100% and causing this difference. However, I couldn't imagine the import part is wrong. Any one is having this issue as well? Thanks.
-
log in
how i can login anaplan workspace
-
ワークスペース間のモデルコピーについて
皆さん、こんにちは！ Anaplanではワークスペース間における、モデルコピーが可能です。 手順を本資料に整理いたしましたので、 皆さんの日々のご利用にお役立ていただけますと幸いです！
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
AD02 Inventory Ordering Overrides i have created this module and along with line item , Submit Purchase Order - Write? Override Amount – Write? Override Shipping – Write? have set data type as Boolean below is my ss of my work blue print of it When creating the Override Shipping – Write? and Override Amount line – Write?…
-
Any tips for reviewing the Model Map?
Hi I was wondering if anyone could share with me any tips that they use when exploring a new model using the model map please? Whilst I understand the basic functionality of using the model map, I am finding it very difficult to get a good understanding of the model and the relevant modules involved, because the model is…
-
How to identify UTF-8 one-byte spaces (C2A0)
Hi! I would like to use the Trim function to obtain up to 60 characters from the beginning. However, if the 60th character is a one-byte space (C2A0) in UTF-8, it is not recognized by the Trim function, and as a result, a one-byte space is displayed in the 60th character. Is there any way to avoid this? If anyone knows,…
-
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.