...you are in a twisting maze of little passages, all alike...
Sep 25 2007
This is the fourth in my series about dynamic date objects. The first three included objects for daily, weekly, and then monthly ranges. I am going to complete my collection of Oracle-based dynamic date objects by providing yearly objects in this post.
Continue reading “Dynamic Dates Part IV: Yearly Date Ranges”
Sep 24 2007
I finally finished and submitted my presentations (part I and II) this weekend. It is always interesting to me to see how things evolve during the creative process compared to the abstracts, or even compared to my initial ideas. This year I am really happy with the way my presentations turned out; they are going through the review process now. Of course they were due a few weeks ago… 😳
Sep 16 2007
Both Desktop Intelligence and Web Intelligence provide options to coordinate the placement of one block based on the size of another. This technique is used when you have more than one block on a page and you want the lower blocks to move up and down (or left and right) on the page based on the volume of data shown in the “relative” block. This works quite well with two blocks as shown below.
The block on the left in this case (the blue box) would be the anchor block. The block on the right (the red block) would float relative to the anchor block. I can accomplish this by right-clicking on the floating block and selecting Format Block. The Appearance tab includes the following settings that I can tweak:
This technique works well for a chain of tables either horizontally or vertically. But what if I have the following scenario where I need to float blocks both horizontally and vertically?
Sep 12 2007
In the first post in this series I introduced the idea of dynamic date objects. The intent was to show how a universe designer can create dynamic date objects that can be used to schedule reports with a condition that changes over time. The first post covered the basic concepts and included “Today” and “Yesterday” dynamic date objects. The next post covered weekly ranges. In this post I will further extend the concept to monthly ranges. As with the other posts so far in this series I will be using Oracle functions.
Continue reading “Dynamic Dates Part III: Monthly Date Ranges”
Sep 05 2007
In earlier post I wrote about being selected as a speaker for the conference again this year. As I generally do I submitted about a half dozen ideas, of which two were accepted. As it turns out, there was an ulterior motive in place. I didn’t get two abstracts selected, but something different altogether.
Continue reading “The Orlando Experiment: Two Part Presentations”
Sep 04 2007
Years ago I made some noises about writing a technical book on Business Objects. I think the first time I seriously considered it was in 1998 after my second successful “variables” presentation at the annual conference. Considered it, yes. Started to write it, no.
Aug 30 2007
In the first post in this series I set up both regular objects and predefined condition objects that were based on the Oracle sysdate pseudo-column. These objects were designed to be used for scheduling reports with date conditions while allowing the date range to move forward in time for each new execution of the scheduled report. For that article I only created objects for Today and Yesterday. Today 😉 I will provide some weekly date ranges with the help of a few Oracle functions.
Continue reading “Dynamic Dates Part II: Weekly Date Ranges”
Aug 28 2007
This is a test. This is only a test. Please do not adjust your computer. We control the horizontal. We control the vertical. We control the Z axis on your three dimensional column chart. And we would like some testing and feedback on our very brief introductory podcast…
Aug 24 2007
You may have seen this already as it seems to be making the rounds. But if you haven’t, it’s hysterical. It might fall into the NSFW category only if laughing out loud while reading something off of your monitor will get you into trouble. Just make sure you’re not covering up with an email from your boss while you’re laughing and you will probably be fine.
What is it? It’s a very creative eBay listing from a mother of six. Here’s how it starts:
I’m selling a bunch of Pokemon cards. Why? Because my kids sneaked them into my shopping cart while at the grocery store and I ended up buying them because I didn’t notice they were there until we got home. How could I have possibly not noticed they were in my cart, you ask? Let me explain.
You haven’t lived until you’ve gone grocery shopping with six kids in tow. I would rather swim, covered in bait, through the English Channel, be a contestant on Fear Factor when they’re having pig brains for lunch, or do fourth grade math than to take my six kids to the grocery store.
Read the rest of the listing… (external link to eBay.com)
Aug 23 2007
This is not my first blog. However, it is my first blog where people are regularly trying to include code samples in their comments. After two or three comments have been lost due to WordPress ignoring everything after a < I finally figured out what was going on. This post contains a few tips on how to include code (variable formulas, SQL code, and so on) when leaving a comment. The information presented here may very well be appropriate for other blogs as well.
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 | 31 | |
