but the question is i need the percentage on the set -- the parent of current
member in region dimension and all deliqs in the delinquency dimension.

the formula calculates the percentage on the total number for the same deliq
but all regions...

"Deepak Puri" wrote:

Can you give some examples of the results you want versus what you're
getting - not sure I fully follow your point?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

thanks a lot. i have figured out by using your syntax.

by the way, since i'm pretty new in OLAP,co you have any book or website to
recommand? thanks again.

"Deepak Puri" wrote:

You can see this link, which lists MDX books as well:

http://www.mosha.com/msolap/index.htm


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!