[SOLVED] "Measurement unit" member consolidation problem

[abcuser]

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

[abcuser]

Hi,
I have found out solution. In cube's rules I have written:

Code: Select all

SKIPCHECK;
['Measurement unit','Quantity']=0;

Thanks, problem solved.