BPC MS 10.1 PROBLEMS WITH THE REPORTS

[Former Member]

Hi,

I have a question about BPC MS 10.1 that affects the reports.

I have a spread sheet with a few tabs. Every tab contain 3 dinamic reports.

When I refresh the spread sheet, the second and the third reports on each tab loses it’s format, and when I refresh it for the second time, the format comes back.

Every report has a Epmcopyrange and so I don’t need to work with the formating in sheet.

Has anyone had a similar problem?

Please Help me.

Many Thanks.

Kind Regards,

Luca Ianni.

[Former Member · Accepted solution]

Hi Shrikant,

the SP 2.0  didn't allow me to load the data, I don,t now why.

Thanks you.

Regards,

Luca.

[Shrikant_Jadhav · Accepted solution]

Hi Luca,

Uninstall current add in then install "SP 20" not SP 2

Shrikant

[Former Member · Accepted solution]

Hi Shrikant,

Do you know a direcr link where I could download the EPM ADD IN SP 20, please?

Thanks in advance.

Regards,

Luca.

[Former Member · Accepted solution]

Hi Luca,

you can find the latest EPM addin and latest patch on http://service.sap.com/swdc.

[Former Member · Accepted solution]

Hi,

We solved the problem with VBA, with a double refresh for each tab excel.

Example:

Application.StatusBar = "Sheet 1..."

   Sheets("Sheet 1 ").Activate

   EPMObj.RefreshActiveSheet

   EPMObj.RefreshActiveSheet (This is the second refresh)

Thank you all for your contributions.

Regards,

Luca

[former_member186498 · Accepted solution]

Hi Luca,

then please close this thread assigning your answer as "correct answer" this will help other users.

Regards

     Roberto

[Shrikant_Jadhav]

Hi Luca,

Which SP of EPM Add In you are using ?

Shrikant

[Former Member]

Hi Shrikant,

I'm using the SP1 Microsoft Office 2010

I have uninstalled SP2 because it didn't allow me to load the data.

Thank you,

Regards,

Luca

[Shrikant_Jadhav]

Hi Luca,

It's too old SP, kindly update to SP 20, then test your report.

Shrikant

[Former Member]

Hi Loca,

The "SP1" you mean is Excel2010 SP1.

What Shrikant asking you is the version of "EPM Add-in". You can check it by: Open Excel --> Go to EPM tab --> Click "About" --> Click "About EPM Add-in".

Best Regards,
Arjen

[Former Member]

Hi Arjen,

the version is 10.0 SP 15 PATCH 2.NET 3.5.

Best regards,

Luca

[Shrikant_Jadhav]

Hi Luca,

Try to reproduce same problem by creating new report .

And kindly upgrade EPM Add In SP to 20

Shrikant