Skip to main content
Member
Sep 10, 2026 3:17 PM UTC
Solved

Derivative rule not working on time dimension

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

Member
Sep 12, 2026 4:22 PM UTC

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

2 replies

Member
Sep 12, 2026 4:22 PM UTC

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
Sep 14, 2026 8:06 AM UTC

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