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.
| Author |
Topic |
|
v-migreen
Starting Member
1 Post |
 Posted - 2007-09-12 : 16:09:08
|
| Hi,I'm new to SSAS and MDX and have what I hope is a basic problem:I have a number of measures (all with the same prefix in their name if that is helpful) that I want to use as part of an average calculation. I know I can create individual calculated measures for each one of them, but there are about 100. Is there any way to create a calculated cell that has the functionality to recognize these measures (ie. IF measure like 'prefix%' THEN) and more importantly use something like CurrentMember to apply the average calculation to any of these measures depending on what is selected?In other words, I want to have one calculation that will work for all 100 of my measures vs. 100 individual calculations.I'm using SQL Server 2005.Any help would be appreciated.Thanks,Mike |
|
|
|
|
|
Calculated Cells