-
Embed python into looker
Is there a natural way to wrap Python code to display in Looker? The ideal dataflow for my problem is SQL DB->python-> looker, or alternatively, looker->python-> looker. I am hoping to embed a.py into lookML so that I can automate python analysis, ready to display in looker.
-
2.3.10 Activity: Create Demand Forecast
Hi, I am stuck with creating formula for Baseline forecast, I have used formula "IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' But it only seem to work for FY20, I dont see data for FY21. Can somebody…
-
Pushing data from SQL to Data Hub via ADF
Hi all, I am currently creating an environment in ADF to push data from SQL to an Anaplan module which in our current toolset (Informatica) works perfectly via the Anaplan API connector but not so much via ADF having had to do the work manually given there is no connector. Has anyone here done this and if so, do you have…
-
Integration tool to show Tree Map Graphs in UX or Dashboard
As we know, Anaplan don't have graph like Tree Map Graph to show Distribution decision like picture below Is there any option or integration to represent data from anaplan to Tree Map Graph like picture above?
-
404 error when using API imports endpoint
Hi! When I try to use the imports endpoint I only get a 404 not found error. The api documentation I have been following is I first noticed the issue when running this: https://github.com/qkeddy/anaplan-audit-history so I tried with Postman and I got the same error message. If I run a GET to the specific model or workspace…
-
1.5.6.2 Import Data into Historic Volumes Module
Hello, I'm trying to import historic volume data into the DAT03 Historic Volumes module but somehow the load is being ignored. Please help. Note: All SKU and Accounts flat line items are mapped successfully.
-
Anaplan Integration with Azure blob
Hi all, I'm an Azure BI person trying to setup Anaplan integration with Azure blob. As mentioned in Anapedia related to cloudworks I tried to setup connection by clicking the "new connection" option, but not able to find any relevant "service" in the dropdown list. Is there anything else I have to do before hand? I have…
-
Integration - Constraints on Data Volumes/Frequencies
Are there materials regarding constraints around data volumes and load frequencies for the various Anaplan Integration options? Any user feedback or limitations that you have seen? Thank you
-
14.1 Using Workflow in Anaplan (30 minutes) is not running properly. It is getting stuck in between.
-
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…
-
Anaplan Informatica Hyperconnect
Hi Is Microsoft Azure Synapse SQL Connector for Informatica cloud available with Anaplan Hyperconnect?
-
Anaplan Connect 400 error
Manually upload file works but run process with Anaplan Connect gets an error Who knows the reason？ C:\Users\admin>C:\Anaplan\Batch\AnaplanClient.bat -keystore "C:\Anaplan\Certificate\keystore.jks" -keystorepass "xxxxxxx" -keystorealias "xxxxx" -workspace "workspaceid" -model "modelid" -service " https://api.anaplan.com"…
-
How to get the model size using the API?
I'm currently using the Anaplan API with the Anaplan Client to send and receive API requests. I wanted to get the size of all the models and this is the code I am using: set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -models Output : Now, the output is displayed directly in cmd. Is there any way to get the…
-
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…
-
Facing issue in column separator
Hi everyone, In the source we are using pipe to separate the columns .In anaplan i have created action using .csv file and now changing the column separator from import data source ans using "|" instead of column. For some data element this is working fine but in few in module i dont see any data. also when open the action…
-
Import error (parent item has a child item that is in a different list)
Hi all, I'm getting the following error in one of my import: Import into Hub_0_Product_Group Marketing L8 # list failed: Parent item has a child item that is in a different list: You can only add a child to a parent item, if any existing children of that parent item belong to the same list. Do you have any tip/advice to…
-
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…
-
7.2.3 Activity: Import Data into Employee Details Module error
Hi team, Missing out some step data while mapping, data was updated successfully attached screenshot (12error), however data is being uploaded with ignored values. Do I have to make any change in the module section? @noelle_murphy
-
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…
-
Stop allowing copy and paste into dependant dropdowns
Hi, We have a field that is dependant and i have unticked 'Allow access to unfiltered items' However if you copy and paste a valid (non dependant) value into the field it allows it I have made it go red as a warning, but can it be stopped so you cannot paste into dependant dropdowns? thanks
-
Mapping timescale during import and ignoring some columns
Hi I would like to know how do I ignore several columns from the source CSV file while importing data , where the first columns contains list and apart from several columns I want to ignore, Column headers are mapped to time. Attaching screen shots for your reference. In the source file attached , the first column simply…
-
Cloudworks
Hi everyone, We see that a certain action is failing in the anaplan notifications. But we are not able to trace who is running it either in the cloudworks or in the logs. How do we understand how is these actions getting triggered in the anaplan? Thanks & Regards Badam Anjani Prasad
-
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…
-
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…
-
Error on Excel Add-In
Hi All, do you know why I receive this error when connecting a view through Excel Add-in? Thank you, Joana
-
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…
-
Can we export data from anaplan and directly load into other tool via Rest API?
Hi, Can we export data from anaplan and directly load into other tool via Rest API, without exporting csv or text file.
-
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…
-
Deploy mode
Hi All, I have deployed a model from development to Production and try to run a script for batch run from other source in production environment, the script was run successfully but data is showing blank? And when i tried to upload the same file manually in production, i am getting error as "Deployed ode is enable for this…
-
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…