Hi,

Does anybody can help me in making running total across time dimension
in PowerCube? There is that option in Cognos Architect, but it doesnt'
work for Transformer.

I want to make a variable that shows a number of subjects in the end
of each month. There are incoming and outgoing subjects and the state
at the EOM is the sum of all observations but taking into account the
state in the beginning of this month... How can I do it in PowerCube?

Thanks in advance for any help.

Hello,
do you mean a kind of counting new/old customers for each months?

If so, I think it's not so heavy.
You have to create at least two dimensions and one measure in the
Transformer model.
One of the two dimensions (variables) will be a "date dimension".
The measure will be the counter.
The counter could be extract from the datasources (in general the
number of rows..) or a column calculated by the model, or you can use
the "Category count" associated to this measure.

The result should be a cube that shows the number of subjects (p.e.
new customers) in a period (quarter, year, etcc) for a geographical
area and so on...

Reply to me, If this not helps or I misunderstanding the issue.

Are you expert in SAS tool or in statistical problem? You talk about
observations and variables...

Regards,
Giuseppe