Code: Select all
['DimName':{'ElmName'}] = C:0;
Can the consolidation for ‘ElmName’ can be disabled only for one particular dimension, so that it consolidates normally in other dimensions of a cube?
Code: Select all
['DimName':{'ElmName'}] = C:0;
I don't see why not. Just set the weightings of ElmName against all its ancestors in that dimension to 0.RonLat wrote:Can the consolidation for ‘ElmName’ can be disabled only for one particular dimension, so that it consolidates normally in other dimensions of a cube?
Not exactly. Strictly speaking ElmName only exists in one dimension (Dim1) and consolidates within that dimension. But nevermind that, I think I know what you mean now.RonLat wrote:Setting the weightings of ElmName against all its ancestors to 0, would prevent the consolidation of ElmName in all dimensions.
Code: Select all
['Dim1':'ElmName'] = C: IF ( ELLEV ( 'Dim3', !Dim3 ) > 0, 0, STET );