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 |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2005-03-15 : 01:38:26
|
| Hi,I am using Microsoft Data Analyzer and am using one of the "pre-built" MDX (offered by Data Analyzer) to find the %age.The MDX statement for %age looks like below in Data Analyzer:Length measure/sum(Members in filter for current dimension,Length measure)*100I am trying to instead use a calculated measure on the server (for %age) rather than using Data Analyzer's solution - which is working fine and giving correct results but is slow.Assuming that my Length measure is based on a measure called 'TotalSales' how do I convert the rest of the MDX; especially the following part:"SUM(Members in filter for current dimension,Length measure)"so that I can define a calculated members on my cube.I hope my post is clear and will be very grateful for your help.Many TIA. |
|
|
|
|
|
MDX help request for making a calculated member