-
VBA code to execute Excel Add-in toolbar commands
Hi, I am a new Anaplan user and am looking at using the Excel Add-in 3.0 to retrieve data into my excel-based reports. My preference is to automate report formatting and retrieves from Anaplan using VBA. Does anyone know if there are published Anaplan VBA commands like exist for Essbase? Thanks!
-
When missing code / unique identifier in transactual data (general ledger) for list dimension
Hi, What is the best way of treating a general ledger, in other words a big data transaction file, that is required to be in the data hub and is missing a unique identifier for each row, i.e. something to be used as a code for the list that will act as the dimension for the DATA module? I could create my own code in the…
-
Urgent help requested
Hi Friends, If my file is no longer available in the server. Then after importing the file and manually running the action. Will it read the file from the server instantly or in the job run time.
-
Anaplan Mulesoft Connector Refresh Token Issue
Hi Team, We are using Anaplan Mulesoft latest Connector for our client and With certificate authentication or basic authentication, Anaplan connector is failing while getting Refresh token after every 30 min. This behavior is happening randomly. So when 30 min completed and we send a request it is failing because of…
-
Import file to module
HI team, I am trying to import csv file to a module, it is worked and record updated in respective module. But when the same action trying to update using new set of records in source csv file via manage import data source "file not exist error " getting. i have delete the action and import again it is working in dev…
-
Level 1 Model Building #E2 Employees import
Hello, I can't get the Employee list import to work. I've tried all thinkable combinations of settings when importing the employee list to the #E2 Employees numbered list, se enclosed import page and error report. Can someone help me out? /John, Anaplan beginner.
-
Anaplan Connect: SQL Server JDBC Connection (No suitable driver found...)
For the love of free internet points and karma, I am sharing my struggles with Anaplan Connect setting up a JDBC connection with SQL Server. Purpose: The below has been documented to assist with setting up a JDBC connection to a SQL Server database, the version of JDBC driver used will be dependant on the database version…
-
Lesson 8.5.3 Volumes Data Import Rev02 New
Hi - I am having trouble importing for module 8.5.3. I have uploaded data and chosen the format as shown in other members questions for this module. Steps I followed: 1. Updated CSV file update to show first header is row 2 and data in row 3. 2. Chose correct parameters and chosen "Fixed Line Item" for Rev02 3. Went to the…
-
Loading Transactional Data into Data Hub
Hi 1. Why do we create a concatenated list to load transactional load into data hub? Instead we can create individual lists as dimensions and load data. 2. Why do we create hierarchy lists as flat lists in Data Hub? Thanks Ibrahim
-
Mapplet In Informatica
Introduction A mapplet is a reusable data object representing a set of transformations and its logics to transform data among the tablets. For example, Let's assume there are n number of tables. Our requirement is to select the dimension keys associated to each table. We now create a mapplet with a series of Lookup…
-
Date format during CSV import
Hi All, I am trying to import the below CSV file to module, but unable to get the correct time mapping detail, any help will be appreciated . CSV File :- Mapping Column view :- Time Dimension mapping view :- The problem is I am not getting the month neither under "Pattern and Separators" nor Fixed Position patterns. I…
-
BI Connector - importing all dimensiosn
We are working on setting up a BI connection to Anaplan. I have saved a view for export and filtered on only select locations, months, etc. However, when we import this into BI it seems to override my filters and brings in ALL locations, ALL months, etc. Is anyone else having this issue or know how to ensure only those…
-
Import of Saved View
Hi All, I have created the module SYS12 SKU Data and Saved view as "Build SKU" and "Import SKU Details". but while importing the Build SKU saved view in new list P3 SKU I am not able to find the saved view for selection , below is the screenshot for the same. Let me know if in case I am missing any thing ?
-
level2 sprint2 : import DATA03 into historic volume
Hi in the attached screenshot my import is getting completed but it's getting ignored. please guide for the same
-
level2 sprint 2 - Run Process 9 Import Data from the Hub.
Hi all i know we need to change the timescale for DATA03 can anyone guide into how to do this please.
-
Need anaplanners
Hi, I have a couple of open position for Anaplanners with finance background. If any of you are interesting please email me @zulychg@gmail.com (location can be in LA, Portland, Las Vegas and Vancouver) Thanks Zuly
-
DAT02 PY Revenue to CY module Level 3 Sprint1
Hi Team, Have followed steps in training module but not getting exact value which is there in screenshot. Stuck in between .. pls suggest or provide hint where I'm doing wrong. Attaching screenshots Getting All products values from DAT01 PY Revenue in all individual products of DAT02 PY Revenue to CY. Please suggest
-
Lookup Mapping
Hi All, i am facing the issue in referring the data using the lookup function, I have described the issue in the attachment, if any body can help me with this it would be great. Thanks Vivek
-
Importing from a module into Users
I am trying to import from a module into users. There is one field in the module for a particular user that we are trying to bring in multiple values in the list selected. We are using the "text" format to enter the two different values in that list because we can't select multiple values in a list when it is in the "list"…
-
How Can I Automatically Identify and Delete Childless Hierarchy Items?
Hello, I have a constantly shifting hierarchy in place which consists of 8 levels, level 1 (top) through level 8 (bottom). Within this hierarchy it's necessary to delete members of L7 when they have no L8 members which roll up to them. This scenario plays out regularly as L8 members are often realigned to roll up under…
-
Size of module and models using APIs
Hi All, I need a way to automate capturing the cell size of the modules and overall size of my models. Right now, for modules, I have to capture it one by one in the model itself, but that is not feasible as an administrator considering we have several models and thousands of modules. Is there a way, using APIs or…
-
Docusign not reading Anaplan fields
Hi , I am trying to integrate anaplan with Docusign for my client . Letter is sent but without data in tags . I am trying with only one tag ,doing mapping correctly . When I tried the same in my own company's workspace ,it worked well that to with free trial docusign account but same set up not working in clients workspace…
-
Roster management over Time and Version
Hello, Our implementation includes personnel expense budgeting at the individual level, and to create the roster of employees we use a list. We have a need to compare budgets year over year, ie FY19 vs FY20, and to do this we need to have different members in the list for different years, as well as a current roster. One…
-
export action
Hi, We faced an issue with export job. Captured some error in file like " Error parsing key for this row; no values: 1 ". Could you please help me what this error meaning? and why this came? "Error parsing key for this row; no values: 1 " Thankyou
-
Anaplan clients import options - cost?
Hi, I'm wondering about the 3 more advanced import options that Anaplan have: Anaplan Connect, ETL Connectors and Rest API. I take it that Anaplan Connect comes along with any Anaplan license so would be no extra cost for an existing client? And what about ETL Connectors and the Rest API - disregarding what the client has…
-
All actions / imports / exports within a Process
Hi All, I am trying to build a data lineage from our source to Data hub model and the spoke models. In order to do so, I need the metadata information from i. the Processes , i.e. all the actions/imports/Exports that it runs ii. The models and modules that individual import processes are pointing to iii. The file names…
-
Data Import for DATA01 LEVEL 1
Here are my screenshots. I followed the instructions but my result looks like this, see first screenshot. What am I doing wrong? Please help outputreport says no failure version has forecastThe set up
-
How to extract user login details
Hi All, Can you please me , how to extract the user login details from Anaplan
-
Mass upload into Deployed Model
I'm in need to change the user-editable values en masse in a module in a model that's in Deployed mode. The module is dimensionalized by a production list, and the two lines in question are simply user-input quantities. I've created the import action in Dev and rolled that into Production so I can run the same action, and…
-
copy data from Budget to Forecast
Hello togehter, is there a function to copy whole Budget data to Forecast Scenario (including Global inputs and staff set up)? Thanks for your answer, Corinna