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?

    Thanks

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    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.

    HTH,

    Matt

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.