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 »