-
Remove a selective access by import
@Tomishand I recently needed to have the ability to remove selective access for certain users from a selection module and a model-to-users import. The documentation on Anapedia is not very clear on the subject so I thought I’d detail the steps here. We import the code of the items to add in the Read / Write though…
-
Excel Add-in No Access Error
Hi, The following problem occurred : Excel Add-in does not allow me to look at the Saved Views of some modules, giving the error No Access. It is important to note, that the modules themselves are large, but there is much less data in Saved Views. Is there any solution to this problem, provided that you do not want to…
-
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2 While importing the location.csv into the SYS07 Location Details module, the region part is not uploaded properly. why? because: It is the reason that region flat has 3 line items: AMER, EMEA, APAC. However the csv DATA file attributes the…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
i am trying to run process 9 but i got this error can somebody please! help me
-
How to remove a dimension from a pivot?
Hi, Does anybody know how to remove a dimension from a Pivot? I need to remove "time" from the "Pages" (See below). Thanks Juan
-
Lock overwrite of snapshot
Hello, I am currently working on a scenario planning model, where I have two custom versions lists. My first list is a "modeling scenario" list, which is user editable. And once the users decide to lock their assumptions, they create a new "snapshot scenario" and run a process to copy over the data from the modeling…
-
Exporting data from Anaplan to Qlik sense.
Hello team! I am trying to export data from Anaplan to Qlik Sense and I am following this documentation. However, I could not download/install the Rest connector that mentioned in the documentation. It looks that it does not work. Is there any other ways to Export the data from Anaplan to Qlik sense. Thank you!
-
8.5.2 Activity
Hi All, For activity 8.5.2 I am trying to import data into the price book module. However is picking up the Time dimension and it should according to the learning material. See below how looks now This is how it should be Does anybody know what the issue might be? Thanks
-
REST API-Import error
Upon importing into the Anaplan model using Postman, we get an error. The steps followed and the error screenshot(highlighted in red) are attached in the file. Kindly have a look at it. I will be thankful for your solutions.
-
Anaplan and ServiceNow Integration possible ?
Has anyone connected ServiceNow to Anaplan to display the ticket information on dashboard ?
-
Anaplan api get lists issue
Hi guys Is anyone having issues with retrieving lists end point via api ? I am getting below error https://api.anaplan.com/2/0/workspaces/myworkspaceid/models/mymodelid/lists {'Authorization': 'AnaplanAuthToken mytokenvalue', 'Accept': 'application/json'} { "status": { "code": 404, "message": "Not Found" }, "path":…
-
Import Data into Product Details Module
Hi I'm struggling with the 7.2.1 Activity: Import Data into Product Details Module. I have attached the screen shot. Can I please get some help on this. Thanks
-
Anaplan Connect Export script
Hi, I am getting error when I use the following script for exporting @Echo off set AnaplanUser="XXX" set WorkspaceId="XXX" set ModelId="XXX" set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "ABC" -execute -get "D:\ABC.csv" rem *** End of settings - Do not edit below this line ***…
-
Delete list items not present in the data hub
Hello, I'm creating a data hub in Anaplan in order to have the product hierarchy of 4 models located in only one place. The product hierarchy already exists in each of my models. When i created the hub i cleaned up the hierarchy and delete many items. My problem is when i import the data from the data hub module into the…
-
Learning Academy. Lesson 8. Problem with importing data
Dear Anaplaners, I can't import data to REV02 Volumes Inputs in 8.5.3 Activity: Import Data into Volume Inputs Module. The problem is obviously in mapping. I've tried all possible ways.. Nothing. Who can help? Thanks in advance!
-
Number values getting inflated by 10x when importing from file
Hi all, I'm having an issue when loading a data file to a client's Data Hub. The target module has several line items, some of which are number formatted. When I load the source file one of the numerical columns is getting inflated by 10x once it's populated in the target module. For example, there's a value of 468,408.66…
-
Data Import one model to another with Subset of Time Dimension
Problem Statement - Importing data from one module 1 (time range from 2016+) into another module 2 (time range 2019+) I understand the option of creating a view in module 1 with lesser time range and then use that one as source module. However was wondering if the practitioners have other ideas of importing the data from…
-
How to export data from Anaplan to Qliksense
I built a model in Anaplan Course and I want to export the data directly to another visualization tool such as Qlik. Is there any way to do that? Thank you!
-
Power BI Connector Authentication Options
Does anyone know if there are any plans to allow end-users to authenticate with the Power BI connector using SSO or through a Certificate? Currently, the end-users are facing an issue as they are running an automated scheduled pull from Anaplan to Power BI, but with the need to reset the password every few months, their…
-
How to use FIRSTNONBLANK/LASTNONBLANK in a custom calendar
Hello everyone. I have created a custom calendar. I have mapped Week(List) and Year(List) corresponding to Time(Days). I would like to create a module that sets the start and end dates to the Week(List) and Year(List). I thought I could use the FIRSTNONBLANK and LASTNONBLANK function to get those dates, but it does not…
-
Time
Hi good day1 How can I make this as a row in a module? Because when I use time as a dimension, it aggregates the same date. Thank you.
-
Multiple dimensions but import only allows 2 source to target mapping
Hi, I am trying the training lesson to import a csv file into a module with multiple dimensions but the import window only shows 2 source to target mapping instead of 7 source to target mapping selections. What am I missing here?
-
Anaplan Connect Error Messages
Hi All, We have a number of Anaplan Connect scripts with certificate authentication, let's say 10, as part of a daily job. Somehow, jobs # 1-3 were successful, # 4-6 were failed, and # 7-10 were successful again. I wonder if the those failed ones were due to connection issue during that point in time as prior and…
-
10.2.2
Good evening! When I try to import into 10.2.2, I get the following screen. Not sure why it's coming up like this. Thank you in advance to anyone who can help!! 🙂
-
Model to Model transfer action not working for full access user
Hi, I have created an import action from Model A to Model B and both are in same worksapce. Please see the below details of Model A & B. Model A: It is source model for an import action. I have used saved view for a module which is having User List as a dimension and with few line items. One line item is having their…
-
6.8.3
Hello! My screenshot, below, does not look like the example, which is beside. Thank you to anyone who has guidance!
-
Process Completion info via API Calls
We are using Databricks for Anaplan API and Airflow for job execution. Context : Process 2 (Spoke) is dependent on Process 1 (Hub). This means Process 2 should only start when Process 1 is completed and both should not run parallelly. Issue : Right now the backend only tells you whether the process was successfully…
-
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…
-
Export Filter
Is there any way to use code of line item as a filter to export through multiple tabular view?
-
Export Column Width
Hi Community, I am trying to export a saved view and the export always turns out with columns set to default width. Is there some way that I am overlooking, that can help me export it with the specific column width that I have set up in the saved view?
