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|6 days ago

552

Getting Started with the Modeler Agent: Prompting Playbook

Forum|Forum|5 months ago

8690

Prompting the Pigment MCP Server connection

Forum|Forum|5 months ago

4640

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

Forum|Forum|4 months ago

4650

Explore the Community

Recently Active
Help Others
Categories

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

GawainEmployee

Performance in Action: Workforce and FP&A Patterns with Practical Reference

Performance in Action: Workforce and FP&A Patterns with Practical Reference

Introduction Building something that works is not enough in Pigment. The goal is to build it right and to optimise for performance from the first design decision to the last. This guide consolidates best practices from the Pigment Modeling Palette in

BenoitCommunity Manager

10 Best practices to make safe, confident changes in Pigment (even without Test & Deploy)

10 Best practices to make safe, confident changes in Pigment (even without Test & Deploy)

It’s natural to feel a bit nervous when you’re about to change a live model. You want to keep things stable for your users, but you also need to maintain or enhance your models.Even when Test & Deploy (T&D) isn’t available, you can make thoug

tgilbertMaster Author

Questions & Conversations

What is the best way to add items to a list in bulk?

I have a table dimensioned by Position and Version. Our users would like the ability to add 100+ positions at a time, but the Bulk Add to List functionality only seems to be available in the actual List itself, and cannot be enabled for a table of me

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

akostrovaApprentice Author

Questions & Conversations

Sorting Month In Page Selector

Hi,Is it possible to sort the months in a page selector in descending order (from the most recent month to the oldest)?We'd like to display all past months on the board, but have the most recent month appear at the top of the page selector. We alread

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

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

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

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

1150 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

jakeehas earned the badge Innovator
Sangita Borahas earned the badge Innovator
rhyskwaltershas earned the badge Author
AndresRodhas earned the badge Chatterbox
Givenchyhas earned the badge Innovator

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