-
Time Range and Line item Period Allocation
HI All, I have a question since my mind has gone blank, I hope someone can help. In my current model, i have imported data for a series of journeys which start on a weekly basis for each transport number, within the journey there are a series of stops for loading and then discharging stock. Pages: Time Range Rows: Journey…
-
MB Level 1 Lesson 11.3.4 Getting the Wrong Output
I am having an issue where only 1 cell does not match how my model is supposed to look like. It seems like "Utilities" (and subsequent line items that use utilities as part of its formula) is the only line item that is generating incorrect data. The first picture is of MY module, the second picture is what the module is…
-
Anaplan Connector for PowerBI
Hi, I have a query on Anaplan Connector for PowerBI. We are able to use the Anaplan Connector for PowerBI with Workspace Admin user logins. But when we try using this with a normal user login, connector does not fetch any models from the workspace. Did anyone face this issue earlier? Thanks in advance for suggestions 🙂…
-
Excel Add-In - Labels
Hi, When we export data from Anaplan we have the ability to add 'Labels' to the export. These cannot be added to the view as it would be too complex, but are pulled down for the Export, which is really useful. If we connect using the Excel Add-In can this be replicated. We connect to the view but i cannot see the option to…
-
Import data in to the module
When I import data in to a module, is it inserted into the underlying lists that are used as dimensions while creating the module? Do the lists and modules have own storage? Any documentation would be very helpful.
-
Help with Lesson 8.5.3- Import Data into Volume Inputs Module
Please help. I've attached screenshots and don't know why I keep getting the time error message. Thanks.
-
7.2.3 Activity: Import Data into Employee Details Module
Hi everyone, I'm a newbie to Anaplan. I have checked and tried every suggestion in this forum regarding this problem. Kindly help me out. Attached are the screenshots of everything I have done. Any suggestion would be appreciated. Currently stuck. Thanks
-
Level 1 Model Buidler - Lesson 4 mapping source to property in list
Hi all, I'm a newbie here and I hope this isn't a stupid question (I certainly feel stupid because I can't figure this out). But can someone explain mapping when we are importing lists into Anaplan? Specifically, for each activity in Lesson 4.6, I got stuck on the mapping for each source in the list. Basically, I'm getting…
-
IMPORTING OF SKU FILE
i was unable to import the file correctly
-
Production Adjustments in ICM model - looking for ideas
Context: * We have an ICM (Incentive Compensation Management) model with a DAT03 module that is an upload (from our data hub > SQL query) of all the monthly transactions we need to pay IC on. It includes all the production amounts, sales reps, product type and many other dimensions. * Our module also applies production…
-
Why do I still see source items from previous versions of upload files in the import definition?
Hi Anaplan community, I don't understand why I still see source items from previous versions of upload files listed in the import definition tab of an import action. I used file A with periods call AP01, AP02,... and used that to upload into Anaplan and save that upload as an action. Later, I changed the file and renamed…
-
Anaplan Connect - Transactional APis
Hi Team, I'm trying to add new items to model list without using the IMPORT function. Facing this error - Can someone highlight where I have gone wrong with the scripts Thanks AB
-
Calculation Error for Formula
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 2 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Level 2, 1.3.10.1 Import Data into G1 Region List
Hi all, I'm stuck with importing data from a saved view to the G1 region list and I don't understand where the error is coming from. Region Flat: Saved View (SYS05 Region Details, Build Regions) Regions: Import dialogue: Error message: So something's not working with the code/line item, but I don't get what it might be.…
-
Cloudworks - Data too Large
Hi all - has anyone ever ran into the situation where the dataset being brought in by Cloud Works is too big? Is there an error message that shows this? I'm suspecting this is the case for me. This is specifically for BQ -> Anaplan. I ran three processes, and the third one triggered was the first one done. The others have…
-
JDBC coonector > Invalid argument in JDBC call: parameter index out of range: 1
Hi Model Builders, I need your advise on this below error I tried to follow the steps mentioned in this document to build a JDBC connector using Anaplan Connect - https://anaplanenablement.s3.amazonaws.com/Academy/Platform/SA/SA_01/L08/WEB/index.html#/lessons/L_kD_rXFRzmz2kf0p4KDbsKlt3RLWk0z It seems that the JDBC…
-
Bringing in Roles - Formula Help
Hi - I am trying to bring in Role. I added them as a line item in my module: Here are all the modules: And here are my lists: There is a dropdown for me to manually put in the roles, but I just don't know what to do for the formula. Can anyone please help me with how to write a formula to bring in Role?
-
Column Headers causing Invalid date error
Hello, I am currently working on a project that requiers the end-user to export a module, change the data, then import the exported file in the same module. However, since i'm using numbered lists, i need both the code and display name in the exported file ( code to import the data back, display name for the user). But by…
-
Anaplan Connect Integration
Hi Experts, Anaplan Connect scripts to connect to the internet via web proxy server? Could you please share your thoughts on the above question raised from one of our customer? Thank you in advance. Best regards, Anil
-
Import & Upload functions using BULK APIs.
Hi Team, I have couple of queries regarding Import & Upload functions using BULK APIs. For Import function to work - file should already exists in Anaplan. However, if I want to import fresh files then I need to upload the files first as per my understanding. Now in order to upload files, Anaplan says that the file must…