-
Does Transactional APIs supports data query?
Hi, I'm new to the Anaplan platform and I'm working on Transactional APIs to consume data from a model and view. I'm using the API collection from the docs and the following endpoint to get data - {{int_v2_base_url}}/2/0/models/{{modelId}}/views/{{viewId}}/data?format=v1 I'm not able to find any examples online on how can…
-
Is it possible to prevent Copy / Paste into a line item with a dependent dropdown?
Recently during testing, we learned that despite the dependent dropdown setting, users are still able to copy / paste data into the line item as long as it is a member of the list. Is there a way to prevent users from doing this? Risk is that we are using the input as the basis for mapping and we do not want data to be…
-
NMX) L1 Model Building - 10: Expense Modules not loading
Hi, the training web page is not loading. I have already completed the first 9 modules of the training in the same laptop and browser but , the 10th module as highlighted above is returning a blank screen without any error messages. Once I click enter in the below screenshot a blank page is opening and nothing else.Please…
-
Selecting Authentication for Anaplan Connect
Hi All, I am testing Anaplan Connect. I used the script builder to build me a script. However, when I went to run it I got the following error: unable to find valid certification path to requested target executing POST https://auth.anaplan.com/token/authenticate (SSL handshake: sun.security.validator.ValidatorException:…
-
How to set a serial number based on multiple properties
Hello, I want to set a serial number based on multiple Properties. I'm trying to set a serial number based on a TEXT type key item, but I'm not getting the expected results. I'm trying to implement this using the RANK Function. If there is an implementation method, could you please guide me? The "RANK_2" in this diagram is…
-
Cloudwork Data source file from subdirectory in S3 bucket
Hi, We tried to connect data source in subfolder of S3 bucket, through existing cloudworks connection with same AWS S3 bucket. However, no luck so far even not able to see the sub-folder or the csv file under the sub-folder, in the cloudwork setup i.e. link data source in process. Not 100% sure if couldworks is able to see…
-
Inquiry Regarding Anaplan Integration Process and Schedule
I have created an 3 Integration Process and added it to the Integration Flow and Schedule using my ID. I have a couple of questions regarding this setup: If the update schedule is modified using a different ID, will the process continue to run under my name, or will it reflect the name associated with the new ID? In the…
-
Excel add-in: breaking the connection's cell range
Hi Anaplan Community, I have a question regarding the Excel add-in. I was reading about refresh conflicts on this Anapedia page. If you break a connection's cell range, it may not refresh properly. To include a cell range in a Refresh, keep the cell range together at all times, rather than break or split it. You can insert…
-
Error 404 when I execute the export action with api
Hi Guys! I'm facing a strange problem and I can't find a solution. I've been running export processes for a while and they've always worked, however, this process on a specific model doesn't work. First, I run API user authentication and that works normally. Second, I get the workspace id and model id Third, I execute the…
-
Anaplan API to pull metadata at Module Level only
Hi all, I want to retrieve metadata from a model at the Module Level ONLY. Reason being is I have DataTags identifying which modules are Critical, Medium, or Low and would like to parse through this data. Currently utilizing this api: https://anaplan.docs.apiary.io/#RetrieveIDNamesModuleModel but only lists the model ID…
-
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…