on 01-29-2014 3:52 AM
Dear all,
I am working on BPC 10 MS version. I would like to use the “Book Publication” function in excel EPM add-in to publish the excel report in PDF format. I am able to create the book template and select different dimension members for the report. Also, it can convert the excel report into PDF format successfully. However, I got 2 questions about this function.
1. I found that the report format in PDF is different from the format in Excel. For example, “REPORT A” has 10 columns(A-J) and 20 rows in a excel tab, but after converted the “REPORT A” into PDF format, it could only show the first two or three columns(A-C) on one page, and remaining columns(D-J) on other pages. How can I set the scaling of the report to be published with all columns and rows on one page in PDF?
2. I found that there is an error when generating the PDF if I keep opening the excel report which is going to be published. Is it a must to close the excel report when publishing the report?
Thanks!
Regards,
Ivan
Hi Ivan,
on the first question, in your Excel report, have you defined a print range and set the print options (such as fit to one page etc)?
BR,
Arnold
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arnold,
Your suggestion for question 1 works! Thanks for helping!
But the problem mentioned in question 2 still exsist. I still have to close all the excel file first and then run the book publication in order to avoid the error.
For example, Im going to publish REPORT A in PDF format, I have to close the Report A first and then publish Report A via Book Publication in order to avoid the error below. Any suggestions? Thanks!
Regards,
Ivan
Hi Ivan,
this is an Excel and not a BPC issue. When you have any xlsx file open and another use tries to open the file as well, they get a message from Excel asking whether they still want to open it or wait until you have closed it.
When you have a report in xlsx format open and try to publish it, essentially the same thing happens, only it is BPC that (technically) gets asked the question. As BPC cannot answer it cannot open the file and the publish fails.
An Excel template however can be opened numerous times as Excel always opens a fresh copy.
I am not aware of any way around this, so if you want to have the report open and publish it at the same time, then I believe you will have to use the xltx format for all reports/input schedules.
BR,
Arnold
We are facing the same problem. "Error while saving file". All of our reports are XLTX. Even though we get the error it still seems that the publication works if we put only a number of reports in.
However when we put all of our reports in ( 30 ) it gets stuck after 20 reports.
SAP have advised us that this is due to memory errors as we are still working on 32 bit machines but I can't believe that we are the only ones.
They have also advise to install Amyuni PDF printer but this did not solve the problem either.
Any suggestions what we could do?
Marijn
Hi Marijn,
Its better to create a new forum question for this.
Also, there was a fix in SP25 Patch 1 for distribution ...
2289350 - ALL: Error Message during the distribution
Thanks,
We were having the same issue and resolved it by following Arnold's advice to change the Excel file to xltx and also applied the recommendation in SAP Note 2110299 (All: PDF Publication Cannot Skip Amyuni.) Per the SAP note, we changed the EPM10 config file which looks for the Amyuni software to just skip using Amyuni since Office 2013 can create its own PDF files.
We first noticed there was a problem after we upgraded to Office 2013 from Office 2010. The process would fail and we would receive the same error as Ivan did which read: "Error while saving the file" and the pop-up below "Printer not activated, error code - 30"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What will cause the book publication not to reference the Context when it is specified in the template? %CUR%.
For example: The book is running for ALL when the context is selected for a specific member.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.