|
A Better Way EXISTS
by Sean Beal, Senior Consultant,
CRCP
Regularly, the COUNT(column) function is used to evaluate not only the
number of rows returned, but also to check whether any rows are returned
at all.
Read the full article...
|
Customer Relationship Management |
The Blurred Line Between CRM & Business Intelligence
by Thomas Meers, President, Principal Consultant
As companies finalize their efforts to automate key business areas like ERP and
operations management they are turning to Customer Relationship Management (CRM)
and a new concept called Customer Data Integration (CDI).
The line between how customer data is
managed and how it
analyzed
is beginning to blur.
Almost every aspect of operational and strategic Business Intelligence
(BI), another key focus for most business, involves the use of customer data and
dimensions that directly relate to customer service and sales.
CRM systems have traditionally addressed
this need by providing operational reporting and built-in dashboards.
However, today’s decision makers are
demanding that customer centric data be integrated with information from other
systems of record such as ERP and operations.
Read the full article...
|
Repository
by Kristen St. Jean, Sr. Consultant, CRCP
Crystal Decisions first introduced the Repository
in Crystal Reports version 9. In version 10, Crystal Decisions moved the
Repository into the managed Enterprise
environment. Because the Repository was
now part of the System Database, the Repository honored Enterprise security.
Read the full article...
|
Microsoft Business Intelligence
|
Don't Care Yet - Now You Should
by Troy Gottfried, Sr. BI Consultant,
CRCP, BECP
In the first installment of
this series, we discussed the advantages of utilizing the Unified Dimensional
Model (UDM) in Microsoft SQL Server 2005 Analysis Services.
We saw how hierarchies, categories, and built-in time dimensions help to
save development time and capitalize on the time invested in implementing
Microsoft’s new semantic layer. This
issue will continue the discussion, focusing on Key Performance Indicators
(KPIs), Perspectives, Attribute Semantics, and cube write-back capabilities.
Read the full article...
Understanding CMS Startup Procedures
by Joe Roberts, Sr. Consultant, BECP
There is always a good deal of
confusion about how the CMS works, what it does during startup and how this
effects the system. Well sit back and relax my friends, I’m about to de-mystify
the inner workings of the CMS.
Read the full article...
|
