Posts By: dmytro

Multiple selection in a TreeView

Posted by & filed under C#.

The code demonstrates an example how multiple selection can be implemented in C# using TreeView control. Download Source Code

Universe Documenter

Posted by & filed under Tools.

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

Posted by & filed under Oracle.

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); […]

Regular backup of BOE

Posted by & filed under Administration.

Sometimes the only thing people do to backup BusinessObjects Enterprise server data is to backup CMS database. Unfortunately CMS database does not contain universes, documents and other stuff, it has only metadata about them (ids, descriptions etc). Backup of CMS database is not enough to restore the system from the scratch. Complete BIAR is often […]

+0 does matter in Web intelligence

Posted by & filed under 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

Posted by & filed under 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

Posted by & filed under 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

Posted by & filed under Oracle.

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). […]

Kimball data warehouse lifecycle

Posted by & filed under Methodology.

There are three tracks (beside Project Management) that running in paralel: technological, data and business intelligence. Yes, theoretically it is possible to run them in parallel, but it seems that such practice is quite rare. It would be interesting to hear an example of a True Kimball Project.