Using Local Data Sources in Web Intelligence XI 3.1

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

When analysis is better using Web Intelligence than Excel

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 »

SAP BOE Security Model Patterns

Tuesday, April 13th, 2010

Security Modelling is concerned with two areas: authentication - establishing who the user is, essentially the logon process and authorisation - controlling user access to different areas of the system. This article discusses four different design patterns for authorisation security models that can be used in SAP BusinessObjects Enterprise. In SAP ...

Posted in Business Intelligence, Delivery Methodology, SAP Business Objects | 1 Comment »

Developing BI Applications

Wednesday, April 7th, 2010

This article looks at an approach to developing SAP BusinessObjects solutions where rather than just writing reports and universes we instead build a BI Application. The main benefit of this approach is a more efficient, streamlined and organised delivery process. A BI Application is viewed as a complete project where the ...

Posted in Delivery Methodology, SAP Business Objects | Comments Off

Date Maths – Oracle

Wednesday, March 24th, 2010

This article continues the Date Maths series and here we are using Oracle. Please refer to the previous articles on SQL Server and DB2 for similar calculations for those database systems. Please refer to the Oracle 11g SQL Reference for more information on the date functions used in this article.

Posted in Oracle | 1 Comment »