We have seen recently how easily false narratives get picked up and repeated so many times that eventually it is believed as true. Perhaps this is an idea that was borrowed from cooking. Cooking has long been rife with traditions and ideas that have been passed down from generation to generation that while the original […]
Recently I had a couple of interesting situations pop up in OBIEE 11g regarding dates. No not the edible kind, but the calendar kind. Specifically where it involves fact measures that are valid for a period of time beyond what the date id(s) on the rows in the table allow. The first scenario I will […]
I’ll address the title of this right at the top, in short, it depends. The long answer, which I will discuss as I go through this article, is it depends on how you intend to use it. If you are a small company or team with fairly simple data needs, and you are using it […]
I know it sounds like I am writing about 1980s technology, and I am, but the fact remains that Excel is still a widely used tool in the business world. Besides, what else would you put your data dumps into? Often Excel reports get used for management reporting, which comes with a number of issues. […]
Whether you are using Excel as a data source for your Business Intelligence (BI) platform, or you are doing the actual analysis within Excel, your data will need to be in a format that is queryable. Often though, the data is formatted to be read visually, whether an export from a system, or manually entered. […]
The other day I was playing around with the Direct Database Request (DDR) feature within OBIEE. The reason I did this is I wanted to create a report that utilized columns from the database that were not exposed in OBIEE, yet still utilize the functionality of OBIEE. Why else would you use this and how […]