-
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.
-
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.
-
Can I add drop down list (with data from a list) to cells that are loaded with data?
Can I add drop down list (with data from a list) to cells that are loaded with data? I've added a validate button, but now I'm trying to create a functionality that allows managers to make changes to data if the loaded data is incorrect. I'm having trouble including both a drop down list and prepopulated data in the same…
-
Set one column of source data as "Not Applicable" for this import
Dear Anaplan Community I am looking for a way to "ignore" one column of data from the source file as irrelevant when uploading its data into module. Source file contains columns as below. Column D is actually the code of Column C inside Anaplan model. And Column D is there because client wants visibility into expense type…
-
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…
-
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…
-
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
-
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+…
-
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,…
-
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…
-
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
-
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…
-
Salesforce CRM Analytics to Anaplan Connector?
Hi all Anaplanners, Does anyone know how to connect Salesforce CRM Analytics to Anaplan to enable one way/two way data transfer? Thanks, Jim
-
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…
-
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…