Skip to Content
author's profile photo Former Member
Former Member

Work book Broadcasting Issue

Hi Experts,

I have got A pre Calculation server installed in one of my XP Machines. The pre calculation server is functioning properly.

One problem I am facing here is when on the same pre calculation server when I schedule or Direct Broadcasting is done

in Production server the output comes as junk. As we all must have seen in excel when the work book is created in the

higher version of excel and opened in lower version it opens as junk. it is opening is the same fashion

but

in Development server the output is proper.

The best part is that in both the servers the same Pre calculation server is used.

Pl put some light on this

Thanks

Shivani

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Aug 31, 2010 at 12:54 PM

    Hello Shivani,

    - Please check that the workbook being broadcast opens & refreshes ok on the precalculation server.

    - Ensure that the precalculation server is patched to the same or higher level then Analyzer.

    - In any case, please test the latest FEPs for Analyzer & Precalculation.

    > BW 7.x precalculation service SP1300 - GUI 7.10 (note 1413028). All download info & installation instructions can be found

    in the same note. The installation guide is also attached to the same note. **Note, in the precalculation service please

    maintain the user with windows system administration rights instead of the local system account user as mentioned in the

    installation guide on page 13.

    > BW 3.x Add-On Front-End SP10 (see note 1413154)

    > BW 7.x Add-On Front-end SP1300 (see note 1413030)

    > SAP GUI patch 18

    Thanks,

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 31, 2010 at 06:52 PM

    Hello,

    Probably you are using Excel 2007 on your Precalculation Server.

    May I suggest you to use Excel 2003.

    Or, as another tip, try to implement the instructions of note 1339061 on the Excel of the Precalc. Server.

    Let me know if the issue persist.

    Thanks

    Edard

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2010 at 05:22 AM

    Hi experts,

    Actually I am using the same pre calc server with BI Development & Production. But in development it is working fine and

    pre calculation is taking place, but in Production everything is taking place but the excel file that is getting generated in a junk on.

    whearas in development everything is OK

    Regards

    Shivani

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 10, 2010 at 05:04 PM

    I've contacted my colleague, one of the developers of Precalculation Server.

    It's possible, yes. But this is not recommended. I'm not sure if SAP provide support in this case.

    Well, I would like to suggest you this note:

    1498626 Precalculation Server: issue with Excel 2007 file format

    Let me know if persist

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.