|
Welcome to this year's second edition of the ClearPeaks
BI Tips & Tricks eZine.
We are really happy to announce that
ReportMessenger 3.5 is fully compatible with BO XI R2.
In this eZine we
are mostly focusing on Business Objects and Siebel Analytics. Although you can
also read a handy tip about Oracle. Last but not least we added a section about
ClearPeaks in general. This time you can read about one of our products 'FastTrack
BI'.
At the bottom of this eZine you can win an iPod Shuffle, so take
a look!
If you think that a topic is not being covered
or if you have a good suggestion for a how-to article, please tell us by sending
us an e-mail or 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 ClearPeaks
Tarragona
Plaza Peixateries Velles 3, 2
43003 Tarragona, Spain
Tel
+34 97 725 0778 |
Editor
Anoek Aukema
Contributors
Alex
Caminals
Victor Castellá
Victor Cutilla
Emma Gorgori
Moïse
Kameni
Jordi Ricart
Albert Seco
|
If
you prefer to be excluded from future correspondence and issues of the ClearPeaks
BI Tips & Tricks eZine, please REPLY to this e-mail with the word REMOVE in
the subject line. | | |
 |
| | Applying
filters on Measures - Mission Impossible?
Occasionally
when developing BusinessObjects reports, it is required to filter the results
based on a measure. If this measure contains a complex formula or if there are
different levels in the same hierarchy, it might seem like a 'Mission Impossible'.
Nevertheless, this article will demonstrate how this can become a Mission Possible.
| Importing
.txt files - what happened to my data type?
Most
BusinessObjects users who have imported .txt data providers before, have encountered
the issue of unexpected data types. For instance, if in a txt file you have a
field (i.e. the price of an article) which of course after importing you expect
to be numeric. However, after importing the .txt file you realize that the specific
field displays as a character data type. Follow six steps and your problem will
be solved. | Effective
BO Universe Deployment
This
is a trick to use one unique BusinessObjects (BO) universe file hitting different
database environments with different database names. The advantage is that there
is no need to maintain two or more different BO universes and therefore reduce
time, effort and cost. | | |
| Configuring
LDAP for Siebel Analytics
Find
out which steps should be followed in order to have an existing enterprise Lightweight
Directory Access Protocol (LDAP) integrated with the Siebel Analytics reporting
tool (Enforcing all the rules, security restrictions, etc. already defined within
the organization). | Siebel
Analytics 7.8 - Enhanced Functionality with 'Bins'
With
the release of Siebel Analytics 7.8 a powerful new feature has been incorporated
– “Bins”. Bins provide the power user with access to Siebel Answers
with the ability to group one or more variables in different ways depending on
his needs. This avoids the dependency on the Administrator. |
Learn
more about Data Load Statistics for Siebel Analytics
Database
statistics are considered a very important task to improve query performance.
This article gives an overview and tips to provide a better understanding of Data
Load Statistics (DLS). | | |
| Avoiding
misuse of the SYSTEM Tablespace
In any Oracle
database, the SYSTEM tablespace contains all the internal objects used by the
database server. Whenever a SQL statement is sent to the database, many operations
such as checking permissions on the tables and views during the parse of the SQL
statement require access to the information stored in the SYSTEM tablespace. Allowing
users to create their own tables in this tablespace is a bad practice as that
will affect the overall database performance. | | |
| FastTrack
BI: Unleash the power of your data
FastTrack
BI brings the business intelligence contained in your CRM Solution to life, letting
you make more profitable decisions and dramatically improve your return on investment.
|
|
| ClearPeaks
In the News
Picis
implements ClearPeaks' FastTrack BI™ for Siebel CRM
This real-time analysis will allow Picis to easily
tap into the wealth of customer information. Read the article.
Win
an iPod Shuffle
Do
you know someone who is interested in our Tips&Tricks eZine?
If
you sign up somebody who is interested in our eZine
with name, e-mail, company and country details, not only he or she can win an
iPod shuffle, but you can as well. Let the interested person send us an email
with your name mentioned before the 31st of July. The winner will receive a personal
message before August 4.
|
ReportMessenger
 ReportMessenger
3.5 is fully BO XI R2 compliant
Our new release is fully compatible
with BO XI R2, BO 6.x and 5.1.x.
 Refresh,
personalize and distribute your Business Objects reports effortlessly and reliably
- on time, every time.
ClearPeaks
Educational Services
Intensive Siebel Analytics Answers for end-users
This
Intensive training course is aimed at end-users who need to learn the necessary
skills required to quickly retrieve information, develop flexible dashboards and
distribute business intelligence effectively in your organization using Siebel
Analytics.
| | | |
| |
