Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Exporting analyzer reports to EXCEL can I configure to Not show Metadata information?

  1. #1
    Join Date
    Sep 2014
    Posts
    7

    Default Exporting analyzer reports to EXCEL can I configure to Not show Metadata information?

    Hi, I saw an old post about this but there was no response.
    In the User Console when a user chooses an analyzer report to export
    to EXCEL there is metadata information at the top of the spreadsheet
    and the same info on a separate sheet. How can I configure Pentaho
    not to add this? Help is greatly appreciated.

  2. #2
    Join Date
    Sep 2014
    Posts
    7

    Default

    Well I'll answer my own question and share what I learned. :-)
    Problem Description

    How to remove the report attributes (i.e. location) in the PDF and Excel output in Analyzer
    Resolution

    Hide the unwanted information by modifying some properties in biserver-ee\pentaho-solutions\system\analyzer\analyzer.properties file.
    Here the section of interest:

    # Excel and PDF export metadata options.
    # Set to true to hide the specific section or item in the section
    #renderer.metadata.hide.aboutThisReport=true
    # If the above property is set, then all sub-properties in 'About this Report' will be hidden
    #renderer.metadata.hide.aboutThisReport.name=true
    #renderer.metadata.hide.aboutThisReport.description=true
    #renderer.metadata.hide.aboutThisReport.creator=true
    #renderer.metadata.hide.aboutThisReport.location=true
    #renderer.metadata.hide.aboutThisReport.createdOn=true
    #renderer.metadata.hide.aboutThisReport.cube=true
    #renderer.metadata.hide.filterSummary=true
    #renderer.metadata.hide.fieldsUsed=true
    # Hide the PDF cover page - i.e. do not include it in the PDF export
    #renderer.pdf.cover.hide=true

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.