How to open a BPC report more than once in BPC 10.1 NW

[Former Member]

Hello

We are currently working with versión 10.1 BPC NW, versión: SP20 Patch 2 NET 4

We need to open a BPC report more than once, but this version cannot do this the old BPC 7.5 MS version generates different versions for

a same report, adding a sequential number at the end of the report's name and and therefore it can work a same report at the same time.

For example, we have a report with name "Financial report.xlm", the first time we open that report the name assigned by the system is:

Financial report1.xlm

if we open the same report again, without closing the first one, the system assign this new report the name:

Financial report2.xlm

with this we can open the same report many times.

This is not posible in our BPC new version, because when we open a new report, no sequential number is added to the name of the report.

How can a BPC 10.1 report open more than once? is there a way to simulate the behavior of the 7.5 version?

Thanks Gurus!

[former_member186338 · Accepted solution]

Sorry, but looks like you have some macros in this file "Financial report2.xlm"

May be macro code is changing the name?

Or...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Yes, we have some macros in the report that we want to open more than once, but in any case macro which we have defined not changes the name of the report.

[former_member186338 · Accepted solution]

May be you save file as a template?

[Former Member · Accepted solution]

Hi Vadim,

We keep all reports on BPC server, with the option: Save to Server Root Folder... (attached capture)

The customer with whom we are working need to open  the same report "more than once" that is saved on the server, as I mentioned in the BPC 7.5 version of MS, you can open the same report more than once.

Thanks,

[former_member186338 · Accepted solution]

Try Save to Server Root Folder as template (with xltx extension).

Vadim

[former_member186338 · Accepted solution]

P.S. Or .xltm - Macro enabled template!

[former_member186338 · Accepted solution]

Yes, tested!

If you save file as xltm:

Then if you open multiple copies of this file you will have:

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks Vadim, we have saved reports as template, and now we can open the same report more than once.

Thank you so much!