Skip to main content
Question

Metric to metric import for a single dimension item

  • December 1, 2025
  • 2 replies
  • 21 views
Bas
Master Author
Forum|alt.badge.img+5
  • BasMaster Author
  • Master Author

Hello,

I have a question. Hope you guys can help me out. I have a metric dimensioned on week, business unit and version. This is calculated from a TL that is being continually and automatically updated from the source system. 

However, I would like to ‘freeze’ this data for specific versions. For instance, at this moment in time I would like to freeze the metric for the budget 2026. Later on (in a couple of months) I want to freeze the data for the first forecast of 2026 (but leaving the data for budget 2026 untouched of course). 

I was thinking along the lines of using a M2M import, but I can't seem to work out a scalable solution on how to import only item A and not item B of the same dimension. 

Maybe using data access rights? 

Thanks for your help.

Best, Bas

 

2 replies

Bas
Master Author
Forum|alt.badge.img+5
  • BasMaster Author
  • Author
  • Master Author
  • December 1, 2025

Hi everybody,

While typing the question above I added the afterthought of using data access rights. I just tried that and that seems to work.

So apologies - but it seems to be resolved already :)

Best, Bas

 

Luiza
Employee
Forum|alt.badge.img+1
  • LuizaEmployee
  • Employee
  • December 3, 2025

Hi Bas,

Thank you for your question!

You probably want to look into Snapshots as well. Since your metric is automatically updated from a Transaction List, this is the best practice as it will create a dedicated block (or metric) that copies the live metric only when you trigger the snapshot.

You then freeze the value for a specific Version while other versions continue to update automatically. 

Here’s some documentation that can be helpful:
https://kb.pigment.com/docs/application-snapshots
We’re available if you have any questions.

Best,

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement