Skip to main content

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

933 Topics
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Company News
Pigment recognized as a Visionary in its first inclusion in the Gartner® Magic Quadrant™ for Financial Planning SoftwareNews

Today, we’re pleased to announce that Pigment has been recognized as a Visionary in our first inclusion in the Gartner® Magic Quadrant™ for Financial Planning Software. We believe this recognition validates the hard work that’s gone into building the Pigment platform and how we’ve partnered with our customers over the past few years. We’d like to thank our customers, partners, advisors, and employees, past and present, for getting us to this point. Inclusion in the Magic Quadrant™ is a significant milestone for Pigment, and it gives the team great confidence as we move into 2025 and beyond. To download your complimentary copy, click here. Gartner disclaimer:Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statem

400
Isabella Leslie-Miller
Community Manager
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Welcome to the Community!
Welcome to the Pigment Community! 🎉

Welcome to the Pigment Community!We’re so grateful to have you here! The Pigment Community is your place to collaborate with, learn from and inspire other Pigmenters. Why should you explore the Pigment Community? 🔎We want you to be as confident as possible with Pigment. Through the Community, you get to engage with peers to share knowledge and expertise on using Pigment. We encourage you to share your insights and learnings, as others might well be facing similar questions. Above all, we want Pigment users to connect and engage with each other! I’m new here, where should I start? 👀💡 Good thing you asked – here’s how to get started!Register and complete your profile. Add a profile picture and fill out your profile details. Introduce yourself! We encourage all of our new members to introduce themselves in our Intro thread. I saw someone with a shiny badge and cool title, how do I get one? 🏅We reward active users publicly through a variety of badges and titles. Once you start posting

10301
abhilashsawla
T
Newly Minted Pigmenteer
tjain02Newly Minted Pigmenteer
asked in Questions & Conversations
Import Failure: Date format mismatch

I am trying to import a file manually. On the mapping tab in pigment the year column shows error. I tried various variations of the date format in my source file but the error is still not resolved. In pigment values for year dimension look like “FY 10”, I maintained the same date formatted structure in source file but the import did not work. I tried changing the year to look like “2010” in source file but that did not work either. what could be the possible reason for this error? 

312
T
Newly Minted Pigmenteer
Bas
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
asked in Questions & Conversations
Excel connector doesn't recognize named cells

Hello,I'm experiencing some issues with pushing data to Pigment from Excel. I have a simple dimension list (800+ items with about 4 dimension properties) that I would like to periodically update from Excel. I exported the current dimension list to .csv and used that .csv to setup an import configuration in Pigment. Then I pasted the .csv in Excel and updated the 4 dimension properties. I then named the data range in Excel but when I try to configure a push connection it doesn't recognize the named cells (“no names defined”).Also, when I try to input the cell ranges manually (A1 → G800) and then push the data to the dimension block in Pigment, the import fails (headers are not found...). Any help is appreciated. Thanks!Bas

80
Bas
Newly Minted Pigmenteer
K
Budding Pigmenteer
keerthanarameshBudding Pigmenteer
asked in Questions & Conversations
Create dimension list from another dimension list property

I have a dimension text property with a list of items. I want this list to be populated as a new dimension list. I used a concatenate in this property to get a new text item and I want this new text to be converted into a dimension. How can I do this with the help of formula?

191
Benoit
Community Manager
Bas
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
asked in Questions & Conversations
Error when exporting grid to Excel

Hello,Lately I’ve been getting error messages when trying to export a grid to Excel. Now I get these ‘Sorry, we couldn't find C:\users\xxx\xxx.xlsx. Is it possible it was moved, renamed or deleted?’ when I try to open the Excel that has been downloaded from Pigment.Does anyone else also get these error messages or knows how to fix them? By the way: the Excel Pigment connector works just fine, so that's a good workaround. But you also want to be able to simply download a grid to Excel… Thanks,Bas

182
Bas
Newly Minted Pigmenteer
Bas
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
asked in Questions & Conversations
Index versus LYTD shows only blanks

Hello,I have one table that has a number of calculated items in them. In the order of events: first the YTD value is calculated using cumulate (works fine). Secondly, the index versus budget is calculated (works fine for YTD) and lastly the index versus LY is calculated (that one goes wrong for YTD (only blanks). The strange thing is, is that that ratio versus LY does work fine when calculated over the month, but it shows blanks when calculated over YTD.Below are snapshots of my calculated items. Can anybody see why the index versus LYTD would return blank values?Thanks, Bas  

40
Bas
Newly Minted Pigmenteer
Artsemi
Newly Minted Pigmenteer
Artsemi
asked in Questions & Conversations
User cannot access pigment error 400 login failed

Hello. Has anyone encountered this issue before? Our user cannot access Pigment with error: 400 Login failed. User was added to Pigment long time ago, last login was 3 month ago. 

323
J
Employee
E
Newly Minted Pigmenteer
Erik SNewly Minted Pigmenteer
asked in Questions & Conversations
Standard Piment SAP S4Hana Public Cloud Set-Up

I’m trying to use the native Pigment connector to integrate S4Hana public cloud. I’m using the documentation in guide “Connect Pigment With SAP S/4HANA Public Cloud” but it is not working as suggested. I have used SAP commnication users and business users but I can not get any services to load once I want to import data. I’m missing some details that are not described in the guide. Has anyone set this up successfully and can share with me the specifics? -type of SAP user -permissions or roles required-other general things you had to do to get it to work?It would also be nice to be able to test the connection and accessible services straight from the workspace settings instead of having to go to the import option of a block.Thanks

91
E
Newly Minted Pigmenteer
V
Budding Pigmenteer
venitiavBudding Pigmenteer
asked in Questions & Conversations
Sort by subtotal

Hello,I’m trying to sort by subtotal but I don’t succeed, can you please help ? I have a metric (grid) with 2 dimensions in my columns. I would like to sort by descending value order for the 1st dimension of my column, i’m unable to do that. Do you have any idea how to do it please ? Thanks 

222
V
Budding Pigmenteer
jt.victor
Newly Minted Pigmenteer
jt.victorNewly Minted Pigmenteer
asked in Questions & Conversations
Appending two time dimension metrics

Hi,I have two metrics with the same data type: dimension (Month) and the dimension structure for both is the same. The concept is that I have deadlines for different dimension items. I was to append these two metrics because one is the prior forecast deadlines and the other metric is the current forecast deadlines. I want the new metric to have both.  When I do metric1 + metric2 i get this error:“Arithmetic operators only accepts same type arithmetic inputs after implicit casting, received Dimension (Month) operands” Please help! Thank you! 

472
Nathan
Employee
K
Just Arrived
KentiaJust Arrived
asked in Questions & Conversations
Freeze columns or rows in a table

hello,I’d like to freeze some columns in a table so that they stay visible while scrolling. Is it possible ?

291
F
Employee
A
Budding Pigmenteer
AlinaBudding Pigmenteer
asked in Questions & Conversations
Sorting values in table with multiple dims

Hi community, I need to sort the values in the table from high to low but I need to pivot it to pivot x dims in columns (e.g. Country, Client, Opportunity). If I use the traditional Sorting function of Pigment, it will sort only within the last dimension (in my case Opportunity).Is there a way to sort values disregarding dimensions but still keep them in my pivot?Thanks!

623
Ola
Seasoned Pigmenteer
G
Newly Minted Pigmenteer
geoff_chovazNewly Minted Pigmenteer
asked in Questions & Conversations
Trigger import from board in different application

Is there a way to allow a user to trigger an import configuration for a list in application A, from a board in application B?When I attempt to configure the button it is only showing me lists from application B. 

282
G
Newly Minted Pigmenteer
M
Just Arrived
Malt DEJust Arrived
asked in Questions & Conversations
export API rate limit error 429

Hello Pigment team,we use the export API for almost one year, but we have suddenly got error 429 in our export job using the API. Not for every job, but it happens often. Did you change any rules for export API ? I haven’t found documentation about it.Thank you in advance for your answer Sincerely,Mickaël

251
Keiran
Community Manager
K
Just Arrived
Kelvin ChanJust Arrived
asked in Questions & Conversations
Date to Month of the Year Conversio

Hello All, I’m currently trying to build an effective date for Merit increases and my input is as follows dimensioned by country and year. Right now, I’m trying to populate the table below with the month of the year e.g. FY23 should should December. I tried writing a formula TIMEDIM(ASM_Input_Merit Date, Month) and convert the data by Month.Month of the Year but it doesn’t work. Any suggestions on how I should write this formula?

1321
K
Newly Minted Pigmenteer
G
Newly Minted Pigmenteer
geoff_chovazNewly Minted Pigmenteer
asked in Questions & Conversations
Issue with (unwanted) date conversion in CSV import

I have a CSV file with a column indicating  the month dimension. It is “Jan 25”, “Feb 25”, etc. On the initial import screen it looks correct,however, as soon as I map it to the Pigment property (Month dimension type) it shows in the preview as My imported data is all loaded into the wrong months. I want it to just take the exact value in my CSV as the name for the Month dimension instead of converting a date. I tried double-quoting the field in the CSV, that didn’t help. Loading it into a regular text property works fine so it doesn’t appear to be an issue with the source data itself.  

342
G
Newly Minted Pigmenteer
sudhakar
Newly Minted Pigmenteer
sudhakarNewly Minted Pigmenteer
asked in Questions & Conversations
Sequence of modifiers to be followed in a complex formula

Hello,As I start my pigment training and work through the formula exercises, I have a question regarding the order of using multiple modifiers within a single formula.I’ve read that the sequence is important when combining BY and FILTER. In the same way, are there any best practices or modeling guidelines that affect performance or functionality when using several modifiers and operators together in random sequence, such as BY, BY->, Select, Filter, Add, Remove, or Exclude?Below is one example from the formula exercises (it may be a simple formula but I am thinking about what sequence to follow for complex formulae):'EE_Calc_MonthlySalary_+increase'[BY SUM: -> EE_Data_Stand.Area][by: 'GL Account'."11100"][remove sum: Employee][by :-> MAP_Datatype] Thanks

382
sudhakar
Newly Minted Pigmenteer
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Aggregating the data by mapping property

Source metric: ‘test’ is having dimensionality City, Category, Personalized quarter, quarterTarget metric: ‘test2’ is having dimensionality: City, Category, quarterTarget metric formula is:test[BY SUM: ‘Personalised quarter’.mapQ]For Fruityburg city, Q1 2024 → it should return 1790, but it’s giving 100  

322
P
Yuri Pinchuk
Budding Pigmenteer
Yuri PinchukBudding Pigmenteer
asked in Questions & Conversations
Page Selector - Defaul items

HiI want to restrict users on selecting only months with actual data and set up the Current month (the last month with actual data) as default for the Month selector.I created the Actual Months (multiselect) and Current Month item variables.Then I set up Actual Months as available items and tried to set up Current Month as default item.But after applying these settings nothing happend, meaning the Month page selector shows All, not a particular - Current - monthWhen I returned to Selector options I found out that default item for month had been changed to All values.The selection mode - multi or single - doesn't impact the behaviour.Are their any limitations to the default items? Why it's happend?And how can I make the excpected result happen? Please advise!Yuri

846
N
Employee
sudhakar
Newly Minted Pigmenteer
sudhakarNewly Minted Pigmenteer
asked in Questions & Conversations
What is the best practice for using BY modifier with Allocation method, BY CONSTANT vs BY?

Hello-As I begin pigment training and work through the formula exercises, I’ve noticed that while CONSTANT is the default allocation method, I often omit it, assuming it will apply automatically. However, the post-exercise walkthroughs consistently include it explicitly.Is there an advantage to always specifying CONSTANT (for allocation) or SUM (for aggregation), even when they’re defaults?Thanks,Sudhakar

411
Stef
Employee
K
Just Arrived
Kelvin ChanJust Arrived
asked in Questions & Conversations
Tracking Headcount Changes

Hello Everyone,I’m trying to build a validation process for headcount planning where I can track if a team member’s salary/cost center/class change vs the last load month. We currently load our data daily and each load will replace the previous load within the same month, so we would be comparing the difference vs the last load month. My intention is just to build a board that notifies us when changes happen and I don’t need to create a whole process of validation before these changes runs through to the forecast. Any help would be appreciated. Thank you!

241
Nathan
Employee
Yuri Pinchuk
Budding Pigmenteer
Yuri PinchukBudding Pigmenteer
asked in Questions & Conversations
centralized access rights

Hi I'm working on a centralized user access for several apps in the workspace, including Roles and AR Metrics.I want to create User Roles and Access Rights in the Data Hub and share them to other applications through Library.This article  is marked as legacy. I'm curious what's the new approach and where I can find information about it? To which extent I can use this article advices?Another article has the section related to the topic “Smooth User Access Management” with a link, but the link doesn't work Please, helpThank you,Yuri

704
F
Employee
F
Newly Minted Pigmenteer
FranckLPNewly Minted Pigmenteer
asked in Questions & Conversations
Include ratio calculationbased on multiple dimensions

Hello,I have a metric that shows the P&L.I’ve been asked to add multiple ratios like % of GM / Revenue or % Contributive Margin / Revenue. The issue is that the accounts are not on the same dimension (revenue is Account lvl 2 and Gross Margin is Account lvl 3).What is the easyest way to add those ratio. Do I need to create a specific metric just for them or can I do the calculation directly in my metric ?

292
F
Employee
M
Just Arrived
Max.PJust Arrived
asked in Questions & Conversations
How to add more than two items to a calculated item

Hello, I am trying to create a calculated item to sum values from countries into a region. However, I only see the option to combine Item A and Item B… is there a way to insert more Items (e.g. Item C) in Pigment? Thank you!

541
K
Employee

Badge winners

  • Pigment Like a Pro
    dormahas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    dormahas earned the badge Pigment Modeling Fundamentals Certified
  • Innovator
    tbettleshas earned the badge Innovator
  • Innovator
    Brian Mondellohas earned the badge Innovator
  • Pigment Modeling Fundamentals Certified
    Teneziehas earned the badge Pigment Modeling Fundamentals Certified
Show all badges
Terms & ConditionsCookie settings