Skip to main content
Member
September 10, 2026
Question

Derivative rule not working on time dimension

  • September 10, 2026
  • 2 replies
  • 30 views

Hi, I’m trying to run a derivative rule source - final at time dimension so that I can copy the loaded amount across 12 month.

In the source I have a Period column with the year. 

My idea is to bypass the year in one to one mapping and create 12 months using the derivative rule. 

Something like this 

 

The issue I’m facing is that the derivative is duplicating the rows but not changing the time, however I test for other dimensions and it’s working.

Has the time dimension any restriction on derivative rules?

 

Thanks

2 replies

Member
September 12, 2026

I believe the Scenario/Time/View dimensions can’t use Derivative Rules, because the Scenario/Time/View are treated differently/run before the rest of the Cube dimensions are mapped (which would trigger the Derivative Rules).  

Member
September 14, 2026

I have exactly the same reasoning… thanks. I’ve been testing to remove TR for time and the import process exits with the common error: “No Valid keys...”