Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: how to show all values

  1. #1
    Join Date
    Feb 2013
    Posts
    6

    Default how to show all values

    I am trying to show all of the level values even if the count is 0.

    <Dimension type="StandardDimension" visible="true" highCardinality="false" name="Filter">
    <Hierarchy name="Filter" visible="true" hasAll="true" primaryKey="pk" caption="General">
    <Table name="Filter" >
    </Table>
    <Level name="Group" visible="true" column="Group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    </Level>
    <Level name="Name" visible="true" column="Name" nameColumn="Name" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    </Level>
    </Hierarchy>
    </Dimension>


    <Cube...
    <DimensionUsage source="Filter" name="Filter" visible="true" foreignKey="pk" highCardinality="false">
    </DimensionUsage>

    I have a Filter table with Group rows of Apple, Orange, Grape

    if the cube source only has Apple in the matching column I still want to have the others show.
    Is there a way to do this other than through the report options?
    Thanks
    Last edited by ricva; 11-29-2016 at 11:14 AM. Reason: clarification

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.