You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SmartView - Connect to Shared Database

Received Response
1
Views
2
Comments
edited Aug 2, 2018 2:36AM in Essbase 2 comments

Summary

SmartView - Connect to Shared Database

Content

32-bit for Office; Version 11.1.2.5.710

Hello,

I am fairly new to Oracle Smart View and have been recently assigned to debug an issue with establishing a connection to our National Sales connection. Establishing a connection requires logging in with a username and password.

How do I properly establish a connection to National Sales and Zoom In on "All Customers" (Manual Input). My code so far is:

Microsoft Excel Objects

     This Workbook:

     'Opens form to access workbook    

          Private Sub Workbook_Open()

          U_login.Show

          End Sub

Forms

     U_login

          Private Sub CommandButton1_Click()

          U_ID = UID.Value

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!