[SOLVED] "Measurement unit" member consolidation problem
Posted: Mon Mar 14, 2011 12:51 pm
Hi,
using TM1 v9.5 on Windows I have four dimensions:
- measure (value and quantity members),
- measurement unit (kg, ton, m, m2, piece members),
- buyer and
- product.
I have a consolidation problem at top member "Measurement unit". "Measurement unit" member should be consolidated according to measure member. If measure is Value then "Measurement unit" should be sum of children of "Measurement unit". If measure is Quantity then "Measurement unit" should have no value (probably zero).
How to write a rule for "Measurement unit" member?
P.S. To simplify sample I have omitted buyer and product dimension in attached picture.
Regards
using TM1 v9.5 on Windows I have four dimensions:
- measure (value and quantity members),
- measurement unit (kg, ton, m, m2, piece members),
- buyer and
- product.
I have a consolidation problem at top member "Measurement unit". "Measurement unit" member should be consolidated according to measure member. If measure is Value then "Measurement unit" should be sum of children of "Measurement unit". If measure is Quantity then "Measurement unit" should have no value (probably zero).
How to write a rule for "Measurement unit" member?
P.S. To simplify sample I have omitted buyer and product dimension in attached picture.
Regards