Dashboard 4.0 with EPMconnector 7.5 connecting to BPC 7.5

[Former Member]

Hi experts,

We are currently implementing a Dashboard solution for a client running Dashboard (6.0.0.0), EPM Connector (7.5.0.2791) & Excel 2003.We are having a number of performance and stability issues with the Dashboard and was curious if anyone else has similar experiences or solutions to the problem.

The main issue we see is the limited functionality of the EPM connector not being able to draw data from a nested Analyzer report into a Dashboard (as stated in the install guide). This means that multiple analyzer reports and EPM connections need to be built to get the required data into the Dash. The large number of reports and connections has made the Dash unstable and in certain circumstances stop working. We have seen behaviour where one EPM connection will not be working, but when we move it to the top of the connection list it begins working however another one further down the list stop working.

We have tried installing the EPM Connector V10 but unfortunately this does not have compatibility with BPC 7.5

This leads me to pose two questions to the forum -

1. Is there a way to build a nested Analyzer report, successfully draw the data into a Dashboard and refresh it using the EPM connector.

2. Is there a limited number of EPM connections per dashboard?

Thanks

[former_member182709]

Hi Spencer,

If you want to use EPM Connector 7.5, you need to use Xcelsius 2008. Dashboard is not officially supported with EPM Connector 7.5. You can find this information on the latest BPC NW 7.5 master guide as well as  KBA 1910256 - The support matrix of EPM Connector and BPC Data Grid with
Xcelsius/Dashboard Design.

Best Regards,
Charlie

[former_member195290]

Hi,

I have a question,

I am implementing the same i.e. Xcelsius dashboard over BPC 7.5 data.Now, I want to use same connection created on analyzer more than one time

for eg,

from 1st connection I have to pull some data from few accounts say 1,2,3

and from 2nd one data for some different accounts say 12,13,14

Now,

when i try to create one more connection its giving me "An active connection cannot be overwritten".

Please let me know how to pull data from same connection multiple times.

Regards,

Javed

[JohnL]

Hi Spencer,

What version of BPC are you on ? SP and patch?

Is this with BPC NW or BPC MS?

Can you also post a screenshot of what you mean by a nested Analyzer report?

Thanks,

John

[Former Member]

Hi John, thanks for the response.

It is BPC 7.5 MS on SP4.

By a nested analyzer report I mean having two dimensions on the Row or Column Axis - for example

                                        Time

Cost Centre, GL               XXXXX

Thanks

[JohnL]

Hi Spencer,

Are you using the latest version of the ODBO provider?

BPC75MODBO10_0-10008908.EXE

BPC 7.5, ODBO Client SP10

If not please upgrade to that to see if it resolves any performance related issues.

I know in ODBO SP09 there were performance improvements:

Note 1678533 - Performance improvements of BPC ODBO

Thanks,

John

[JohnL]

Hi Spencer,

I believe nested dimensions in a report are not supported.

Thanks,

John