1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| SCOPE ([Measures].[Montant], [CompteRubrique].[Compte Rubrique].[Compte Rubrique].members);
If (NOT IsEmpty([Measures].[Montant])
and [CompteRubrique].[Compte Rubrique].currentmember.PROPERTIES("Rubrique Règle") = "debit"
AND [Measures].[Montant] > 0 ) then
This = 0
End If;
If (NOT IsEmpty([Measures].[Montant])
and [CompteRubrique].[Compte Rubrique].currentmember.PROPERTIES("Rubrique Règle") = "credit"
AND [Measures].[Montant] < 0) then
This = 0
End If;
END SCOPE;
create member [Priv Montant] as
sum(
exists([CompteRubrique].[Compte Rubrique].children,
[Rubrique].[Rubrique Id].currentmember),
[Measures].[Montant]),
VISIBLE = 0;
SCOPE ([Measures].[Montant],[Rubrique].[Rubrique Id].[Rubrique Id].members, [CompteRubrique].[Compte Rubrique].[All]);
This = [Priv Montant];
END SCOPE |
Partager