Even though SAP provides connectivity to both SAP BW and relational data, combining these data sets into a single report can be tricky. There are lots of ways to do it: A Single, Federated Query combining an SAP DSO and Relational data at the universe tier. A Single, Federated Query combining an SAP Infocube Relational […]
Tag Archives: WebIntelligence
Fixing Permissions: Am I Allowed To Do That?
One of my least favorite topics is licensing. It seems like every year as corporate strategies change and as customers push for simplified licensing, SAP comes out with a new way to sell it’s products. If you’ve been around a while you’ll recognize some of these: BusinessObjects Enterprise BusinessObjects Enterprise with Interactive Viewing BusinessObjects Enteprise […]
Histograms in WebIntelligence
Every once and a while I run across a reporting technique that makes me say: Wow – that was really clever. In going through the new charting in BusinessObjects v4.0, I noticed that there was no histogram available. After doing a Google search I found a great article by Alastair Gulland. Alastair uses a combination […]
WebI Date Conversion
Have you ever been in a situation where you wanted to display a date on a report but the date was in date/time format? I run into this all the time when dealing with detailed data from transactions with date time stamps. The best way I’ve found to do it is by converting the value […]
Date Conversion Made Easy…
Have you ever been using SAP BusinessObjects WebIntelligence and wanted to turn a prompt from a date time into a date? I do a lot of demos using Microsoft SQL Server and by default Microsoft SQL Server saves everything as a date & time. So what if I don’t want the time? Simply convert the […]