yangqingtao Absent Member.
Absent Member.
782 views

PPM Excel Report tips for PPM9.30

As we know, excel report is supported after PPM9.30. 

But when I tried to use this funtion, I got some issues which made me mad.  Now I list them and hope to save your time

 

1. First of all, this is only supported by PPM3.0

2. You need to set configure parameter "EXCEL_TEMPLATES_PATH" in server.conf file before using. it should look like that

com.kintana.core.server.EXCEL_TEMPLATES_PATH=C:/PPM/conf/custom_excel_templates

3. It only can parse the report token. If you want to run this report in work flow step,  request token should not be accepted.

4. Attached the excel template and guide for your reference

 

 

PS - Gloabal delivery Center - China
1 Reply
Micro Focus Expert
Micro Focus Expert

Re: PPM Excel Report tips for PPM9.30

Hi,

 

A few corrections here:

 

1) It's supported since PPM 9.30

 

2) It's optional to define parameter "EXCEL_TEMPLATES_PATH". If the parameter is not defined, you should put the templates in <PPM_HOME>/conf/custom_excel_templates. 

The advantage of the parameter is that you can point it to a shared folder and maintain your excel templates in one single place rather than copy them to every node of your PPM cluster.

 

3) In next PPM minor version, it will be possible to use XLSM files (excel with macros) as Excel Report templates. Actually it's already working, but the files will be renamed to XLSX when the report is generated (and they must be manually renamed before the file can be opened). No such issue in the next version: If the template is an xlsm file, the report will be an xlsm file.

 

Kind Regards,

Etienne.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.