Ask a new question

VBA for Connecting to Oracle SmartView

Hello,

 

Does anyone know how I can write a VBA code to connect to Oracle SmartView (Essbase - Hyperion) using Excel?  I had the following code and it worked great, but that was in an older version of Essbase.  Company recently upgraded to SmartView and I can't seem to find the commands for connecting and for retrieving the data using SmartView.  Thanks for any assistance.

 

    If Right(Left(wkshtnames(i), (Application.WorksheetFunction.Find(".", wkshtnames(i), 1) + 1)), 1) = "E" Then
        hCtx = EssVGetHctxFromSheet(Null)
        If hCtx = 0 Then
            MsgBox "Workbook NOT Connected to Essbase. Please Log In.", vbCritical, "P&RA Actuals Essbase Refresh"
           
            'Call Essbase connect function
            Call EssMenuVConnect
            GoTo Step1
        Else
            ShtName = Worksheets(wkshtnames(i)).Name
            Worksheets(ShtName).Activate
            LastRow = ActiveSheet.UsedRange.Rows.Count
            LastColumn = ActiveSheet.UsedRange.Columns.Count
           
                Set Rng1 = Worksheets(i).Range(Range("B3"), Cells(LastRow - 1, 15))
                          
                        Rng1.Select
                        Application.Run macro:="EssMenuRetrieve"

Gigi,

Did you ever get a reply.  I am having the same issue.

Thanks.

9 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

This code is written against the old Essbase Add-in. VBA for Smartview is different.  Here is an intro from Oracle:

http://www.oracle.com/technetwork/middleware/financial-management/tutorials/sv-vba-obe-091531.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

u can get VBA connect examples from this VBA project 


https://goo.gl/NqgoHA

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 15, 2025 Views 4,961 Applies to: