The work flow is fairly basic… (you need to keep in mind that this code existed in a .rep report initially)
Sub LoadDataProvider() executes first because this is what is executed when you would click refresh on your report. I created this report using a VBA procedure as a dataprovider.
I used SQL to query the database because i needed specific information from the repository that was not readily available via pre-built universe(s) in business objects. Because I queried directly off of the repository, several of the values i needed came back in a ‘raw’ format (meaning i had to refer back to the documentation to decrypt several lookup values as well as write a few trick functions to convert the timestamps to actual date/time (as the default time is stored in seconds).
I found a link to the repository documentation here on BOB.
Hope this helps get you started on your solution (good luck!)
jresendez 
(BOB member since 2004-05-03)