How to diff universes using Universe Documenter

I have added a new feature to the tool Universe Documenter which allows to find differences between universes. I will describe on an example. Let's open Island Resorts Marketing universe and make some changes: remove table Age_group and object Age group, and save the universe with a different name. Now we will start the tool, open the […]

Universe Documenter

The tool exports BusinessObjects universe metadata into Excel file including information about objects, predefined conditions, tables, joins, contexts, index awareness and incompatibilities. Requirements Microsoft .Net Framework 3.5 BusinessObjects XI 3.1 SP3 Microsoft Office 2007 or OpenOffice 3.0 Installation The tool is provided and supported by biclever.com. The tool is build using Express version of Visual Studio, […]

Comparison of database schemas

Suppose we need to compare two database schemas to find out changes such as new tables, columns, and change of data type. Test create user USER1 identified by USER1; create user USER2 identified by USER2; create table USER1.T1 (C int); create table USER2.T1 (C int); create table USER1.T2 (C int); create table USER2.T3 (C int); […]

+0 does matter in Web intelligence

In university I learned that adding zero does matter sometimes. However I did not expect to see this in Web Intelligence. The fact is that the following two expressions are not the equal: =(Average([Revenue])) In ([Year]) =(Average([Revenue])+0) In ([Year]) The query: The result: So the expression (Average([Revenue])+0) In ([Year]) is not equal to (Average([Revenue])) In […]

Getting started with BusinessObjects Java SDK

BusinessObjects Report Engine Java SDK is primarily used for Web Intelligence customization. This post describes how to start development of a command line tool. Such tools can make life of report developers easier. They can be used for: Documentation creation. Simple corrections and layout changes. Purging data from Webi documents. Automatic tests. You will need: A […]

SAS Methodology

SAS® Project Management Methodology SAS® Intelligence Platform Implementation Methodology SAS® Intelligence Solution Implementation Methodology Project Management Methodology Project Qualification Project Definition Project Planning Project Execution Project Summation Intelligence Platform Implementation Methodology Platform: Assess and Define Analyze and Evaluate Design Construct Load Final Test Deploy Platform Review Ongoing Operations and Maintenance Data Quality: Analyze Data Quality […]

How to print explain plan

DELETE PLAN_TABLE; EXPLAIN PLAN FOR SELECT * FROM t WHERE group2=1; SELECT * FROM TABLE(dbms_xplan.display()); Oracle utilities The Oracle utility creating PLAN_TABLE: D:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlxplan.sql The Oracle utility displays the last explain plan. It displays also parallel query information if the plan happens to run parallel: D:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlxplp.sql The utility that does not displays parallel query information (sequential). […]