Hi all,

Does anyone have an example (VBA or MDX) that takes the values of one
dimension and basically passes them (like a where clause to another) as a
parameter?

I.e. I have a very deep geographical dimension and it takes too long to
drill down on the page axis to low levels. I'm breaking some rules of
aggregation by cutting out some levels into dimensions (like regular pivot
tables) and am hoping to have functionality that if a state is chosen in one
drop down, only the cities applicable will be availalbe in the next drop down.

Thanks in advance!

Mark

If you're using AS 2005, appropriate user hierarchies can be configured
in the geography dimension, rather than setting up separate dimensions.
The MDX Exists() function can be used to filter members that can exist
with the already-slected members:

http://msdn2.microsoft.com/en-us/lib...S,SQL.90).aspx

Returns the set of members of one set that exist with one or more tuples
of one or more other sets.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***