My Life with Business Objects: Top Ten Mistakes to Avoid in Universe Design - INTRO

My Life with Business Objects: Top Ten Mistakes to Avoid in Universe Design - IN...

Read more »

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

...

Read more »

Working with REF CURSOR in PL/SQL

...

Read more »

Enable Remote Connection on SQL Server 2008 Express

Enable Remote Connection on SQL Server 2008 Express ...

Read more »

Automate Backup Database on SQL Server, Part I: Create VB Script

Automate Backup Database on SQL Server, Part I: Create VB Script ...

Read more »

How to backup and restore database on Microsoft SQL Server 2005

How to backup and restore database on Microsoft SQL Server 2005 ...

Read more »

BO error messages

Computation errors#COMPUTATION in cumulative aggregations#COMPUTATION occurs in cumulative aggregations for the following reason:• The reset context is not included in the output context. Solution for #COMPUTATION in a cumulative aggregationTo avoid #COMPUTATION in a cumulative aggregation, the reset context mustbe included in the output context. In other words, the dimension or dimensionsafter the semi-colon (;) in the formula...

Read more »

Oracle By Example (OBE)

Oracle By Example (OBE)The Oracle by Example (OBE) series provides hands-on, step-by-step instructions on how to implement various technology solutions to business problems. OBE solutions are built for practical real-world situations, allowing you to gain valuable hands-on experience as well as use the presented solutions as the foundation for production implementation, dramatically reducing time to deployment. In addition to...

Read more »

How to Add to the List of Existing Connections

...

Read more »

Interactive Viewing with BusinessObjects Web XI

...

Read more »

Avoid overlapping months and years

Useful way to group data by week to avoid the quandary of weeks overlapping months and years.CREATE OR REPLACE PROCEDURE weekly_proc IS CURSOR x_cur IS SELECT DISTINCT SUBSTR(TO_CHAR(date1),4,3) m, SUBSTR(TO_CHAR(date1),1,2) w, COUNT (*) cntFROM cpad_errorsGROUP BY SUBSTR(TO_CHAR(date1),4,3), SUBSTR(TO_CHAR(date1),1,2); x_rec x_cur%ROWTYPE; week_var NUMBER; BEGIN EXECUTE IMMEDIATE 'truncate table week_test'; OPEN x_cur;...

Read more »

%TYPE vs %ROWTYPE

Both %TYPE and %ROWTYPE are used to define variables in PL/SQL as it is defined within the database. If the datatype or precision of a column changes, the program automatically picks up the new definition from the database.The %TYPE and %ROWTYPE constructs provide data independence, reduce maintenance costs, and allows programs to adapt as the database changes-- %TYPE is used to declare a field with the same type as -- that of...

Read more »

Business Objects XIr2 Installations step by step

https://share.acrobat.com/adc/document.do?docid=53d9c543-ef2e-453c-b577-9ab841966...

Read more »

SABE201 sample questions

http://businessobjectsforum.forumz.cc/viewforum.php?...

Read more »