Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: mql constraints

  1. #1
    Join Date
    Sep 2008
    Posts
    11

    Default mql constraints

    Hi all.
    Tell me please somebody should I check "is the formula exact" if I want to put mql constraint on business column

    my constraint is
    LIKE([BT_PERSON_PERSON.BC_PERSON_FIRSTNAME];"aFN")

    or maybe should I put this constraint on the whole business table(I mean add to BT new property "formula")


    1)My problem is: when I put MQL constraint on BC without checking "is the formula exact" I get

    java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or co
    lumn specification

    because the query looks like:
    SELECT DISTINCT
    BT_PERSON_PERSON.LIKE([BT_PERSON_PERSON.BC_PERSON_FIRSTNAME];"aFN") AS COL0
    FROM
    PERSON BT_PERSON_PERSON



    2) when I put MQL constraint on BC with checking "is the formula exact" I get

    "StackOverFlowException"
    at org.pentaho.pms.mql.PMSFormula.generateSQL(PMSFormula.java:534)
    at org.pentaho.pms.mql.dialect.DefaultSQLFunctionGenerator.generateFunct
    ionSQL(DefaultSQLFunctionGenerator.java:170)
    at org.pentaho.pms.mql.PMSFormula.generateSQL(PMSFormula.java:554)
    at org.pentaho.pms.mql.PMSFormula.generateSQL(PMSFormula.java:622)
    at org.pentaho.pms.mql.SQLGenerator.getBusinessColumnSQL(SQLGenerator.ja
    va:628)
    at org.pentaho.pms.mql.PMSFormula.renderContextLookup(PMSFormula.java:59
    7)
    at org.pentaho.pms.mql.PMSFormula.generateSQL(PMSFormula.java:534)
    Last edited by dmartynov; 10-30-2008 at 01:24 PM.

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.