InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 20:31:37 GMT20http://www.sqlservercentral.com/Forums/Topic466013-292-1.aspxI would like to see the member properties in a table. In excel I can see the member properties in a pivot table in the row or column but I would like to see them in an mdx grid. The statement I use is running good:SELECT NON EMPTY [Dossier].[Nummer].[Dossiercode].MEMBERS PROPERTIES [Dossier].[Nummer].[Dossiercode].[Klant Achternaam], [Dossier].[Nummer].[Dossiercode].[Klant Voorletters], [Dossier].[Nummer].[Dossiercode].[Klant Geboortedatum], [Dossier].[Nummer].[Dossiercode].[Klant Geslacht], [Dossier].[Nummer].[Dossiercode].[Datum Aanmelding], [Dossier].[Nummer].[Dossiercode].[Datum Annulering], [Dossier].[Nummer].[Dossiercode].[Datum Startzorg], [Dossier].[Nummer].[Dossiercode].[Datum Eindezorg], [Dossier].[Nummer].[Dossiercode].[Klant Aantaldossiers], [Dossier].[Nummer].[Dossiercode].[Productcluster Omschrijving] ON COLUMNS FROM [JZAA_Main_Dim]where([Boekdatum].[Maand].[All Maanden].[2007].[Q4 2007].[Dec 2007],[Kengetallen].[All Kengetallen].[AanmeldingZA],[Organisatie].[Structuur].[All Organisatiestructuur].[Zorgaanbieder].[MOC])The result set is the dossiernumber on the column header just as expected but I do not see the member properties. How can i make them visible?Menno van LeewenFri, 07 Mar 2008 10:24:02 GMTM.van Leewen