Skip to Content
0
Former Member
Jan 25, 2011 at 08:31 AM

Dimension formulas+aggregate

22 Views

Hi gyus!

Have i got it right, that members that was calculated using dimension formulas can't be aggregated in time dimension.

for example

Member P_ACC1 is calculated as PACC2*PACC3

so

________  Q1    jan    feb   mar
P_ACC1    81      9     9    9
P_ACC2    9        3     3    3
P_ACC3    9        3     3    3

but i need smthng like this

_________ Q1   jan    feb   mar
P_ACC1    27      9     9    9
P_ACC2    9        3     3    3
P_ACC3    9        3     3    3

is it possible to archieve it using dimension logic?

Edited by: susersuser on Jan 25, 2011 9:31 AM