SAP BPC and Hyperion SmartView

[carlo_tom]

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.

Carlo

[Former Member]

My suggestion is to attempt to break it into 2 seperate work flows for testing, using 2 seperate templates. One to pull, then copy the data to the second sheet for submission. I would assume that you would have to be connected to initiat eeither the extraction of sending of data using your added code, so seperating the 2 steps may prove useful.

Hope this helps.