Questions & Conversations

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 am building an app that reports on data with varying time lengths. So a user may want to see their boards either quarterly, half -yearly or yearly. Quarter, half year and yearly are all dimensions within our Pigment Datahub, and they have defined relationships between them i.e. Month → Quarter → Half year → Year are all connected to each other. Currently all three dimensions are used as selectors on my boards:But I want a user to be able to land on a “Time Period Selector” board and: Choose either the Quarterly, Half Yearly or Yearly reporting frequency  The chosen dimension (conditional on what the user has selected) is then the only available selector throughout all the other boards in the report, rather than having all three dimensions available as selectorsI have mocked up a “Period Selector” board to show what I am looking for. It uses a dummy dimension called “Time View” which has the list items Quarterly, Half-Yearly and Annually, it is not currently connected to the Qu

Hi - could someone please share some best practices for setting up waterfall charts?I’m trying to create a bridge: Starting Headcount, New Hires, Terminations, Ending HeadcountQuestion 1: does the formula in Ending Headcount have to be “Starting Headcount + New Hires + Terminations”? It seems like yes if I want to create a Contribution Waterfall Chart. In this scenario I’d have to create an Iterative Calculation and use the “PreviousOf” function for the starting headcount, right? Or is there a better way?Question 2: Is there a way to make the periods that are shown in the chart dynamic based on the page selectors? We’d like our users to be able to select which months to see. For example, if they select June and September, they should see a waterfall with June Starting Headcount, all New Hires and Terminations for June/July/August/September, and then Ending Headcount for September. Is this possible?Question 3: is there a reason I can’t control the Aggregator Settings in the chart? This

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 hierarchies for cost centers, profit centers or products. Those can have many levels (e.g. a 10 level deep cost center hierarchy). In other solutions I would get all node and leaf items from a source system and add the respective parent in a separate hierarchy column (so I need to keep two columns maintained to have a full multi-level hierarchy). What is the equivalent of this in Pigment? Thanks everyone! *Update: my apologies, I was actually referring to parent child hierarchies. Would that change the approach?

It looks like all users are able to see all other users’ inputs in metrics dimensioned by the User list. Is there a way to restrict this? The typical access rights flow doesn’t seem to allow this

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 (in all cubes) to an archive version, e.g. 'Forecast May', which was not subject to rule calculations. This meant that 1) the system no longer had to undertake any calculations (other than addition) for the archive versions and, more importantly, 2) any subsequent formula changes would not impact the archive versions so what was reported couldn't change.One way to achieve this in Pigment is to just back-up the whole application and call it something like 'Forecast May Reporting', but this is unsatisfactory for a number of reasons: primarily as it makes it so difficult for the end-planner to find and compare data, but also due to resource usage (what happens when we have 3 years' of monthly backups?) In any case, having the live working versio

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 the same month prior year (Dec 24)- The absolute variance (CY − LY)- The % variance ((CY − LY) / LY)What I've tried:- Calculated items with offset -12** on the Month column pivot — works great when Month is on Columns, but breaks when Month is on Pages (the page selector filters out the offset month)My question: Is there a native Pigment way to keep a single-month page selector and still show dynamic LY + variance columns? Thanks in advance!

Hi there, I would like to show Revenue by Customer by Month in a Table. Customer should be displayed as Account ID (property of Customer) and I would like to also show Account Name of Customer. Currently I am struggling to get both. I can select just one property so it is either Account ID that is being displayed or Account Name. Is there an option to show both?  

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 do variance on. But these metrics do not exist in the snapshots. Without functionality to be able to create / migrate these metrics into the snapshots I feel like the data slice functionality is not very useful from a snapshot perspective. It is not reasonable to assume that you’ll have every single metric ever needed created before you start taking snapshots. Is there anything being considered by product on how to solve this problem?

Hi, I have to build below requirement in Pigment.I want my table to display the difference between two combinations.Is this view achievable in pigment?  

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  

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,

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 

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 formula to type in the formula bar so this will happen. I worked with the AI chat and it did it for me but the the whole chart was blank

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 unsure how to go about this. In a different life I would create a list derived from the P&L line items and use this to format my mapping table but alas I dont think this is possible with Pigment. Any thoughts on how best to approach this?Thanks,

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.

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 ? 

HiWould appreciate if some one can share the GreenField BPC Implementation guide lines and the Do’s and Dont’s.ThanksGiridhar

Hi,I have created a table that contains 5 metrics out of which two are in % form using show value as %of metric feature. Thw view that i created is two versions in column and variance also. The problem that i am facing is variance for 4 metrics is coming correct except 1i.e. out of the 2-percentage based metric variance for one is coming correct but other is not though both are using same methods and individually for each version values are coming correct. Unable to find a reason why only one is inconsistent although at individual version level it is coming correct.Please let me know what i am doing wrong.Thanks in advance

Hello! I dropped in a table into another application, and somehow the scenarios are not available to choose. Is there anything I need to toggle on? Thanks for checking! Scenarios shown in the original table: In another board page when I click Scenario: 

Hi,I have a metric named current year with year as data type and no dimension. purpose is to automatically update the current year every year. Is this possible to achieve in pigment and how?Thanks in advance

Hi,I am create a P&L where I have the GL rolling up into a P&L line which then rolls up into a P&L category.However, the GL rolls up nicely into the line item but Im struggling to get the line items to roll into the category. Im using metrics to populate my line items rows and dimensions for GL and Category -  In the screen shot I want the GL 60110 to roll up to Core Processing and for this to roll up to Revenue.  But instead it simply duplicates the Core Processing line.Here are the summary settings - The metrics feeding this table are dimensioned by P&L Line Item (as a dimension), P&L Line item category (property of P&L Line Item) and GLI have mapped GL level data to a line item in a dimension and then mapped this to the individual metrics so I can present it in a table. Please explain how I might be able to achieve what Im looking for.

Hi everyone, I’m trying to export a template from a Pigment table. Right now, the export only shows the headers (Account, Month, Property, Version, Amount) and no rows underneath. I want the full structure to export, including all account rows and combinations, but with blank amount values. Does anyone know how to do this?