Apr 17 2009

Integrity Check Improvement

Categories: Universe Design Dave Rathbun @ 9:17 am

Wouldn’t it be nice if you could run an integrity check on your universe and click a box that says to only check objects changed since last export?

I tried to see if there was a way to write this in VBA, but there doesn’t appear to be a “last changed date” attribute on objects. I have been working on a Change Log script, and I could integrate the two, but that seems like overkill. I would have to maintain an unchanged copy of the universe in order to do the compare, then run the compare and capture the differences, and finally run an integrity check on that subset of objects.

It’s probably easier just to start the check on the entire universe and go to lunch…


Apr 16 2009

Java Memory Errors During Data Provider Updates in Web Intelligence

Categories: General,Web Intelligence Dave Rathbun @ 5:00 pm

Changing Data Providers in Complex Reports

We have some fairly complex reports at my current client. Of course the word “complex” is not very clear; what is simple to me might be complex to someone else. So let me quantify what I mean by “complex” in this case. The report in question has multiple data provders. Each data provider generates multi-pass SQL because of contexts. Altogether there are 29 data providers with an overall total of over 100 SQL passes. 😯 That’s what I mean by a “complex” report, and I think most folks would agree with that assessment.

The challenge is that for this (and other) complex reports we have been encountering severe issues. In some cases we are unable to edit the queries without restarting our browser session. We also have encountered a number of problems during the process of repointing the document from one universe (development) to another (user acceptance testing) within the same environment. Continue reading “Java Memory Errors During Data Provider Updates in Web Intelligence”


Apr 13 2009

Conference Abstract Deadline Extended

Categories: 2009 GBN - Dallas Dave Rathbun @ 3:54 pm

The deadline for submitting an abstract for the 2009 GBN conference has recently been extended. The deadline was supposed to be today but is now April 24. That’s good news for me, as I have not been able to get my thoughts together yet about what to submit.

If you have never submitted an abstract before, the process is quite painless. All you have to do is come up with an idea and summarize it in several hundred words. That’s it. 🙂 Once you have that there is a simple web form to fill out and your submission goes into the process. This year for the first time the user community will be involved in the selection process (part of the value of being a member of GBN) and I thoroughly support that concept. In the past Business Objects would manage the selection process with little or no direct input from users.

One of two things will happen. Either you get selected at which point you have to create the presentation and deliver it to an audience of your peers and you get a free pass to the conference. Or you don’t get selected and don’t have to do the extra work. 😉


Apr 03 2009

Please Wait Run Query…

Categories: General Dave Rathbun @ 12:02 pm

Isn’t it a bit disconcerting that the Web Intelligence programmers felt like they had to include “hours” on the “please wait” dialog box?

Please wait dialog box