Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Custom Queries in Pentaho Metadat Editor.

  1. #1
    Join Date
    Apr 2012
    Posts
    8

    Default Custom Queries in Pentaho Metadat Editor.

    I am Using Metadata Editor 3.8.0.
    I want to add custom query in my .xmi file
    By custom i mean that i can write diffrent select statements,where conditions and UNION Statements.
    And after writing custom query i want to use this .xmi file as datasource for creating Interactive report in pentaho BI platform 4.1

    How is this possible using Pentaho Metadata Editor?

  2. #2

    Default

    I am facing similar issues.
    As a work around I created Customize datasource(.xmi) in Pentaho 3.8 BI Platform EE. When I imported this file in Metadata editor and exported after making some changes. But, it didn't work. It gives error as Table doesn't exist.
    Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor
    14:57:25,643 ERROR [SqlMetadataQueryExec] SqlMetadataQueryExec.ERROR_0002 - Quer
    y execution failed: Table 'acmnms.select pa_displayname as devicename from vpa_d
    evice' doesn't exist

    Basically, it is considering entire query as a Table name hence failing.

    Is there any way we can add cutomize query in Metadata editor instead of importing tables?

  3. #3
    Join Date
    Apr 2012
    Posts
    8

    Default

    I think it is giving error beacuase it treats it as (schema_ name).Select ... from tabel
    hence it is not able ot execute it.

    can anybody suggest us how to remove (schema name) that appears before query?

  4. #4
    Join Date
    Apr 2009
    Posts
    337

    Default

    Did you ever think of creating views in DB and then importing them from metadata, that is one of the simplest ways, else you have to put up with the formula expressions of MQL.
    Regards,
    Madhu

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.