Skip to main content

Unanswered questions

20
M
Budding Pigmenteer
MaxenceGoigBudding Pigmenteer
 Questions & Conversations
How to check if each active customer received an invoice this month?

Hi everyone,I’m trying to determine whether each active customer received their invoice for each month.I have two tables, both having the dimensions month and customer ID: An "Activity" table, which has one row per customer per month, indicating whether the customer was active. If the client was not active on a specific month, he will just not appear in the table for this month An "Invoices" table, which lists all the invoices sent. Thanks in advance for your help!

676
M
Budding Pigmenteer
Y
Newly Minted Pigmenteer
yacine.ibouricheneNewly Minted Pigmenteer
 Questions & Conversations
From "Month" to "Year" aggregation issue

Hello Everyone ! I have created a metric which will calculate a simple EBITDA/Net Sales ratio, which is as followed:I want to be able to switch to a yearly view easily. The issue is that when I pivot the table to show yearly data, it aggregates all the months instead of displaying the ratio between yearly EBITDA and yearly Net Sales. I need it to show the correct yearly ratio, not just a sum of monthly values. Is there a way to prevent aggregation and ensure that the metric correctly calculates the yearly ratio ? I want to ensure it’s possible to switch views while keeping the same metric. Ultimately, the goal is to use this metric in a board and apply a page selector to display the desired month as a KPI..Thank you by advance for your help 🙂Yacine

193
Y
Newly Minted Pigmenteer
sudhakar
Newly Minted Pigmenteer
sudhakarNewly Minted Pigmenteer
 Questions & Conversations
Is there a filter during import configuration

I have source files to build dimension lists like Territory and Product with hierarchical relationships which have hierarchy level column. I want to build Territory and product dimension lists by importing the respective files and filter by lowest hierarchy level (a number that show the level) during import definition. Is it possible?For example I have a product file with below columns, I want to load Products that are equal to Hier Level ‘3’. 

281
Luiza
Employee
K
Newly Minted Pigmenteer
Karin TauberNewly Minted Pigmenteer
 Questions & Conversations
Pro Training - 5. core Reporting PnL_Account 6001

Hi,as part of the fifth section of the Pro Training, I need to Allocate all values of  Workforce Cost Plan → to PnL_Account 6001. What is missing in my formula?Workforce_Cost_Plan_Output[ADD CONSTANT: PnL_Account."6001"] keep getting an error:“Error: Syntax error: cannot validate formula” Thanks in advance    

60
K
Newly Minted Pigmenteer
Bas
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
 Questions & Conversations
Joining two dimension lists into one?

Hi everybody,I have two dimension lists: one for my P&L accounts and one for my balance sheet accounts. Both of them are updated with new accounts once they appear in the P&L transaction list or the balance sheet transaction list. For reporting purposes, I want to create a single chart of accounts dimension list that contains all the items from the P&L and balance sheet dimensions lists. Is there are way to combine both dimension lists into one and to do that in such a way that it automatically updates once a new P&L or balance sheet account appears in either of the two transaction lists? By the way; both dimension lists currently do not share the same properties. So I would simply be looking to combine the unique values/dimensions from each list and append them together as a new total chart of account list.Thanks for helping me out :)Best, Bas

272
F
H
Just Arrived
HuyenJust Arrived
 Questions & Conversations
Connect Pigmet with Sage100

Hello,I’m just a beginner, and currently, my company uses the Sage 100 software, with data stored in an on-premise SQL Server. We also use the Sage BI Reporting tool to query the data in Excel.My question is: how can we directly connect to the Sage accounting data?Thanks a lot!

131
M
Employee
K
Budding Pigmenteer
keerthanarameshBudding Pigmenteer
 Questions & Conversations
Create dimension list from another dimension list property

I have a dimension text property with a list of items. I want this list to be populated as a new dimension list. I used a concatenate in this property to get a new text item and I want this new text to be converted into a dimension. How can I do this with the help of formula?

412
Benoit
Community Manager
Bas
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
 Questions & Conversations
Excel connector doesn't recognize named cells

Hello,I'm experiencing some issues with pushing data to Pigment from Excel. I have a simple dimension list (800+ items with about 4 dimension properties) that I would like to periodically update from Excel. I exported the current dimension list to .csv and used that .csv to setup an import configuration in Pigment. Then I pasted the .csv in Excel and updated the 4 dimension properties. I then named the data range in Excel but when I try to configure a push connection it doesn't recognize the named cells (“no names defined”).Also, when I try to input the cell ranges manually (A1 → G800) and then push the data to the dimension block in Pigment, the import fails (headers are not found...). Any help is appreciated. Thanks!Bas

151
M
Employee
Bas
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
 Questions & Conversations
Index versus LYTD shows only blanks

Hello,I have one table that has a number of calculated items in them. In the order of events: first the YTD value is calculated using cumulate (works fine). Secondly, the index versus budget is calculated (works fine for YTD) and lastly the index versus LY is calculated (that one goes wrong for YTD (only blanks). The strange thing is, is that that ratio versus LY does work fine when calculated over the month, but it shows blanks when calculated over YTD.Below are snapshots of my calculated items. Can anybody see why the index versus LYTD would return blank values?Thanks, Bas  

141
M
Employee
Artsemi
Newly Minted Pigmenteer
Artsemi
 Questions & Conversations
User cannot access pigment error 400 login failed

Hello. Has anyone encountered this issue before? Our user cannot access Pigment with error: 400 Login failed. User was added to Pigment long time ago, last login was 3 month ago. 

443
J
Employee
V
Budding Pigmenteer
venitiavBudding Pigmenteer
 Questions & Conversations
Sort by subtotal

Hello,I’m trying to sort by subtotal but I don’t succeed, can you please help ? I have a metric (grid) with 2 dimensions in my columns. I would like to sort by descending value order for the 1st dimension of my column, i’m unable to do that. Do you have any idea how to do it please ? Thanks 

222
V
Budding Pigmenteer
jt.victor
Newly Minted Pigmenteer
jt.victorNewly Minted Pigmenteer
 Questions & Conversations
Appending two time dimension metrics

Hi,I have two metrics with the same data type: dimension (Month) and the dimension structure for both is the same. The concept is that I have deadlines for different dimension items. I was to append these two metrics because one is the prior forecast deadlines and the other metric is the current forecast deadlines. I want the new metric to have both.  When I do metric1 + metric2 i get this error:“Arithmetic operators only accepts same type arithmetic inputs after implicit casting, received Dimension (Month) operands” Please help! Thank you! 

472
Nathan
Employee
K
Just Arrived
KentiaJust Arrived
 Questions & Conversations
Freeze columns or rows in a table

hello,I’d like to freeze some columns in a table so that they stay visible while scrolling. Is it possible ?

311
F
Employee
A
Budding Pigmenteer
AlinaBudding Pigmenteer
 Questions & Conversations
Sorting values in table with multiple dims

Hi community, I need to sort the values in the table from high to low but I need to pivot it to pivot x dims in columns (e.g. Country, Client, Opportunity). If I use the traditional Sorting function of Pigment, it will sort only within the last dimension (in my case Opportunity).Is there a way to sort values disregarding dimensions but still keep them in my pivot?Thanks!

623
Ola
Seasoned Pigmenteer
G
Newly Minted Pigmenteer
geoff_chovazNewly Minted Pigmenteer
 Questions & Conversations
Issue with (unwanted) date conversion in CSV import

I have a CSV file with a column indicating  the month dimension. It is “Jan 25”, “Feb 25”, etc. On the initial import screen it looks correct,however, as soon as I map it to the Pigment property (Month dimension type) it shows in the preview as My imported data is all loaded into the wrong months. I want it to just take the exact value in my CSV as the name for the Month dimension instead of converting a date. I tried double-quoting the field in the CSV, that didn’t help. Loading it into a regular text property works fine so it doesn’t appear to be an issue with the source data itself.  

342
G
Newly Minted Pigmenteer
sudhakar
Newly Minted Pigmenteer
sudhakarNewly Minted Pigmenteer
 Questions & Conversations
Sequence of modifiers to be followed in a complex formula

Hello,As I start my pigment training and work through the formula exercises, I have a question regarding the order of using multiple modifiers within a single formula.I’ve read that the sequence is important when combining BY and FILTER. In the same way, are there any best practices or modeling guidelines that affect performance or functionality when using several modifiers and operators together in random sequence, such as BY, BY->, Select, Filter, Add, Remove, or Exclude?Below is one example from the formula exercises (it may be a simple formula but I am thinking about what sequence to follow for complex formulae):'EE_Calc_MonthlySalary_+increase'[BY SUM: -> EE_Data_Stand.Area][by: 'GL Account'."11100"][remove sum: Employee][by :-> MAP_Datatype] Thanks

392
sudhakar
Newly Minted Pigmenteer
sudhakar
Newly Minted Pigmenteer
sudhakarNewly Minted Pigmenteer
 Questions & Conversations
What is the best practice for using BY modifier with Allocation method, BY CONSTANT vs BY?

Hello-As I begin pigment training and work through the formula exercises, I’ve noticed that while CONSTANT is the default allocation method, I often omit it, assuming it will apply automatically. However, the post-exercise walkthroughs consistently include it explicitly.Is there an advantage to always specifying CONSTANT (for allocation) or SUM (for aggregation), even when they’re defaults?Thanks,Sudhakar

431
Stef
Employee
K
Just Arrived
Kelvin ChanJust Arrived
 Questions & Conversations
Tracking Headcount Changes

Hello Everyone,I’m trying to build a validation process for headcount planning where I can track if a team member’s salary/cost center/class change vs the last load month. We currently load our data daily and each load will replace the previous load within the same month, so we would be comparing the difference vs the last load month. My intention is just to build a board that notifies us when changes happen and I don’t need to create a whole process of validation before these changes runs through to the forecast. Any help would be appreciated. Thank you!

241
Nathan
Employee
F
Newly Minted Pigmenteer
FranckLPNewly Minted Pigmenteer
 Questions & Conversations
Include ratio calculationbased on multiple dimensions

Hello,I have a metric that shows the P&L.I’ve been asked to add multiple ratios like % of GM / Revenue or % Contributive Margin / Revenue. The issue is that the accounts are not on the same dimension (revenue is Account lvl 2 and Gross Margin is Account lvl 3).What is the easyest way to add those ratio. Do I need to create a specific metric just for them or can I do the calculation directly in my metric ?

292
F
Employee
M
Just Arrived
Max.PJust Arrived
 Questions & Conversations
How to add more than two items to a calculated item

Hello, I am trying to create a calculated item to sum values from countries into a region. However, I only see the option to combine Item A and Item B… is there a way to insert more Items (e.g. Item C) in Pigment? Thank you!

551
K
Employee

Badge winners

  • Pigment Modeling Fundamentals Certified
    Mehdi ELAZRI ENNASSIRIhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    Antoine Janinhas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    Seney SEANhas earned the badge Read and Interpret Formulas Certified
  • Rare Author
    Benoithas earned the badge Rare Author
  • Pigment Like a Pro
    SylvainKPhas earned the badge Pigment Like a Pro
Show all badges
Terms & ConditionsCookie settings