Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: 2 questions - remember I'm slow ...

  1. #1

    Default 2 questions - remember I'm slow ...

    I have a physical table - some rows should not be visible in a business view. There is a single attriubte that determines this. How can I constrain the data in a BT with a where clause?

    Is this on the conditions tab of Physical Table properties?


    Can I base a BT on a SQL statement rather than a physical table - there are reasons I don't want to use the DBMS to create a view, and would prefer to use a SQL?


  2. #2
    Join Date
    Nov 1999


    We will be adding support for these things in the next version.
    For the time being, consider writing views.

    We have not added support for these features because we want to cater to the data warehouses first.



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.