- - Search Insider Guides
  - Insider Guides
  - Technical tips75
Knowledge Base
Academy
Events
Groups

Create post
Login

Welcome to the Pigment Community!

Start Here!

Get oriented, explore resources, learn, and connect with others

Find an Answer

Ask a question and find answers from other users in the Pigment community

Explore Pigment AI

Learn all about Pigment's latest AI features and best practices.

Discover Tips and Tricks

Insider guides and best practices from the Pigment team

Submit a Product Idea

Share your ideas for improving Pigment directly with our product team

Customer Success Hub

Your success toolkit, curated by the Customer Success team

Featured topics

Getting Started with the Modeler Agent: Prompting Playbook

The Modeler Agent is at its best when you provide context, a clear goal, and a defined output format. When you nail the prompt, it doesn’t just save t...

Forum|Forum|3 months ago

7140

Prompting the Pigment MCP Server connection

Forum|Forum|3 months ago

3390

Architectural Foundations: Dimensions, Sparsity, Scale and the Discipline of Scope

Forum|Forum|2 months ago

3300

Explore the Community

Recently Active
Help Others
Categories

W

William SeathAuthor

Questions & Conversations

Automate refresh of data in the Excel Add-in

Hello,I would like to schedule/automate the refresh of Pigment data in my Excel using the add-in, is there a callable function I can use in VBA to do this? Any ways that people have automated the refresh I would love to hear about.Thanks, Will

121

J

2 hours ago

Isabella Leslie-MillerCommunity Manager

Questions & Conversations

Top Questions of the Month - June

Month after month, Pigmenauts share challenges, ideas, and solutions that help us all learn and grow together.To celebrate this knowledge sharing, here are June’s top 5 questions. We’re highlighting the ones that sparked the most interest and views f

30

5 hours ago

Y

YounesZApprentice Author

Questions & Conversations

Linear programming

Hello everyone,Is there a feature in Pigment similar to the Solver in Excel that involves solving equations based on many inputs and conditions to maximize or minimize an objective?Regards,

6745

P

1 day ago

ChrisAHeathcoteWallflower

Questions & Conversations

Building a list from a metric

Hi All, I would like to create a process where I build out a new list/add new list items from a metric.It is possible to build new lists from list properties but can this be done by a metric?If so, how?Chris

geoff_chovazAuthor

Questions & Conversations

Data Slices - on new metrics that don't exist in previous snapshots

We are trying to use Data Slices to do variance comparisons between versions, where some versions live in the live environment, but some versions live in snapshots. We have created new metrics (formula based) in the live environment that we want to d

Silas KIKIApprentice Author

Questions & Conversations

Single-month page selector with dynamic Prior Year + Variance columns

Hi community,I'm building a monthly P&L view on a Table block and I'm trying to achieve the following layout: The user selects one month (e.g. Dec 25) via a page selector, and the view dynamically shows:- The value for that month- The value for

jjungerheldApprentice Author

Questions & Conversations

Headcount Reporting with Variances

Hello, very new to Pigment. I am looking to create a table that shows headcount for CY MTD Act, MTD Bud, MTD PY, Var Act CY MTD vs MTD Bud, Var Act CY MTD vs MTD PY. Then repeat everything for Dec 2026 (compare to Dec Bud and Dec 2025). Looking for a

511

G

15 days ago

ChrisAHeathcoteWallflower

Questions & Conversations

Mapping into a metric

Hi,Id like to take data from a source metric dimensioned by month, GL, department and project and map this into a P&L line item metric dimensioned by month. However, as mapping metrics must be formatted by the dimension of the target what Im unsu

1684

16 days ago

R

remi fApprentice Author

Questions & Conversations

Date setting in Microsoft edge

Hello, I have set up my Edge browser to English (not English US) and the dates are still displaying with MM/DD/YYYY format.. how to change it?Anybody facing this challenge? Thanks for the supportRemi.

241

16 days ago

Brian MondelloApprentice Author

Questions & Conversations

ISFIRSTOCCURRENCE formula for dimension creation

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 e

William SeathAuthor

Questions & Conversations

Automate refresh of data in the Excel Add-in

Hello,I would like to schedule/automate the refresh of Pigment data in my Excel using the add-in, is there a callable function I can use in VBA to do this? Any ways that people have automated the refresh I would love to hear about.Thanks, Will

121

J

2 hours ago

ChrisAHeathcoteWallflower

Questions & Conversations

Building a list from a metric

Hi All, I would like to create a process where I build out a new list/add new list items from a metric.It is possible to build new lists from list properties but can this be done by a metric?If so, how?Chris

geoff_chovazAuthor

Questions & Conversations

Data Slices - on new metrics that don't exist in previous snapshots

We are trying to use Data Slices to do variance comparisons between versions, where some versions live in the live environment, but some versions live in snapshots. We have created new metrics (formula based) in the live environment that we want to d

Silas KIKIApprentice Author

Questions & Conversations

Single-month page selector with dynamic Prior Year + Variance columns

Hi community,I'm building a monthly P&L view on a Table block and I'm trying to achieve the following layout: The user selects one month (e.g. Dec 25) via a page selector, and the view dynamically shows:- The value for that month- The value for

Justin.AlpertApprentice Author

Questions & Conversations

Merging Scenarios Cleanly

Does anybody have any advice on on managing the migration of scenario changes back into default plan in a clean way?In other EPMs, multiple scenarios get spun up, different changes are made in each, and then those changes can be cleanly merged back i

NiklasApprentice Author

Questions & Conversations

Audit/History For Exports via API Key

Hi Pigment Community,Is there a way to see information about data exports performed via an API export key?For imports, Pigment provides good traceability: when using an API import key, the application shows which assigned user performed the import (e

Guillaume Langlois DTTEAuthor

Questions & Conversations

Automatic generation of multi-entity reporting packs consolidated into one PowerPoint

The requirement is to automatically publish a reporting pack in PowerPoint. This reporting pack must be generated identically for multiple entities. All packs must be consolidated into a single PowerPoint file.

THAddeparApprentice Author

Questions & Conversations

Easiest way to copy a model into a new application

Hi everyone! I’m looking to move a specific set of Metrics and Tables from "App A" to "App B" without rebuilding them from scratch.My current plan is: Duplicate App A. Share necessary Dimensions/Lists from the original App A to the duplicate. Del

JOEL_FApprentice Author

North America Community Group

Linear Application MCP

We are looking at integrating the Linear App with Pigment via MCP or a Connector. I see there is no Linear Connector at this time, can we do if with MCP, we currently have one MCP integration set up but I don’t see the option to add another.

MKSMPBAuthor

Questions & Conversations

Budget comparison table with Snapshots

I want a table that has costs actual ytd, costs budgeted ytd, costs ytd variance, costs full year budget, and costs YTG (i.e. total year budget less actuals YTD).However, my budget is captured as a scenario snapshot. Is this possible?

1911

G