Databases Reference
In-Depth Information
Essbase nested coding style examples
Here is a representative example of the nested coding style and the obvious benefits
of employing such a method or style.
Begin action 1
Begin action 2
Begin action 3
Perform action 3
End action 3
Begin action 4
Perform action 4
End action 4
End action 2
End action 1
This example should illustrate nicely why the nested style is the preferable code
writing style. The next example will now put the previous example into Essbase
functionality context so it makes sense for you. Most Essbase API functions usually
must be started or opened and after completion of the task they must be ended
or closed.
Initialize the API
Login to a server
Connect to a database
Open a database outline
Browse the outline
Close the outline
Open a report
Modify & save the report
Close the report
Disconnect from a database
Logout from the server
Terminate the API
Typically, the group of Essbase API calls or functions illustrated in the previous
example would be embedded in a VB subroutine so that it would actually look
more like this:
Sub BrowseOutlineAlterReport()
Initialize the API
Login to a server
Connect to a database
Open a database outline
Browse the outline
Close the outline
Open a report
Modify & save the report
