-
Import to numbered List
Hi People, I want to import transactional data into the model from excel csv file. I formed a numbered list, where I am importing this csv file, identifying the unique key by using a combination of properties, but there are other columns that are not forming part of the combination. (basically, those are values/number…
-
History - Anaplan
Hi everyone! The use case we are trying to achieve is that an end user should be able to quickly check history at any given point ; currently only 24hrs is enabled or the model history at the back end ; what we would like to do is get the source data from anaplan and model it with an AI ( kind of a chatbox e.g KOREAI) ;…
-
Level 1 Lesson 12.4.4
I think there is something wrong with the material. This is what I've got. This is what the material says. I applied the filter already for forecast months only. 😉 Why is there a discrepancy?
-
コード、テキストを並べて表示する
下記のようなグリッドを作りたいです。コード対応するテキストを表示したいのです。 どのようなリスト構成？にすればいいでしょうか。いま、”111_choco"みたいなものを作っていて、美しくないのです。
-
Anaplan & Fluence Connection
Does anyone know how the connection between anaplan and fluence works… or can point me in the right direction for documentation?
-
Level 3 - Ask the Stakeholders - Designating Sales Reps to Accounts Process Questions
Level 3 - Ask the Stakeholders Designating Sales Reps to Accounts Process Questions This forum is for asking the stakeholders of the Unicorn Candy Company questions about the Designating Sales Reps to Accounts Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please…
-
Filter on Context Selector Of Report Pages in New UX
We we create a page with multiple slides and each grid in those have same same context selector. Please enable an option to put filter on the context selector.
-
Trying to get .xlsx from Anaplan Connect but comes out as csv
I have an export that I am trying to run through anaplan connect 4.2.1 however it is causing some issue When I run the export direct in anaplan, it comes out directly as an .xlsx file, but in anaplan connect its format is .xlsx but excel won't open it, and if I rename the extension to .csv, it opens correctly. So it seems…
-
CF for Year Totals
Folks, native NUX does not offer a highlight option for Year Totals (that i can find) so i am left to use CF for each line item using a CF Year marker to then colour code the year total data. Trouble is this is way too much work for every line item and of course some data does not aggregate across TIME, leaving the CF…
-
How to remove the New line / Line break Character
Looking for a solution to remove the line break or new line character from the text formatted line item editable by end users. reading the text from the user editable line item to another line item, in the process want to replace new line character if any from the text. Because of New Line character the data while being…
-
Can some one help me determine why my numbers are wrong?
My numbers are above This is what Anaplan shows
-
Include logs for Model Level Changes such as Renaming
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: Someone has changed a model name which has inadvertently broken our integrations as the name is referenced in code. While this was…
-
あいまい検索がしたい
条件分岐式(IF構文)で NameにNullがあればや、Aが付くなら、など 完全一致ではなく、部分一致で条件を分岐させたいのですが、 Anaplanのあいまい検索式はありますか？
-
7.2.3 Activity: Import Data into Employee Details Module
When importing data into the SYS08 Employee Details module, my end results looks like the second photo when the goal is the first. I have imputed the correct mapping, and manually mapped the employee detail line items as well as changed the date format to YYYYMMDD. I'm not sure what the error is, I keep getting the error…
-
Hierarchy Management on NUX
With the New Hierarchy Card for the Dashboard it would be good to use it as a Hiearchy Management Tool. Where an user can make changes to a hierarchy… either with a drop down in the Node to change parent or unattach and reattach. From there if its a Ragged Hiearchy that there is a process that could create a level…
-
Level 1 Lesson 12.4.3
I wonder why I got a slight variance to the results shown. This is what I got. This is what the chapter says.
-
I am kinda stuck at sprint 3 level 2 INV01 formulas, please check formulas and help me with changes
this is expected result this is my result formulas used - Beginning Inventory - IF 'SYS01 Time Settings By Week'.'Not 1st Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory Forecast Demand - 'DEM03 Demand Forecast'.Final Forecast Reorder Flag - OFFSET(Ending Inventory,…
-
Loading file in Deployed Mode with same name in Actions "Import Data Sources"
Hi, For the past few years, I was able to load files manually in the Actions pane's "Import Data Sources" by loading a file with the same name. Usually it fails the 1st load, but works the 2nd load. I try doing this method today and this does not work anymore. I tried 2 browsers and tried removing cookies and no success.…
-
特定versionを指定して比較したい
上期・下期の数値を現在の値と比較したいのですが、現在versionの数値と特定versionの数値の比較は特定versionを指定出来ない為出来ておりません。 どうすれば特定versionを指定できますか？
-
How to get MAX value from line item to another line item in the same module?
Hello, I have a module (image below), how can I create a line item where all items will be max value from 'New Store Num' where 'To many Stores?' is True . For Example in image below it will be 8.
-
Cumulate calculation but skip 1st item
Do you have any ideas to calculate this; what I need? If I make a line item called "for lookup" and use LOOKUP formula, I can do this. However I need to fill in "for lookup" manually. I simplify the case here and "Figure" should be calculated using "What I need", so I cannot use "Figure" since it becomes circulation…
-
How to Resolve “Automatic Sum of Hierarchy Not Possible” Error Without a Top-Level Item?
Hi Anaplan Community, I’m encountering an error in my model: “Automatic sum over Over/Under hierarchy is not possible because the list does not have a built-in top level.” I understand that one solution is to set up a top-level item in the list. However, I prefer not to use a top-level item. I’ve read that using a LOOKUP…
-
'Rich text' enhancement in Anaplan Management Reporting
The 'rich text' feature in Anaplan Management Reporting is really helpful as it enables users to format their comments (bold, italic, alignment etc). However, it would be ideal if we also have the ability to select the font size and the spacing between each bullet points
-
How I Built It: Integrating Hierarchy Cards, Anaplan Connect, and Outlook
Author: Kamal Verma is a Certified Master Anaplanner and Solution Lead at Accordion. Hello Anaplanner Community! I am excited to participate in my second ‘How I Built It’ tutorial. Many clients want to be informed via an email notification when changes occur in their models. This video will present one method to extend the…
-
SUM Function Example
I tried to create a simple SUM function. In a video it explains transaction as Line Item whereas I failed it as Line Item. So I tried using Transaction as a List. It worked out. Can you please let me know, if I am right or wrong? I have shared Screenshots for reference.
-
Filters on the IMPORTS - Source Object and Target Object columns
Trying to find a source or target for an import is a long process as you cannot filter them. Currently we copy and paste all the imports to excel, then filter then go back and search for the import action. Very tedious Just need a filter on the Imports page, so we can select a target list and see all imports into it..…
-
Horizontal scrollbar does not work when freeze columns (1-15) or more.
When freeze columns (1-10), horizontal scrollbar works well. However, when freeze more columns such as (1-15) or (1-20), it does not work as above picture.
-
Rename/Delete/Change Parent/Insert options on grid from additional insight
Currently, these additional features are available only on the main grid within worksheet page. Since we can also set another card from additional insights, to be opened by default, can we enable similar options on this additional grid card as well - to be able to rename a list item, delete the item, change its parent, or…
-
OEG Best Practice: Line item subsets demystified
Line item subsets are one of the most powerful and efficient features in Anaplan, yet one of the least understood. The COLLECT() function is probably the only “black box” function within Anaplan as is it not immediately apparent what it is doing or where the source values are coming from. In the following article, I will…
-
Customizable date display format
It would be great if we could customize the date display format by line item such as with DD MMM or DD MMM YY, to present a view to the users that is easily interpreted, especially if it is a number heavy report. Currently we do it with workarounds using custom lists and mapping to the dates, however, it does add…