Your quarterly dose of business intelligence tips & tricks. Issue 1 - Q2, 2005
   

Welcome to the first edition of the ClearPeaks BI Tips & Tricks eZine. We have truly enjoyed pulling together what we feel is a diverse and handy mix of how-to articles and tutorials for the top BI software tools on the market today.

We hope you enjoy the ClearPeaks BI Tips & Tricks eZine. Understandably since this is the first edition we don’t assume to have it all figured out yet. In fact, what we hope is that you might take a moment to share your thoughts on how we can make Issue 2 even better—something you will look forward to receiving time and time again. Simply click here to share your thoughts or ideas with our editor.

Happy reading!
The ClearPeaks Team

 

 

Contact ClearPeaks:
ClearPeaks (headquarters)
Valencia 266 3, 1
08007 Barcelona, Spain
Tel +34 93 272 1546


Editor

Angela Carson

Contributors
Alex Caminals
Emma Gorgori
Gianluca Nacci
Oswaldo Salazar
Jose Antonio Hernandez
Moïse Kameni

If you prefer to be excluded from future correspondence and issues of the ClearPeaks BI Tips & Tricks eZine, please REPLY to this email with the word REMOVE in the subject line.
 
BusinessObjectsView all BusinessObjects tips
Simple workaround for a ‘where’ clause in 2nd-tier variables
In this tip, we will create a chart where one of the variables of the axis is calculated. The calculated variable is based on a measure from the universe and contains a formula, in our case a ‘where’ clause.
Say goodbye to pivot tables by super-charging your .txt (or .xls) files
For many business managers, pivot table is the buzz word of the year. The truth is that BO beats Excel in power of analysis and versatility, especially if your file happens to have 65,537 lines!
The ABCs of ZABO
ZABO—or Zero Administration BusinessObjects—is a mix between full and thin client architecture with no client administration. Walk through the pros and cons, go step-by-step through the installation process, and learn about version migration.
Apply universe visibility rules to keep your data safe
Improve your organizations data security and limit user access rights to just those BusinessObjects reports that pertain to each individual, team, or region in this simple and thorough tutorial.
 
Siebel AnalyticsView all Siebel Analytics tips
Produce reports with style using Cascading Style Sheets
Siebel Analytics Answers gives developers additional flexibility to create personalized reports by customizing the appearance of reports using Cascading Style Sheets in conjunction with Font, Cell and Border formatting options.
Custom drill-downs simplified
Navigation—or drill-down—in Siebel Analytics is usually determined by the configuration of the business model in the Analytics Server. However, Siebel Analytics Answers lets developers create their own custom navigation.
 
OracleView all Oracle tips
Tablespaces designed to end disk conflicts
Even though indexes are carefully organized when a database (DB) is initially designed, after time passes and new indexes need to be created, we sometimes forget about the importance of index disk location.
Create indexes built for speed and efficiency
A lot of effort is put into designing indexes to be as efficient as possible. However, when an application is in production and new indexes need to be created, the fact that indexes can be reused is often overlooked.
 
SQL ServerView all SQL Server tips
Simple tricks to speed up your DTS performance
Is your extremely important Transform Data Task slower than a turtle? Follow these simple tricks to speed things up.
 
 

ClearPeaks In the News
Universal Music Netherlands chooses ClearPeaks' ReportMessenger Report Delivery Software
New tool automatically refreshes, personalizes and delivers BusinessObjects reports.


BI Framework
How solid is your BI foundation?
The right foundation is the cornerstone to any business intelligence effort. Whether your organization has a BI infrastructure in place or you are in the early stages of building one, our experienced team is here for you.


Never manually refresh or deliver BusinessObjects reports again

Learn how ReportMessenger can do it for you!


Educational services
In-Depth Reporting with BusinessObjects®

This 2-day course is aimed at end-users who need to be up-to-speed with a solid working knowledge of Business Objects reporting quickly.