>>

>>

"Markus Krenn" wrote:

> Many Thanks,
> I've tried to substitute the dimension to following mdx, but it doesnt work:
>
> with Member [Measures].[SupplierUniqueName] as
> '[Store].[Store City].currentmember.UniqueName'
>
> member [Measures].[SupplierDisplayName] as
> 'Space([Store].[Store City].Currentmember.Level.Ordinal * 4) +
> [Store].[Store City].Currentmember.Name'
>
> SELECT
> { [Measures].[SupplierUniqueName] , [Measures].[SupplierDisplayName]} on
> Columns,
> {[Measures].[Store Sales]} on rows
> FROM SALES
>
> error: unknown dimension "[Store].[Store City]"
> Whats wrong?
> Markus
>
> "johnE" wrote:
>
> > Here is the query I use which provides a nice indented list
> > <<
> > with Member [Measures].[SupplierUniqueName] as
> > '[Supplier].[SupplierSKU].currentmember.UniqueName'
> >
> > member [Measures].[SupplierDisplayName] as
> > 'Space([Supplier].[SupplierSKU].Currentmember.Level.Ordinal * 4) +
> > [Supplier].[SupplierSKU].Currentmember.Name'
> >
> > SELECT
> > { [Measures].[SupplierUniqueName] , [Measures].[SupplierDisplayName]} on
> > Columns,
> > {filter([Supplier].[SupplierSKU].[Supplier].Members,(Measures.[Sales Value]
> > > 20000)) } on rows
> > from
> > Supplier
> > >>
> > I had to add a filter because we have over 8000 vendors most of which we
> > don't need to look at. Take the filter out and substitue your dimension
> > names and you shoudl get what you need.
> > "Markus Krenn" wrote:
> >
> > > Hi,
> > > how can I Sort this MDX statement by City
> > >
> > > SELECT {[Measures].[Store Sales]} on Columns, {DISTINCT([Store].[Store
> > > City].members)} on Rows FROM SALES
> > >
> > > It is used in Reporting Services to fill the City-Paramter with values, in
> > > the Sample-Report MDX_Expression.rdl with DataSource Northwind2000
> > >
> > > many thanks
> > > markus