Hi Pigment,I shared with our team the new dimension mapping capability but they can't use it, what access rights and permissions they should have in order to do it?https://community.pigment.com/reporting-data-visualization-83/group-data-dynamically-with-mapped-dimensions-3160Thank you,Omer.
Hello,I might have a really simple question, but I can't quite figure it out. Is there a way to show the available item variables in a page selector on a board? If I go into the page selector options by clicking on the edit button on a board I can see all available item variables for a specific dimension (for example under ‘available items’ or ‘default items’). But via de dropdown on the page selectors themselves it is not possible to use the variable as a filter? The specific underlying use case is that I have created a subset of profit centers and I would like the end users to be able to view that specific subset of profit centers by filtering the page selector. They shouldn't manually have to click one-by-one.I hope my question is clear :-) Thanks a lot everybody!Bas
Hello, Seems like a silly question to ask but I am having a hard time locating the model ID within a model and can’t locate this info in any documentation. On a similar note, where do you locate the workspace ID? Thanks for your support,HA
Currently, if you try to deploy an application from one environment to another, you might ran into this issue : It would be useful to know which app (just the name) you don’t have access to.
Hello,Is there an option to skip to line when the text is long on a metric ? There would be enough space to write :“YTD internal heacounts (end of month)”Thank you
There should be an option or setting to adjust the column width for all columns in the Transaction List/Dimension List at once. Currently, column width can only be adjusted individually per property. A global setting to apply the same width across all columns would enhance usability and efficiency.
Dennis, Head of Securities Services Americas at BNP Paribas, gives us a guided tour of his career, the principles he follows for success, and his forecast for the next five years. If you’re pursuing a career in financial services, Dennis Bon is a strong candidate to model yourself on. Dennis is Head of Securities Services Americas at BNP Paribas, holding positions at JPMorgan and ABN AMRO prior to that.We sat down with Dennis recently to reflect on the decisions he’s made throughout his career, the advice he’d give to people earlier on in theirs, and where he thinks the industry is going next. Did you always have a ‘grand plan’ for your career? No is the short answer. But what Dennis did have were three principles that he thinks have served him well:A constant desire for learning and change Every 3-5 years, Dennis finds himself doing something different - usually coming with fresh challenges and more responsibilities. An appetite for risk The first principle necessitates this one, real
One of the most common use cases in Pigment is creating financial plans, often referred to as Version Planning or Scenario Planning. Whether you decide to use Versions or Scenarios (or both) to create plans and forecasts in Pigment depends on your modeling needs. This article describes all these approaches, so you can understand which is the best fit for your use case.Why use Versions and Scenarios? Modeling overview Plan with the Version Dimension Plan with Scenarios Implementing each approach Set up and use Version Dimensions for planning Set up and use Scenarios for planning Plan with "What-If" analyses How to implement a “What-If” analysis “What-If” analysis examples Scenarios Version Dimensions Version Dimensions combined with Scenarios Considerations when combining Scenarios with the Version Dimension Benefits of the combination approach Limitations of the combination approach Why use Versions and Scenarios?Versions and Scenarios help you structure and explore variou
To ensure fair usage and maintain consistent performance for all users, Pigment enforces rate limiting on its public API endpoints. Rate Limit PolicyLimit Parameter Limit Value Limit 500 requests Time window 5 minutes Rate limit scope Per IP address Affected endpoints All Pigment public API endpoints If this threshold is exceeded, the API will return an HTTP 429 Too Many Requests response. Requests can resume once the 5-minute time window resets.
Hi everyone,Yesterday, that is on 19/06/2025, the feature “List-List Import” feature was released and I believe its a great feature, but I want to know about the practical usage of these feature, like what are the scenarios where we should use this feature, It would be great if someone can help me understand.Thanks everyone!
Hi everyone,I'm trying to use the cumulate function to sum only the FY26 months of the metric Nexus Lowest Level, but the output includes all years instead of just FY26.Has anyone run into this or knows how to fix it?Thanks in advance!
🗽 Welcome to the New York 2025 Megathread!Hello Pigment users in the Big Apple! This thread is your go-to space for connecting with fellow Pigment users in and around New York. Whether you're looking to network, share insights, or stay updated on local events, this is the place to be.What you can do here:Introduce Yourself: Tell us who you are, where you work, and how you use Pigment. Ask Questions & Share Tips: Whether you're troubleshooting, looking for best practices, or want to discuss strategies, this is your space. Meetups & Events: Keep up with Pigment-related events in New York or use this thread to organize casual meetups. Industry Insights: Share how Pigment is driving impact in your company or industry. Stay in the Loop: Get updates on local user group gatherings, workshops, and community initiatives.Let’s make 2025 a year of collaboration, learning, and growth for the Pigment community in New York. 🚀Drop a comment to introduce yourself and tell us what you’re hopi
This June, there are several new product enhancements at your disposal! Check them out below and sign up for our upcoming Product Webinar on July 24th to learn about other useful features and those coming soon. 📝 Import data List-to-List 📈 Chart zoom for better exports ↪️ Use Top navigation in Sequences 🎨 Customize your Application icon color 🔒 Simplify security with access rights Dimension replacement 🚀 Deploy import configurations with ease 👣 Track last activity on Items in Lists 🌐 Product Webinar & Virtual User Group - July 24th 📣 Pigment Customer Advocacy Program: Get rewarded for your support 👥 Virtual Roadshow - July 29th Import data List-to-List You can now import data directly from one List to another using List-to-List Import. Map source and target Properties with matching data types, add filters if needed, and run the import manually, with an Action button, or on a schedule. Chart zoom for better exports You can now zoom in and out on chart text for better re
Welcome to our annual introductions thread!We hope you’ll use this as a place to share a little more about yourself and get to know the other members in our community. Tell us where you work, a bit about your role, where you live and how you use Pigment. Add any interesting facts about you or even a nice picture that means a lot to you (like in a cool place, or with a pet)! If you want to see our past introductions thread for some inspiration, look here. I’ll get the ball rolling:Hi! I’m Isabella - I’m the Community Manager here at Pigment and I’ve had the great privilege of working here for around 8 months. Before Pigment I worked at a data science education company, and my academic background is in Mathematics and Finance.I’m originally from South Africa and moved to the UK around 3 years ago - I’m now based in lovely Harrow. Outside of work you’ll typically find me reading, gaming, traveling, going to a gig, or building a cool cosplay for Comic Con.I’m looking forward to getting to
Introduction: Hello Pigmenteers! I’m Clément ( @CDALMAY in the community). I’m based in New York, where I’ve been living for the past seven years. I’ve been working with MeltOne for nearly three and a half years now and over the last decade my career has been focused on FP&A and financial planning tools.I started out with Oracle-based solutions, transitioned to Tagetik as a technical architect, and then discovered Pigment in 2022. Since then, I’ve been mainly focused on Pigment, with about three years of hands-on experience which is half the lifespan of the platform itself! You can see Clément’s full interview here: What advice would you give to someone new to FP&A or Pigment?Always be curious and willing to learn new things. You’ll make mistakes, that’s part of the process, but hands-on experience is the best teacher. Don’t be shy For those new to Pigment: start with the Academy. It’s structured, practical, and a great foundation. Pigment is easier to learn than many legacy
With mapped Dimensions, you can dynamically group data within a View, without having to redesign your model.This feature provides an alternative to changing the Dimension structure of each Metric in a Table, making Tables faster to build and more performant. Before you begin Use cases Set up mapped Dimensions Add the Dimension to a View Behavior Before you begin You can use a Property to group data when there is a static relationship between two Dimensions. For example, grouping Countries into Regions through a Property is appropriate because a Country typically remains in the same Region. For more information, see Set up Properties in Lists.However, when relationships are dynamic, such as employees belonging to teams that change from month to month, a different approach is required. In these cases, use mapped Dimensions. Use cases In a MetricThis use case looks at employees’ salaries stored in a Metric called Salary with Dimensions of Employee and Month.You want to see the salary
Mapping Metrics are used when two or more Dimensions in your model have a relationship but the relationship is liable to change. For example, a use case might be employees working in teams, but as months go by, they are reassigned to new teams. Before you begin What is a mapping Metric? Set up a mapping Metric Contexts for using mapping Metrics Before you begin What is a mapping Metric? While a mapping Property defines a static relationship between a Dimension List Item and a second Dimension, mapping Metrics define a dynamic relationship, involving multiple Dimensions. One of them is often time.A mapping Metric tracking employees in teams over time might look like this:Mapping Metrics are not limited to time-based relationships. Below is an example of key ingredients for your product lines that come from different suppliers by region. A mapping Metric tracks suppliers by Product by Region:Set up a mapping Metric In your Application’s sidebar, hover over Blocks and select the + symbol
With the new functionnality to create dimension based on an other dimension/transaction list, I want to create a concatenation of 2 columns in my transaction list but.. Pigment say there is an error because a lot of rows don’t have unique ID. Is it existing a “ISFIRSTOCCURENCE” formula or simithing similar to filter my view and solve the point ?
Hi, I am trying to create a Boolean metric with Month as the only dimension member. I want to write a formula where if the month is greater than eg. “April 2025” and less than or equal to ‘Last Actual Month’ (Month dimension property member of ‘Save Version’) of ‘Save Version’.”Live Version” then TRUE but I am having trouble calling the ‘Last Actual Month’ of ‘Save Version’.”Live Version”.I think ideally I would be able to pull something like ‘Save Version’.”Live Version”.’Last Actual Month’ but surely it can’t be that simple? 😅
Hi Team,We have an input transaction list for new seat requests. In this list, a manager and above can come an ask for a new seat / headcount and that is determine by Supervisory Org. So if I am a Senior Manager, I can come and request for a Manager position and so on. We also have a dimension list called Supervisory Org 1 which determines what is the Org of an employee and what are the levels above. Now we want to pull the levels for the new seat based on the manager’s level. But this is giving us the circular reference error.Bottom line is we are using the dimension list to pull the levels in transaction list based of of hiring manager level and now we want to put it back in the dimension for the hiring position. Any workaround for this situation?
Is there a way in Pigment to submit a button?(i.e. similar to marking a checkbox as True)
I am receiving an error “xxxxxxxxxxxxxx is not a valid unix username” when trying to establish an SFTP connection. The username is quite long - 27 characters. The connection works in other SFTP clients like Filezilla using the exact same parameters. Any ideas?
List-to-List import is a type of Block-to-Block import. It allows you to import from one List to another by mapping source and target properties that share the same data type. These imports can be saved and triggered by an Action widget or set up as a scheduled import. This article discusses how to configure and use List-to-List imports. What is a List-to-List Import? Set up a List-to-List Import Step 1: Filter the Source List Step 2: Map Data for import Import summary What is a List-to-List Import? A List-to-List import allows you to use data from one List Block as the source for importing into another List. This type of Block-to-Block import supports both Transaction Lists and Dimension Lists as either the source or the target.Imports can be saved and then either scheduled or triggered via an Action Button on a Board. They can also be used to manually transfer data between Lists by mapping properties that share the same data type.The source List can reside in the same Application a
Hello,I need to count the number of client inside a Database by several Dimension (Month, Business Unit, Category(New, Upsell, downsell, Churn), Client type, ...)I tried using COUNTUNIQUEOF but it doesn’t work (timeout of request).IF(Month < 'Switchover Date for Forecast/Budget',IF('Full data BI'.subscription_type = 'Subscription Type'."Renewable" AND 'Full data BI'.segment_revenue_category <> 'Customer Category'."Churn",COUNTUNIQUEOF('Full data BI'.customerid) [by :'Full data BI'.segment, 'Full data BI'.segment_revenue_category,'Full data BI'.Month, 'Full data BI'.customer_type, 'Full data BI'.product, 'Full data BI'.product_type, 'Full data BI'.region, 'Full data BI'.subscription_type]))Could you please help me sort that out ?
Hi everybody,I'm running into some difficulty when trying to present a P&L in % of net sales at subtotal levels.I have a ragged P&L hierarchy (account dimensions L1 to L8, where my net sales is defined at L3). I want to show all values, including the subtotals, as a % of the specific item “net sales” at the L3 dimension.When I try to use ‘show values as’ as a % of another metric where all my lowest level accounts contain the total net sales amount, it works for the lowest level (L1) accounts but the subtotals are aggregated (that is: the total net sales amounts that are allocated at the lowest account level (L1) are incorrectly aggregated together, which throws off the %-calculation). For example: I have 10 L1 accounts, each of which contains 100m as net sales. At the subtotal L3 (net sales) level, I then get 100m / 10x100m = 10%, where I would expect to see 100%. I also tried to use ‘show values as’ as % of a specific item of the L1 dimension, where I used an item variable tha
Already have an account? Login
Single Sign-On Need help?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
