Connect with other users, discuss how you're using Pigment, and get inspired
Recently active
Starting September 28th, Frames opens to every customer with the Modeler Agent. Describe what you want to build and Frames builds it. No code required. Below: this month's other updates, from AI credit tracking to faster data flows, plus where to catch us on the road this fall. Experience Pigment like never before with Frames Frames are coming to everyone. Starting September 28th, Frames will be available in Open Beta to all customers who already have the Modeler Agent. If you can describe what you want to build, you'll be able to build it - no code required.Think dense, beautiful visualizations built from a plain-language description: Sankey diagrams and tree maps that make complex flows click at a glance, interactive sliders and drag-and-drop controls that turn a static report into a live planning tool, executive-ready presentations that look like they took a design team a week - generated on the spot, running right on top of your Pigment data.Want to see it before you build it you
Month after month, Pigmenauts share challenges, ideas, and solutions that help us all learn and grow together.To celebrate this knowledge sharing, here are September’s top 5 questions. We’re highlighting the ones that sparked the most interest and views from fellow members 💡.Whether you faced the same challenge or want to learn new tips, these threads are a great place to explore, contribute, and connect. 1. Can a Data Flow (or any single-click trigger) combine multiple external/connector imports (e.g. Sage)? Question - @shubham:“Can external-source imports, such as Sage, APIs, or connector-based imports, be included in a Data Flow? If not, is there another way to trigger multiple external imports from a single Board button?” Best Answer - @Julien:This isn't currently supported, and there isn't an alternative way to trigger multiple external imports from a single Board button today.However, this exact functionality is entering beta testing, allowing external connector imports to be
Welcome to the Pigment Community!You’ve just joined the Pigment Community! Welcome! This guide will help you on how to dive in, meet others, and learn how everything works here.Inside this community, you’ll find proven solutions, insider tips, and direct access to fellow Pigmenteers who’ve faced (and solved) the very challenges you’re tackling. Think of it as your backstage pass to getting the most out of Pigment.We invite you to be curious, look around and discover all we have to offer! To help you get started, here’s your First Steps Checklist ✅:Register and complete your profile. Add a profile picture and fill out your profile details! Say hi! Introduce yourself in the Intro thread Join a local group. Connect with members in your country and exchange insights close to home. Jump in and ask a question, contribute an idea or share your insights! Active participation doesn’t go unnoticed! Our badge and ranking systems showcase your contributions. As you like, post, reply, and support
I renamed a metric, and a downstream metric referencing it didn't auto-update — the formula kept the old name and broke with "Unknown Block". Renames usually propagate to dependent formulas automatically, so this looks like a gap specific to the references. Has anyone else seen this?
What does a Pigment user group look like? An engaging half-day that our customers spend with each other: honest conversations, a look at what’s coming next, and time to work through real questions together.At a glanceHear how other teams use Pigment, and what they’ve learned along the way Get a roadmap update from the Pigment team, with plenty of time for questions Join a workshop or roundtable on a practical topic, including Pigment AI Meet people from nearby companies over a mealWhether you’re new to Pigment or years in, you’re sure to find something useful to take away from our user groups! Someone who uses Pigment shares their story: how they got started, what surprised them, what they’d do differently, and what they’re working on now. Speakers range from teams just past go-live to those running mature setups, so there’s a range of experience levels and points in the Pigment journey for you to learn from.If you’re wondering how to do something, odds are someone in the room is too
Hi friends, I built a slide editor in Pigment Frame, announced it on Linkedin (here’s the post).I got a LOT of request to share the prompt-result so other people can do the same.So I’m sharing it here.I attached 3 files:slide it code: the code of the frame slide it resources: how this frames plugs into a Pigment app skill.txt: an explanation for Agents how to rebuild itLoad the 3 files to the Modeler Agent and say:build a new app "Slide it Test".Build a frame following the instructions in the attached skill.txtDon't re-invent the code nor the resources of the Frame, take them from the code and resources attached txtI encourage you to build this in a stand alone app to which you will share blocks you need the data connected in your slides. This should give you something like this: enjoy !
Introduction:Hello Pigmenteers! I’m Tom Gilbert (@tgilbert in the community), and I’m the Enterprise Planning Platform Lead at Celonis, based in New York.My day to day is really focused on managing the Pigment platform. That includes the long term roadmap and thinking about where we want to take the platform, but also the day to day work of building new enhancements, troubleshooting bugs, and supporting and enabling our users. You can read Tom’s full interview here: Can you tell us a little about your career journey?I started my career out of college at an EPM consulting company, where I worked on implementations and helped different companies build out their EPM platforms.I enjoyed that work, but I became interested in seeing those projects through for longer. In consulting, you often work on a shorter implementation and then move on. I wanted the opportunity to work internally at a company and think more about the long term strategy of a platform.That led me to join the finance tea
Hello, I'm having difficulties with the Claude MCP server. It can find certain metrics, but it does not seem like it can also peek into the properties for each dimension. For instance: I have a simple text property on a certain dimension, but Claude insists that it cannot see the properties for that dimension.Any idea what that might be and how I can fix that?Thanks, Bas
Is it possible to enter data when the input enabled metric is rendered in a Board but displayed using a Data Slice? Eg where Data Slice is setup on Version to pull just two versions
Love Pigment and want to shape how a global company plans, closes, and reports? 8x8 is hiring a Senior Finance Manager, Systems & Corporate Reporting to own and evolve our Pigment environment: the architecture, the data flows, and the consolidated reporting that runs on top of it.We have a dedicated SEC reporting team, this role is focused on operational reporting and works closely with the CFO. Remote, US-based, Pacific time availability required.More details here, feel free to reach out directly
When Application A's board displays a metric shared from Application B via a Library/cross-application reference, and that reference is used directly in a view rather than wrapped inside a local formula in Application A — does taking a Snapshot of Application A freeze that displayed value as of snapshot time? Or does opening the Snapshot later still show Application B's current live value for that metric? Does the answer differ if the shared value is instead consumed inside a local formula in Application A before being displayed?
When I load the Income Statement some of the line items don’t automatically show their monthly values (the rows remain blank). The subtotals are correct - the issue is purely presentation. My workaround is to expand and collapse one of the rows and the data then appears.Is there a solution that automatically ensures all relevant data appears automatically?
Hello Pigment Community!I am looking for any documentation on the Pigment Project Management Full Suite. Are there User Guides, Videos, basically anything showing how to set it up and use if effectively?Cheers,Jack
Hi,I want to know how much AI Credits usage it takes if we build a frame since its using Modeler agent for this.Because when i looked into my usage it went quite high since yesterday with usage of Frames.Thanks
Hi everyone,I’m looking for some advice on the best architecture for a DRP model.We have around 100k Products and 11 DCs. I’m considering two options:A single Product-DC dimension containing only valid combinations. Keeping Product and DC as separate dimensions and calculating at their intersection.My initial assumption was that Pigment’s sparse engine would make the two approaches fairly similar from a calculation-density perspective. However, I’m wondering whether the higher cardinality of the Product × DC intersection could have a significant impact, especially since the DRP logic uses PREVIOUSOF().Would you recommend one approach over the other in this case? And are there any specific performance considerations I should take into account? Many thanks !
What is the cleanest formula structure to calculate a Year-over-Year (YoY) moving average across a custom rolling 12-month calendar block?
Hi,I want to go for the certification of Pro Advanced Model Builder in Pigment. Can someone guide me how can i achieve that.Thanks in advance
Hello,I would like to import data from a PowerBI Dataset - is it possible and if yes, what is the recommended way?Note: the data set combines data from Snowflake, Excel files and managed rules by another planning group and therefore I want to leverage on this, rather than replicate.ThanksRemi.
Hi,I have been facing an issue with my view recently. I created a view with metrics in rows and month in columns and have used pigment Add calculated item feature to calculate yoy for every month ,yoy variance and variance %. The issue is next to it is a Total column appearing which i dent want in my view and i am unable remove it.What i did so farL-1. In the aggregator panel rmeoved the month total2. Right click on total and clicked on hide month total3. No show value as calculation addedshow every subtotal toggle is already disabledPlease let me know what i am doing wrong or missing something
Hello,Is in the roadmap the possibility to create data import configurations automatically (https://kb.pigment.com/docs/connect-google-bigquery#load-bigquery-data-into-pigment), for example through an API or by syncing with a file in a repository? At the moment these are set up manually, and we would like to understand what automation options exist to govern what is accessible and configurable in Pigment.Best,António
Hi, I am running into a blocker here.Doing an import starting from a file, it wont let me select multiple times the month columns (though the other columns work just fine...)I am quite sure this error does not show up in previous TL lists imports I did in the past.Any guess ?
Is there a way to use the “Add a comment” feature in a Board that is used within a Sequence?The feature works well when using the Board directly, but it is not available when the same Board is used within a Sequence.I tested the same Board both within a Sequence and outside of a Sequence. The “Add a comment” feature works correctly when the Board is used outside of a Sequence, but not when it is used within a Sequence. Therefore, this does not seem to be a permissions issue.Could you please let me know if there is a solution or workaround to enable this functionality within a Sequence?Thank you in advance for your help.
We have several transaction list properties with formulas that are now timing out and we are concerned we have hit a ceiling.The transaction list is just over 6 Million rows and over 60 properties, many of which are calculations. The formula is a simple as i can make it. ifblank('Opp Trx'.OWNER_ID.GLOBAL_DIVISION, 'Global Division'."No Segment") Is the transaction list simply too big or is there a more efficient formula to be used?
Hello everyone , I have a question please Where can I find my Pigment MCP Server URL ?Thank you in advance
We are experiencing that if we save a copy of a Google Sheet with Pigment Connector connections, we lose the connections in the copied sheet. We just want to double-check if there's a way to maintain connections in a copied sheet or is it perhaps on the radar to be supported in the future? Thank you!
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.
