-
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…
-
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…