Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to display the properties in Jpivot ?

  1. #1

    Lightbulb How to display the properties in Jpivot ?

    Hello,

    I wish to display the properties (or "attributes") in Jpivot but the ad hoc button (the 7th from the left has no effect)...

    Can anybody tell me where I am wrong in my schema ? Or should it be explicitely declared in the MDX ?

    A part of my schema :
    <Dimension name="Dossiers">
    <Hierarchy hasAll="true" allMemberName="Tous les types" primaryKey="dossier_id">
    <Table name="dossier_dim"/>
    <Level name="Secteurs" column="secteur1" uniqueMembers="false"/>
    <Level name="Dossiers" column="nomComplet" uniqueMembers="true"/>
    <Property name="Numero" column="numero"/>
    <Property name="Responsable" column="responsable"/>
    <Property name="Collaborateur" column="collaborateur"/>
    </Hierarchy>
    </Dimension>


    The MDX :
    SELECT {[Measures].[Initial], [Measures].[Final], [Measures].[Boni-mali], [Measures].[%]} ON COLUMNS,
    NON EMPTY Crossjoin({ [Dates].[Toutes les dates] }, Crossjoin({ [Producteurs].[Tous les types] },
    Crossjoin( { [Rubriques].[Tous les types] }, { [Dossiers].[Tous les types] } ) ) ) ON ROWS
    FROM [evaluations2]]]

    Thanx,

    Marc

  2. #2

    Smile Sorry ! I found my error ;)

    My properties were not inside the level !!

    I should have written :

    <Dimension name="Dossiers par type">
    <Hierarchy hasAll="true" allMemberName="Tous" primaryKey="dossier_id">
    <Table name="dossier_dim"/>
    <Level name="Secteurs" column="secteur1" uniqueMembers="false"/>
    <Level name="Dossiers" column="nomComplet" uniqueMembers="true">
    <Property name="Numero" column="numero"/>
    <Property name="Responsable" column="responsable"/>
    <Property name="Collaborateur" column="collaborateur"/>
    </Level>
    </Hierarchy>
    </Dimension>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.