The code demonstrates an example how multiple selection can be implemented in C# using TreeView control. Download Source Code
Posts By: dmytro
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, […]
This code sample shows how BackgroundWorker can be used for progress bar.
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); […]
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 […]
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 […]
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® 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 […]
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). […]
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.