BusinessObjects Topics

Search This Blog

BusinessObjects Topics

Wednesday, October 28, 2009

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 »

Tuesday, October 27, 2009

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 »

Tuesday, October 20, 2009

How to Add to the List of Existing Connections

...

Read more »

Interactive Viewing with BusinessObjects Web XI

...

Read more »

Monday, October 19, 2009

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 »

Pages (16)123456 »

Tags

Oracle Data warehouse Business Objects Business Objects XI R2 Business Objects XI 3 PLSQL BOBJ BI News Business Objects FAQs bo DataModeling Concepts Databases Server Administration BOCP-BOE Business Intelligence (BI) MS SQL Sever Database Universe Designer Certification Designer REPOSITORY SAP BI SAP Education Supervisor BO Reporter/ functions BO XI 4.0 BOXI 3.1 Business Objects Designer Downloads Fan / Chasm Trap Functions Integration and Certification Loops MS SQL Sever Administration OLAP QaaWS SAP Business Objects SAP BusinessObjects Business Intelligence 4.0 Star Schema Universe Design Web Intelligence WebIntelligence