-
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…
-
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…
-
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.…
-
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.
-
anaplan api 401 Not Authorized using Postman
Using Postman: I can use Post and get an authorization token, but when I create the Get with Authorization = AnaplanAuthToken <token from Post> Content-type=application/json Basic Authentication and workspace ID and Model Id in URL https://api.anaplan.com/2/0/workspaces/<workspace id>/models/<model id> I get: { "status": {…
-
Importing Values to Booleans via Model to Model
Hello, I hope you are all doing well and good. I would like to ask about a challenge that I'm currently experiencing. Situation is, I need to create an action, just a simple action that will be published to the NUX. This will be an Import action within the same module via a Saved View. Please refer to the encircled line…
-
Does it make sense to have multiple data hub models for different uses?
We currently load multiple data sets into our data hub, then from there to various spoke models. We want to increase the frequency of one of the loads but are concerned the process timing might conflict with another load. Does it make sense to load the data into different data hub models in the same workspace to avoid…
-
Allow User to Enter Comments at Parent Level?
We have a text-formatted line-item where we want users to enter comments at both the child and parent levels. The current solution works fine for the bottom level, but Anaplan won't allow comments at the parent level (Marketing - Corporate Memberships). Is there a simple fix to this issue?
-
Data Import for REV02 module
I'm getting this error while importing data for REV02 module. PFA screenshots.
-
Infomatica PowerCenter
What integration options are avaliable for infomatica PowerCenter integration with Anaplan? My guess is, Anaplan Connect and REST API?
-
Mule4 with Anaplan Execute Export streaming Integration (Unparseable date issue)
Hello Team, We are using Execute export streaming Anaplan operation connector in Mule 4. But we are getting the following exception from the Anaplan connector while performing the export option! org.mule.modules.mulesoftanaplanv3.internal.client.AnaplanV2Client: Exception while parsing currentTime java.text.ParseException:…
-
Auth problem for below python code
Hi , I am getting either an invalid path for (api 1.3) or not authenticated for (api 2.0) to get the transactional API for line items and IDs. I am using basic auth with base64 encoding. below is my code, I believe my code is correct. guide me if i am missing anything in the code. Note that, I have used GUIDs and auth as…
-
need the data analytic course video
-
Integrations - Excel Add-in
Hi, Is anybody else experiencing issues with the Excel Add -in when using Single Sign in? I can only access it when using the old sign in method.
-
Automation Code for new Input for SKU Code
Dear All, How to make generate code automation for SKU Code if want to add new SKU product in list, so the user just input name of SKU Thanks.
-
Data extraction from Anaplan Data Hub using SAP Data Services
Hi Can we extract data from Anaplan Data Hub using SAP Data Services, are there any limitations to it? Thanks
-
Anaplan: Valid To period - 9999
Hi Expert, Good day! Would like to seek your insights on how to upload the ValidTo period as 12/31/9999 and in Anaplan it will become blank (Date format). Since in Anaplan unable to load this period format unless set the format as text. Is there any workaround to handle this one or a system limitation? Thank you in…
-
Delta Load
how I can implement delta load from datahub to Spoke model. the action pulling the delta load is running into the spoke model , then how to mark the transferred data from spoke model to datahub model ?
-
Need help with Anaplan Connect
I am trying to run a bat script to automate export action from my model. However , i neither see an error or any other statements to indicate that the script is running. Can anyone help me with this?
-
Cloud export failed _Cloud works(Azure Blob)
Cloud export failed error while running the clouds works integration with azure blob. Do anyone knows about this error and how to fix it?
-
Levels to show only giving two options, not all levels of a hierarchical list
Probably an easy question but I am working through the level 1 course and it shows how you can aggregate based on a hierarchical list. When I try this on my own model it looks different and there are only two options. My view S01 Is a child of S02 which is a child of S03… S05. I'd like to display only the S03 Level. The…
-
Delta Load
Is it possible to do a delta load in the Anaplan model? Lets say one flat file is uploaded at 10.00 AM with 5 million records and the same file is uploaded at 11.00 AM with 6 million records. I just want to upload the new 1 million records into my model. How can we achieve that? Thank you in advance!
-
Can anyone share the link for Excel Add-in 4.4 exe file please?
I want to install Excel Add-in 4.4 exe file in my laptop. But I am not able to find out the link. Can anyone share the link for Excel Add-in 4.4 exe file please? Sharing the screen shot of website showing the link for Excel Add-in 4.4 exe file which taken few months back
-
want to know various reasons of UnMapping Issue
I have import csv file. which i mapped to Code to import the Data in to a module. After some when I ran the action its failing . When i checked the import mapping was not there. Want to know various scenarios for this issue
-
Reset Index number without affecting Data
Hey community members! I'm facing an issue with resetting the index numbers for List A in my project, and I could use some guidance on how to solve it. Here's the situation: I have a hierarchy consisting of three lists: A, B, and C. Currently, List A has reached its maximum index number. To give you an idea of the item…
-
Importing users in deployed mode
Hello Everyone, Could anyone please advise on how we can import the users in deployed mode? Is it possible to import the selective access fields as well? Thanks in advance..!!
-
What are the limitation of Cloudworks Integration?
Hello Community, I am new to the Anaplan cloud works. I just want to know what are the important points we should keep in mind, while creating cloud works integration. some where it is mentioned that per tenant the limit of integration is only 500. What does that mean? after 500 do I need to purchase any subscription for…
-
Bat file to Salesforce import
Hello, we use bat files to import data into Anaplan via Stored Proc. Now we're switching to Salesforce. I am new to Salesforce and cannot interact effectively with the Salesforce team. I'm researching how to import data from Salesforce into Anaplan. There is a technique to export as.csv and import. We were unable to…
-
Cloudworks API - Only header is exported
I have set up the export action and give the read access for the list that has selective access to Internal (full access) but it's still only exporting header. What might I have done wrong? Thanks
-
Using Auth2.0 authentication for Informatica Cloud
Hi All, I am trying set up auth2.0 authentication inside Informatica Cloud for my Anaplan V2 Connector. Just wanted some feedback from any users who has already tested this successfully. As per Anapedia documentation it mentions we have to input call back URL's in Allowed Callback URL's page while creating a client in…