Skip to main content

- - 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

Career Spotlight - Min Li

Introduction:Hello Pigmenteers! I’m Min Li (@Min Li in the community). I currently work at Juniper Square, a platform for private markets investment...

Forum|Forum|19 days ago

1152

Getting Started with the Modeler Agent: Prompting Playbook

Forum|Forum|5 months ago

9070

Prompting the Pigment MCP Server connection

Forum|Forum|5 months ago

4900

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

Forum|Forum|4 months ago

4970

Explore the Community

Recently Active
Help Others
Categories

tgilbertMaster Author

Questions & Conversations

Version Clone Duration

We use a rolling forecast and when we create new forecast versions we need to clone them from a previous forecast as a starting point. These clones can take close to 1 hour, which really delays our process.Is there any advice for speeding up the clon

johnturnerApprentice Author

Questions & Conversations

Do table calculations have to apply to all metrics in that table?

I have a table with Month and a YTD calculated item in the columns and five metrics in the rows. Four of the metrics are financial. The fifth is headcount.As my YTD calculation applies across all metrics, my heads are adding up rather than showing t

Sander BooijApprentice Author

Questions & Conversations

Combining a cumulate (YTD) metric with an Offset vs LY metric

Good afternoon! I have a question whichs regards the combination of two measures within a P&L setting.First measure: A Year To Date cumulative calculated item. Sums all the values of a line item in the P&L untill the most recent period, with

Isabella Leslie-MillerCommunity Manager

Welcome to the Community!

Pigment Community Guidelines

Pigment Community Guidelines

Welcome to the Pigment Community! We are so happy to have you here! 👋We are here to create a space where Pigment users can share knowledge, learn, collaborate, and connect with one another. These Community Guidelines should not only help you understa

johnturnerApprentice Author

Questions & Conversations

How do I archive data within metrics?

When I lived in TM1 World, we would always build our 'cubes' (metrics) such that the 'rules' (formulae) ONLY applied to a SINGLE 'working version'. Then, when a forecast was signed off, we would run a process to copy data from this working version (i

Nancy MehrotraAuthor

Questions & Conversations

Export a viw as csv

Hi,I am trying to export a view as csv via APOP, but my view is coming weird in Target Sheet. It is just showing Row Headers and that too with dimension name instead of dimension items. When i download that as csv it shows correct but while exporting

Adélaïde B.Apprentice Author

Questions & Conversations

Issue with Excel add-in

Hi !We are using the pigment connector to Excel. I have multiple questions :Is it possible to connect different sheets to different workspaces in pigment within the same excel file ? So far, we had errors where we couldn’t connect the file to anythin

JF.LMApprentice Author

France Community Group

Creating New List Items from a Transaction List

Hello everyone,I need to automatically create new list items from a Transaction List.Specifically, I need to add items to a list using a Transaction List because, unfortunately, I am unable to create them upstream.I tested importing a list from the T

Charlie PartingtonApprentice Author

Questions & Conversations

Google Sheet Connector - Moves Manual Content

Hi everyone,I’m running into an issue with the Pigment Google Sheets Connector shifting existing formulas in adjacent columns during data syncs.The Setup: I configured the Pigment Connector to start exporting data at cell B1 (leaving Column A open).

Catalina IbarraCommunity Manager

Career Spotlight - Min Li

Career Spotlight - Min Li

Introduction:Hello Pigmenteers! I’m Min Li (@Min Li in the community). I currently work at Juniper Square, a platform for private markets investment. I am a Finance Systems Manager based in Green Bay, Wisconsin.My main focus is leading our Pigment

tgilbertMaster Author

Questions & Conversations

Version Clone Duration

We use a rolling forecast and when we create new forecast versions we need to clone them from a previous forecast as a starting point. These clones can take close to 1 hour, which really delays our process.Is there any advice for speeding up the clon

TELIT002Wallflower

Questions & Conversations

How to set up level-based hierarchies (e.g. cost center, profit center, products)

Hi there, I haven’t really found something related to this topic, hence this new one. I am fairly new to Pigment and have been working heavily with other planning solutions so far. What I see in every project is the need to easily set up parent-child

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

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.

TomHalasaApprentice 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?

AlinaMaster Author

Questions & Conversations

How to set up variable and page selectors to work together

Hi community, I found the article Use Selectors to Customize Context in Views and Boards | Community (the last paragraph How Variable and Page selectors work together) and I want to do the same view for my PnL. The idea is basically the same. I want

Venkat GowthamApprentice Author

Questions & Conversations

Can we integrate Pigment with Python

Can we integrate Pigment with Python

ItishriApprentice Author

Questions & Conversations

Roadmap Question: Aggregate by Formula Functionality

Hey!I wanted to check if there are any plans to introduce a feature that allows aggregation by formula. Currently, we can aggregate metrics using options like sum or average, but what if we want to display the value calculated by a formula at all lev

Explore the Community

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

Welcome to the Community!

Welcome to the Community!

6 topics

Questions & Conversations

Questions & Conversations

1153 topics

Career Forum

96 topics

Company News

63 topics

Welcome to the Pigment Community! 🎉

3 years ago

Customer Leaderboard

Show full leaderboard

Show full leaderboard

Badge winners

ashtonallenhas earned the badge Innovator
Gabehas earned the badge Bug Hunter
Isabella Leslie-Millerhas earned the badge Magic Connoisseur
Veniaminhas earned the badge Chatterbox
Kaur Lumistehas earned the badge Bug Hunter

Show all badges

Employee Leaderboard

Show full leaderboard

Show full leaderboard

Need more help?

Contact Customer Support

Contact our Support team and we'll be happy to help you get up and running!

Contact Partner Support

Contact our Support team and we'll be happy to assist you!

Powered by Gainsight

Terms & Conditions Accessibility statement

Sign up

Already have an account? Login

Single Sign-On Need help?

Log in with your Pigment account

Log into the Pigment Community

No account yet? Create an account

Single Sign-On Need help?

Log in with your Pigment account

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview