Database Reference
In-Depth Information
Exit Sub
End If
svRetVal = HypSetActiveConnection(sConnName)
If (isSVError(svRetVal)) Then
Call handleSVError(svRetVal, "HypSetActiveConnection",
"SVconnect")
Exit Sub
End If
End Sub
having login information will allow you to do things like looking something up
about a user in a custom SQL (Structured Query Language) table, track and store things
about your users, and provide single sign on capability to other applications from which
you may want to present data alongside the Smart view data.
10.4.4.2 Refreshing Sheets
If you have gone through the trouble to create a custom
login, automated retrievals also are likely part of your report functionality. refreshing
multiple sheets used to be a tedious task involving looping over all the sheets in a work-
book, and then doing the same in other workbooks, verifying each connection, and
then refreshing each in turn. This has all changed with the addition of this vBA func-
tion: hypretrieveAllWorkbooks.
This function will save a huge amount of time in your
coding by allowing you to refresh all worksheets currently open in Excel.
10.4.5 Cascading Reports
Cascading reports are a new feature to Smart view and provide a significant level of con-
venience. A cascading report is one that starts with a base report that, for instance, has
the Period dimension in the Pov. By selecting several members of the Period dimen-
sion, the report can be cascaded by those selections. This means that a new worksheet
will be created for each selected Period and the rest of the report's layout will flow to
that sheet, only the Period will be different. Each new spreadsheet will be named for the
member to which it cascades.
In Figure 10.3, our initial report has been cascaded by period (month).
10.4.6 Linking Smart View Functionality to Common Form Elements
This section will provide a few quick examples for linking Smart view functionality to
common Excel form elements, such as text boxes, drop down lists, and buttons. Because
Figure 10.3
Reports cascaded by period.
