-
export Anaplan data decimals precision to PowerBI
Hi Anaplan Community, I am trying to export data from Anaplan into Power BI using the Anaplan Connector. I manage to get my values into PBI, however, I miss the decimals precision which I see in Anaplan. Example: in Anaplan my number format is set to show 3 decimal places, so 594.450 (US notation), five hundred ninety four…
-
Consolidating recursive modules
Hi I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance List: Employee ssL0Employee ssL1Employee ssL2Employee ssL3Employee Employee 1 Y Employee 2 Y Employee 3 Y Employee 4 Y Employee 5 Y Employee 6 Y Employee 7 Y Employee 8 Y…
-
Importing incorrect data into "Actual" version
I've built an import and mapping logic to bring my actual data into my Anaplan model and everything is correct on the line item "Actual Expenses" as shown below. However, when I run an import action to move this data from the "Actual Expenses" line item (where it is calculated) to the Actual version of the "Plan Expenses"…
-
Regarding anaplan workspace access
I have purchased a Anaplan work space but still its approval is pending can anyone follow up this issue please ..
-
Counting a Project name
I am counting the project item(List: Project name) based and generating a unique number by adding +1 to count . everything is working fine until a situation comes where i have to delete some existing projects. When i delete the project → my count reduces and the way i am creating a unique number which is by +1 to my count…
-
Copy paste formula from excel into Anaplan blueprint
Hi Anaplan community, I wanted to make a quick fix to existing formula in my Anaplan blueprint view, so I exported my blueprint view to Excel, used the find&replace functionality in excel to update all my formula at once, and then I wanted to paste back my formula in Anaplan blueprint view, but it gives me this error…
-
API Authentication error bc of need to reset password
Hello, The IT team of a client has built a integration with the data base to Anaplan using the API. They have a problem of Authentication when Anaplan ask to reset the password, giving a 401 unauthorized, so they have to go to the Anaplan page and reset the password and make the changes on the integration. Is there any…
-
Anaplan New Workflow decision task
Hello all I have a question regarding the New Anaplan workflow . In the online course provided by Anaplan it says when a Decision Task is created and assigned for example to a user , when workflow starts that approver will see 3 option : Approve - Reject and Send back . i decided to create a Decision task but when it is…
-
Cell history not being captured correctly
Hi All, I have come across a weird scenario where cell history of a Boolean formatted line item is not getting captured properly. For e.g. : In the attached snippet of a cell history of a module below are updates 1 - Data got updated after a bulk import to TRUE (History ID - 3994882) 2 - In the next update (ID -3996409 )…
-
Import Issues
Hi All, I'm currently facing two issues related to import. I have one module (split in three tables in UX) in which the user imports data. Here's the module: The import action works perfectly well for me but not for them. Apparently, the system is considering the comas as decimal separator while they consider it as…
-
How to lookup currency from module based on selected filter
how can i lookup the currency rate based on filter that i selected in REP01 Long Term Loan Payable. General List: LO05 Currency Module: SYS03 Foreign Exchange Module: REP01 Long Term Loan Payable
-
Adding a list (as a page) into a pre-existing module
Hi. In one of our modules, are current pivot set up is: Pages: Version Rows: Line Items However, we need to add a list '# Customer' into Pages, to get the below pivot view: Pages: Version, #Customer Rows: Line Items Is this possible without creating an orphan/ duplicate module? TIA. Josh
-
Order list action not working.
For example, Module A has SKU list and line item POS which has certain data in it. Need to reorder the SKU list with respect to POS line item data in descending order (Highest to lowest). Used Order list action to sort the SKU list. The hierarchy of list goes by Organization > Model > SKU. Order list action. Module A…
-
Data Loss with Inroducing Time Range
So in the current setup, a module is dimensioned by Model- calendar time dimension and the horzion is from 2021 to 2026, the granularity being weeks. This setup is used in prod since go live for 2 years now. We realised the span of time for data in that particular module can be reduced. Idea now is to introduce a time…
-
Numbered Lists (With a parent)
Hi, I have created a numbered list (# Customer Number) successfully (with no parent, code as customer code, and name as customer code name). I'm trying to now create a numbered list as a child of customer number called '# Customer Name'. I bought in the below on the import: Parent Name Code Parent > the same code as noted…
-
Can ANY be used where the source contains TIME dimension?
Hi All, I am try to query the presence of a list item in a source mapping where the source contains TIME dimension. Source contains one list combined with TIME where a mapping can differ across a year. I want to query this mapping to determine if a target list is in use at any point during that time period. I use this…
-
Can we add numbers of list item in a numbered list by taking input from user?
For Example: If user entered 10 then 10 list item should get created in the particular list.
-
Create a number sequent in a period column.
Hi everyone. what is the formula on adding a number sequent in one column like 1,2,3,4,5 etc. i tried RANKCUMULATE but it returns all 1. by the way this result was already filtered. thank you.
-
General Question on Locking the Actuals
Hi All, How do you manage the master data changes? As the changes in anaplan are retrospective. Lets say there is a change in the master data and it will impact the actual numbers reported. Is there any native way to lock the numbers? Please don't recommend the snapshotting process as it will not be sustainable for my…
-
How does one safeguard against losing data with changing current fiscal years
I would like to use the out of the box TIME dimension/logic. However, I do have concerns about losing data if a fellow model builder inadvertenly changes the current fiscal year. How have others handled this situation? We have considered building exports to backup these modules every night and store the data outside of…