Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Saiku does not show columns in the saved reports

  1. #1
    Join Date
    Sep 2012
    Posts
    23

    Default Saiku does not show columns in the saved reports

    Hello,
    I have the metadata model (created with metadata editor) with big amount of the columns (~300-400). It is working good on my local machine (intel i5, 8gb ram). When I try to create report on the server (virtual machine wit 1 CPU and 4GB RAM) it shows all columns but when I try to save the report and open again it shows no columns and shows the message: "You need to select at least one (non-calculated) Column for a valid query.".

    I tried to google and tried many things offered in the forums. I tried at least 3 versions of the Saiku (2.1, 2.4, 2.5) with no result. I tried to reduce the number of columns and found out that it worked with the 147 columns...

    Can anybody help?

    P.S. On the first pictures I just created the new report and saved it and on the second picture I opened it.
    Name:  Selection_001.jpg
Views: 79
Size:  27.9 KB
    Name:  Selection_002.jpg
Views: 63
Size:  16.7 KB

  2. #2
    Join Date
    Sep 2012
    Posts
    23

    Default

    we found the solution. Do not know what would be affected, but seems that it working ok.
    Uncomment the line in the pentaho-solutions/system/saiku-adhoc/web/js/adhoc/views/Workspace.js
    this.bind('models:loaded',this.populate_selections);

    in the same directory modify MdModelList.js. Replace
    // Fetch from the server if we haven't already
    if (args.mdModel && args.mdModel.has('template')) {
    this.load_md_model();

    with
    // Fetch from the server if we haven't already
    if (args.mdModel && args.mdModel.has('template')) {
    this.template = this.mdModel.get('template');
    this.render();

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.