Hello all / Hallo ihr alle,

I have the impression that this question was asked before, but the answers I found do not seem to fit my problem completely

___________________________________

Let's consider the following cube:

Period: Period 1, Period 2, ... , Period 12

View of the data: YTD or Periodic

Measures: "Cumulative" attribute set to 0 or 1

Using a rule, I would like to calculate a YTD for the measures that have 1 as an attribute, and the periodic value for measures that have a 0. Example:

'Sales' has a 1 as cumulative attribute:

Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6

100 110 100 110 130 125

Those are Periodic values. That means that Period 6 / YTD / Sales = 675

Now let's consider an 'Employees State' measure (with a 0 as cumulative attrib):

Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6

20 21 30 28 30 29

Of course Period 6 / YTD / Employees State is not the sum of all the 6 periods, but the Period 6 number, ie 29.

In my rule, I already managed the attribute part, but I do not have a clue with the calculation rule. Is this possible in Palo or not ?

Please apologize for the length of this email.

Thanks in advance ! / Vielen Dank vorab!

laloune

I have the impression that this question was asked before, but the answers I found do not seem to fit my problem completely

___________________________________

Let's consider the following cube:

Period: Period 1, Period 2, ... , Period 12

View of the data: YTD or Periodic

Measures: "Cumulative" attribute set to 0 or 1

Using a rule, I would like to calculate a YTD for the measures that have 1 as an attribute, and the periodic value for measures that have a 0. Example:

'Sales' has a 1 as cumulative attribute:

Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6

100 110 100 110 130 125

Those are Periodic values. That means that Period 6 / YTD / Sales = 675

Now let's consider an 'Employees State' measure (with a 0 as cumulative attrib):

Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6

20 21 30 28 30 29

Of course Period 6 / YTD / Employees State is not the sum of all the 6 periods, but the Period 6 number, ie 29.

In my rule, I already managed the attribute part, but I do not have a clue with the calculation rule. Is this possible in Palo or not ?

Please apologize for the length of this email.

Thanks in advance ! / Vielen Dank vorab!

laloune

laloune

*Post hoc, non est propter hoc*The post was edited 1 time, last by laloune ().