Skip to Content
Sep 08, 2009 at 02:59 PM

SAP BPC and Hyperion SmartView


Hello, Forum u2013

Encountering an issue when trying to use SAP BPC and Hyperion SmartView at the same time and just curious if anyone else is 1) using both programs at the same time and 2) if so, have you encountered any problems?

Here is the scenario:

I have a SAP template file (EvDRE) that is used in conjunction with Hyperion SmartView. The way it works is that the template would extract the numbers out of Hyperion and then send the base numbers to the SAP system.

In order to do this, however, I have to create the connection to the Hyperion database first, which I do using VBA code.

When I execute this code within a blank workbook, I am able to successfully create the connection to Hyperion with no problems.

When I execute the same code within my SAP template, I receive a MS Excel error (u201CExcel has encountered an error and must close programu2026u201D). This has been a consistent result that Iu2019ve received.

Please note that I am not logged into either SAP or Hyperion when I receive this error (this happens outside both systems). I'm worried that as soon as I log into both programs, the whole thing will crash...

So, just curious if anyone out there is encountering the same issue when trying to use both programs.

Please let me know.