Tuesday, August 17th, 2010
This article looks at how to use a local data source in a Web Intelligence report and then combine that data with data retrieved from a data warehouse.
Business Scenario
The worked example described here is to create a simple dashboard style report of sales data. We then highlight the sales figures ...
Posted in How To, Web Intelligence | Comments Off
Tuesday, June 1st, 2010
This article compares data analysis using Web Intelligence to the same workflow using Microsoft Excel and for the given scenario demonstrates why using Web Intelligence is quicker, easier and less error prone.
The objective here is not to show that in all cases Web Intelligence is better than Excel rather to ...
Posted in How To, Statistical Analysis, Web Intelligence | 1 Comment »
Saturday, February 6th, 2010
A geometric mean is an average that is useful for sets of numbers that are interpreted according to their product and not their sum as is the case with the more commonly known arithmetic mean. An example of where you would use a geometric mean is in financial reporting when ...
Posted in How To, Statistical Analysis, Web Intelligence | No Comments »
Tuesday, January 27th, 2009
Often in a reporting or data analysis scenario the analyst or business user wants to view data that is current, for example, sales for the current week or employee turnover for the current month etc. The analyst could create the report and then just enter whatever the current date is ...
Posted in Information Delivery, SAP Business Objects, Universe Design, Web Intelligence | No Comments »
Monday, January 26th, 2009
In the previous article we looked at why using System Date functions in a BI solution can lead to difficulties in development and testing. In this article we are going to look at several alternatives to using system date functions.
Posted in Information Delivery, SAP Business Objects, Universe Design, Web Intelligence | No Comments »
