-
Prevent Import
Hi, I have a scheduled import into a history module with a snapshot of data, every Friday at 2:00am. This all works. However, sometimes we need to take the snapshot manually earlier in the week, and if this has happened i dont' want to allow an import on Friday. As the import is using anaplan connect and runs every Friday…
-
Import data to read quantities per dimension instead of actual data
Hello, I am trying to create an inventory model for a bunch of server farms. i have one csv file with over 15000 machines. For each machine, it shows its location, its manufacturer, the model, how many cpu cores, and a cpu factor. I want to create a module that shows me the average of cpu cores x cpu factor per location.…
-
cURL fetching an export from API intermittently failing with 500 Internal Server Error
Hi All, We are trying to GET the exports from API but it is intermittently failing. At times when it is successful the response header will have content type returned as "Content-Type: application/octet-stream" and when it fails response header contains "Content-Type: application/json;charset=UTF-8" FYR see below when it…
-
Jira Integration
How can we integrate Jira with Anaplan. Can anyone please help me out.
-
Date Formatted Line Item || Default Mapping during import
Hi, I have a date formatted line item in one of my modules where we are importing the data from a file upload. I want to understand that what is the default format anaplan would require 'Date' column in the file if I do not select a custom mapping? Regards, Aakash Sachdeva
-
Google Sheets Add-On
Is anyone else having issues with refreshing data in Google Sheets via the add-on recently? The load keeps freezing or telling me there are various errors.
-
Create filter based on line item
Hello All, I have a requirement where we can create filter based on line item so that we can export them. There are five line items for example - Payroll tax, salary, overtime, incentive, and bonus. The user should be able to check (using the new UX) which of the line items they want to export. Based on the checks, we…
-
File upload Question
I am trying to upload the file with the data and headers below. But for some reason I am getting an error on the time setting. not sure what to do here or how I should be setting the dimensions of the module.
-
How to Find Max for Specific line item
I am trying to create a module with the following line items (dimensioned by products in pages and line items in rows, time does not apply). when a product is select from pages: Max slots - display max value across any month When - display the month that the 'Max' appears Width Factor% - user input Width Interval - display…
-
How to return the month/time period of other line itme
Hello, I have a module with two line items. This module has product list on pages and line items on rows. 'Max Slots' has a formula that returns the MAX value of a given product from another module. For the other line item 'when' I am trying to return the month or time period that the MAX value takes place. I am trying…
-
Export with combined dimensions.
Hi all, I have a ask to run a export from anaplan module, currently the export looks like this, but it should look something like the image below: First question: is it even feasible Second question: if it is, what could be the possible workaround for it. Thanks and regars.
-
Import date enclosed in double quotation
Hi, I want to import csv file. But the data was enclosed by double quotation in text file. Are there any problems when I import this type of csv file?
-
Custom Preconfigured Messages in Notifications
Hi, Is there a possible way to add custom preconfigured message derived from a line item in Anaplan and what is the process for the same. Regards, Aakash Sachdeva
-
How to add constant value to graph? OR UX Chart has multiple data sources?
I am trying to build out a UX dashboard for a module that contains a list of products and imported data that shows how much resources each product uses(the resources is defined by one single number per month). In another module I have a specific line item that contains our total max resources (number). I am trying to…
-
Referencing List Items in Formula
I have module D03 that shows how many slots each product family uses. D03 is dimensioned by Time on rows, and PR2 Product Family list and 1 line item 'Slots' on columns. I am trying to write a formula that 1. references data from another module, and 2. does some calculations for all the data in each item for PR2 Product…
-
Can module 'Applies To' have multiple lists from the same hierarchy?
I have created Line Item subsets and certain modules for filters for other modules. My ultimate goal is to assign different line items to different list items (across the hierarchy as well). I have P1 Product Lines, P2 Product Families, and P3 Product Names. I have module D07 which shows how many slots each of P2 Family…
-
Chart UX Constant/Module Calculations
Hello, I am trying to build out a very specific UX dashboard. I am trying to create a chart that displays all the data from a single list AND also add one additional data row that is from another module. Module 1: D01 Slots Pages: Version, Locations, Teams, Resources Column: Time Rows: Slots (Line Item), Products (20+…
-
Loading data from another module: Data is ignored when loading to Version
I have one module called DAT01, which contains employee census data. There are two others modules called DAT02a and DAT02b, which are identical with the exception that DAT02b applies to all versions whereas DAT02a does not apply to any versions. DAT01 only has one dimension, which is a unique ID containing a combination of…
-
Run process in anaplan from informatica
Is it possible to connect to a process as a target in informatica cloud(hyper connect) and run the process instead of individual actions?
-
Is there a function that checks the name of a list item in a module and returns specific data?
Hello, I am trying to build a UX dashboard that displays data from two different modules. In D01 Slots (PAGES: Version, Locations, Resource Groups, and Teams. COLUMNS: Time. ROWS: Product Names and one line item "Slots"). Module D01 allows me to see the number of slots each product uses. In D02 (PAGES: Version, Locations,…
-
What is Managed By functionality?
-
Change the file name everytime the user Export
Hi, Community I want to change the export name everytime I export The definition of the name whould be "Module name and Time the user selected" or "Setting name when I create the export and Time the user selected I look for the way to do, but I couldn't find it. I really appreciated if you help Kind Regard
-
Change Source of a Model from Data Hub Dev to Data Hub Prod
Hi All, I am working in a User Story of a Dev Model to change the sources of data from Data Hub Dev to Data Hub Prod. The model In Dev I am working by now has already around 70 actions that are pointing different views of Data Hub Dev as a source of data. In my analysis I found that one way to do the change is: * Go to the…
-
Issue in Tabular Multiple Column Export Format
Hi All, I am facing an issue while exporting data from a dashboard by selecting Tabular multiple column export option. Although the table on the dashboard has been published by creating a saved view(i.e. by selecting 'Show Selected Line Items only' option). However, while exporting the data in tabular multiple column(.csv)…
-
Is Summary not dynamic?
Hi, I have explained everything in the below screenprint. Please share your views on how to handle this case.. Note: The module is data module where all the data is imported through csv file.
-
How to declare a variable in denodo?
There is a question related to this topic but is not the same that I am going to ask, I need to do something similar as we do in SQL but this time in Denodo. This is in SQL: DECLARE @curr varchar (10); SET @curr = 'USD; SELECT Country, Currency FROM Currencies WHERE Currency = @curr; I have tried something like this in…
-
How to shorten names for a data flat file you use t import into List
Hi, I have a List that will get populated once a month from a flat file that is given to me from IT. The only issue is that some of the naming in the flat file is too long to bring in as a List. And if the name is too long then Anaplan will not bring in that name into the list. I want to know what is the best way to fix…
-
Export data using Cloudworks
Hi, Is there a way i can use CloudWorks to export data without using the connector? I cannot select the Target folder where i want to save the extracted file. Thanks in advance for helping. Regards, Tom
-
How to remove List Subset Item from Labels in Export
Hi I have an export from module, where one of two dimensions is the List Subset Item. When I want to export it as Tabular Mutliple Columns - I see in the Lables only name (connected to the First Dimension). I need to removed List Subset Item from my export, like other labels. I wonder how to do it?
-
Chunks Error
chunksArray = jsonResponse["chunks"] KeyError: 'chunks' Hi all, I have connected with Anaplan through API with help of Python . Basically I am Exporting file from Anaplan for getting suggestion But now If i am using my credentials and my Model it is working fine. But for others it showing error above pasted. Chunks are…