Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Help with Cube Measures

Author  Topic  tjerkins Starting Member 1 Post Posted - 2006-06-26 : 12:47:50 I'm relatively new to AS but have managed to get a data mart, dimensions and cubes up and running in AS 2005 (SP1). I'm having difficulty trying to do something seemingly easy with respect to measures. One of my dimensions is Accounts. I have about 7 additional dimensions including Time. I have 5 measures. One of these measures is heavily used most all of the time. I need to filter this measure by the Account dimension to include only measures >= <defined_number>. The other measures should reflect this change also, but I also need to analyze other dimensions with or without the Accounts dimension in the crosstab. I need this to be put in the aggregations, not a temporary dynamic calculation. Aside from doing this at the database level, is their a way to do this in AS either with a calculated member, named calculation or other? I've been trying for a few days but just can't seem to get it. Please, any help would be great. -Troy