I am attempting to get information out of a joined fact table. Using the Food Mart Cube there is a store dimension. The zip code is not used in the Store dimension. What would a MDX query look like that would get all Zip code for a specific state from the Store dimension.

You should create a Member Property, say ZipNumber, for the Store Name level of the Store dimension, using Dimension Editor.
Then you can access that property in MDX:

with Member [Measures].[Zip] as 'store.currentmember.properties("ZipNumber")'
select
{[Measures].[zip]} on columns,
[store Name].members on rows
from Sales

You can check out these topics in BOL for more detailed info.

HTH,
--
Brian
www.geocities.com/brianaltmann/olap.html


"PCK" wrote: