MDX Member properties

  • I 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 Leewen

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply