dbTalk Databases Forums  

Calc members (in 'account' dimension)!

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Calc members (in 'account' dimension)! in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Massi
 
Posts: n/a

Default Calc members (in 'account' dimension)! - 07-16-2003 , 11:58 AM






Hi to all,
how can I create a member, in the dimension "account", that is the sum of
all elements (of the same dimension) which property "taxes" is set to "y"?

thanks in advance

Massimo



Reply With Quote
  #2  
Old   
Dave Shroyer
 
Posts: n/a

Default Calc members (in 'account' dimension)! - 07-16-2003 , 01:39 PM






I believe you will want to tag all of the leaf level
members with the member property and then use this
formula. It will sum all of the members with a member
property of 1 in the "taxes" member property.

SUM({FILTER([Account].[Account Leaf Level].members,
[Account].currentmember.properties("taxes") = "1")},
[Measures].[Cases])


Good Luck

Quote:
-----Original Message-----
Hi to all,
how can I create a member, in the dimension "account",
that is the sum of
all elements (of the same dimension) which
property "taxes" is set to "y"?

thanks in advance

Massimo


.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.