-
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…
-
Importing is not working
Hi, We are trying to import from one source to Anaplan but we are not able to import anything. We are able to export the data. please find the output below that we are getting when we are trying to import. { "meta": { "schema": "https://api.anaplan.com/2/0/models/B97129A7835A44D484A5008266AB711E/objects/file" }, "status":…
-
Infomatica PowerCenter
What integration options are avaliable for infomatica PowerCenter integration with Anaplan? My guess is, Anaplan Connect and REST API?
-
When exporting to other systems, is it better from Spoke or from Data Hub
I feel I get conflicting answers when I try to research this question. In the Anaplan Model Builder training, they say export from the Data Hub to other models. Likely because model to model import is less time, and this will make the spoke have less downtime. However, in forums, I see people saying either one is okay. If…
-
Should version be in the unique ID when importing into a spoke?
I am looking to import these dimensions below. I am wondering what should be included in a unique ID? -Version -Time -Product -Country I think Unique ID in this case is Product and Country, but can someone confirm?
-
Any Way to Switch a Cloudworks Integration from AUTO_DEACTIVATE
Is there any way to force a cloudworks integration to toggle back to ACTIVE from AUTO_DEACTIVATED? Context: We built a number of integrations and scheduled them to run on the weekend. If an integration is scheduled to run during the regular maintenance windows, eventually the integration in cloudworks will flip to…
-
Is it possible to have an anaplan export automated having 2 dimensions in columns?
I am trying to create an automated export of a view that has time, as well as line items in columns. I have tried this via Cloudworks and Informatica but it is not working. When I am manually running an export in anaplan its working fine but not via integration.
-
Anaplan Data - Real Time Access
Hi All, We are trying to access Anaplan Module level data using Python. I just wanted to access Anaplan data (Module Level Data) in real time by using Python or Java without getting data from Anaplan with flat file. Also wanted to establish Connectivity between python & Anaplan in the real time. So we can get updated data…
-
How to add colors to worksheet
My current worksheet has color highlight for some rows, now I want to create a new page and add highlight other rows with colors, how do I do that?
-
Formula error
In my Stat forecast I have some items mentioned as "End of Life" and it has a date until which the item will be active for forecast but after that date it will go inactive. But the formula that I have now isn't giving me forecast for that item. For e.g.- For Item A - EOL = Jan 2025. (so this should give forecast till Jan…
-
Anaplan API 400 Bad Request retrieving token
Hello all, I'm trying to do a request from SAP middleware where I pass 'Authorization' header and 'Host' header to retrieve authentication token. Once I send the request, I've got a 400 Bad Request HTTP response. If I send same request from Postman I'm able to get the token. Could you help me, please? Best regards.
-
Adding a parent hierarchy to the existing lists
I have a hierarchy of brands which was set up a year ago. Now I want to add a parent to L1 (i.e. L0.5) as a parent of all, which should separate all brands into Private Label and Owned. Because now when I build pages and I want to see only the owned brands altogether I can't do that as in the module the brands are listed…
-
Anaplan Integration with Azure Blob
I have integrated Anaplan Cloudworks with Azure blob to automate daily export files, I have scheduled my exports. I want to add date to my daily export files, like if today the export runs it adds a date to the file name, and tomorrow it adds the respective date and so on, so I can distinguish between each looking at the…
-
Anaplan Connect JDBC issues - SnowFlake - jdk.internal.misc.Unsafe
I have successfully connect to snowflake, and extract file, import to anaplan file csv, but it seems the connect api did not call the action to import into anaplan. (Because I have seen the file of anaplan has been updated, but the process/action has not been launched) It seems the problem coming from…
-
Anaplan Connect JDBC issues - SnowFlake - (solved)
I have encountered some issues when configuring and running connect script. But I didn't get a specific error message, as following picture : PS: I have configured the snowflake properties files and java, anaplan connect installed etc. Can anyone give me some tips to figure it out ? Thanks
-
Is there a way to change which browser is used by Excel Add-in for SSO authentication?
Using the latest Excel Add-in, it appears this is using an embedded version of Edge browser (version 95.x). Our organization has blocked this browser being used due to the age of the version. Is there a way to change which browser the Excel Add-in uses for SSO authentication so that it will use either system default…
-
How to retrieve the mapping information of import action ?
Hello everyone, I have a task to check in all my import files, which columns are used (that is to say, mapped to a Linitem in Anaplan), which are not. To do so, I need have mapping information for the import actions (all at least which columns are mapped), any idea to do this? Many thanks !
-
How can we use OAuth integration with Cloudworks and BQ
We are evaluating Cloudworks to integrate Anaplan with Google BQ. Our security team advised that they prefer OAuth-based integration. I could not find documents on how Cloudworks can use OAuth. Can Cloudworks use OAuth ? If yes, where can I get material to understand how to use Oauth with Google and Anaplan using Cloudwoks
-
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
Anaplan Connect cannot connect to database
Hi, We recently set up a new database to export data from Anaplan to Azure. The database is a SQL database on Azure VM. I am trying to set up connection. Export out of Anaplan is always successfull, but keeps failing when connecting to the database. Jdbc connection string: Anaplan connect is also running on a VM.…