Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: hmmm...boolean dimension?

  1. #1
    Join Date
    Mar 2003
    Posts
    207

    Default hmmm...boolean dimension?

    question here... i have a base table with several boolean columns - indicating cancelled status of an invoice etc...
    whats the best way to filter according to these columns - ie -show only those where cancelled=false? the dimension keeps giving me two vaules to choose from, and I don;t want that. just the one visible. Is there a solution for this - a "where" condition in the dimension or something? or do I have to use views to achieve this?
    thnx.

  2. #2
    Join Date
    Sep 2002
    Posts
    475

    Default RE: hmmm...boolean dimension?

    You can add a dimension in your schema: see "A dimension can live in a fact table" in the Mondrian "Writing a schema" documentation ie.
    <Cube name="Sales">
    <Table name="sales_fact_1997"/>
    ...
    <Dimension name="Cancellation">
    <Hierarchy hasAll="true">
    <Level name="Canceled" column="canceled" uniqueMembers="true"/>
    </Hierarchy>
    </Dimension>
    </Cube>
    and a where clause in your MDX query.
    select {[Measures].[Unit Sales], [Measures].[Store Sales]} on columns,
    {[Time].[1997].[Q1].descendants} on rows
    from [Sales]
    where [Cancellation].[true]
    The JPivot Slicer manipulates the MDX where clause.

  3. #3
    Join Date
    May 2003
    Posts
    22

    Default RE: slicer problem

    i want to show only those customers where age > 40 . age is a member property. the solution described above is not really what i need.
    how can i do that with MDX?

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.