Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: CDA Datafactory Error in Saiku adhoc

  1. #1
    Join Date
    Jun 2014

    Default CDA Datafactory Error in Saiku adhoc


    I use Pentaho bi server CE v4.5 on windows. I have successfully installed the CTools using the .sh installer.

    I have also created a simple metadata model with metadata model editor 5.0. When I use the query builder, I can see myy data, no problem. After having exported the .xmi in pentaho-solutions/[my_apps]/metadata.xmi, I have created a "saiku adhoc" report where I have been able to see my model categories (login: "most famous joe on this forum"/password).

    My problem is that when I select a field in my model and put it in the column part of my report, I get an error saying:

    ReportGenerator.ERROR_0001 - The CDA Datafactory could not process the query
    Note that I get this error with the other sample models (human resources and so on) too.

    I have made some unsuccessuful researches on Google but an old post which solution didn't work for me.

    Do you have any idea ?



    I have looked into the .cda file in system/tmp and found the mql query. If I paste it in the sql editor of the metadata model editor, there is an error saying that the domain type can not be null. Indeed, there is no domain_type tag in the saiku query, versus a <domain_type> relational </domain_type> line in the metadata model editor syntax. Is this okay ?
    Last edited by Chris1; 06-06-2014 at 10:25 AM. Reason: adding precisions

Tags for this Thread

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.