Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: how to show all values

  1. #1
    Join Date
    Feb 2013

    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" >
    <Level name="Group" visible="true" column="Group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    <Level name="Name" visible="true" column="Name" nameColumn="Name" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">

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

    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?
    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.