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  SQL Server Development (2000)  mdx - calculated member

Author  Topic  Tim Starting Member 392 Posts Posted - 2001-10-23 : 01:50:22 Anyone know the MDX needed to create a calculated member (measure) as follows??? In my YAK cube there is a distinct count measure which gives the number of YAKs. I display the cube with the new calculated measure as a column and the dimension YAK-Type as rows. The calculated measure will show a percentage for each type of YAK. For example, all YAKs are made up of 60% hairy YAKs and 40% bald YAKs. Now it gets tricky when I switch dimensions to look at YAKs by habitat. I want the *same* calculated measure to show the percentage by habitat. For example 10% of YAKs live in urban areas and 90% live in the wilderness. If I put both these dimensions on the rows and columns and select the calculated measure I should be able to see the percetage of hairy yaks living in the wilderness as well as the other three combinations. I have all this to work with counts, but can't get the percentages to work. thanks for any help. (using SQL 2K Analysis Services) ------------------------------- Visit nr's cursor wonderland Edited by - tim on 10/23/2001 02:04:06