|
What's the Latest?
by Sean Beal, Senior Consultant,
CRCP
Transactional systems often need to track a history of
recurring events. Whether the
recurring entity is an ‘Order’, ‘Appointment’, or ‘Review’, very often there is
a need to see only the latest instance of that entity.
One way to accomplish this is through the use of a sub-query and view.
Read the full article...
It's All Semantics
by Joe Roberts, Principal Consultant, BECP, SLE, MCP
The biggest hurdle to delivering effective “self-service”
BI and/or Operational Analysis is the design of the semantic layer. The biggest
hurdle in the design of the semantic layer is in understanding what the semantic
layer must provide to the BI platform.
Read the full article...
|
Crystal Reports Repeated Group Headers
by Kristen St. Jean, Consultant, CRCP
Crystal Reports has many
functions that we can take advantage of to create calculations and/or manipulate
the ways that our data displays.
This month we will discuss a function specific to groups.
Read the full article...
|
Microsoft Business Intelligence
|
SQL Server Analysis Services - The Unified Dimensional Model (Part 1)
by Troy Gottfried, Sr. BI Consultant,
CRCP,
BECP
This article
discusses why we should care about semantic layers and how they are becoming a
standard in almost all Business Intelligence (BI) solutions implemented today.
Read the full article...
Data Integrator:
Using Stored Procedures
by Tom Hinkle, Consultant, CRCP, Data Integrator Instructor
Stored Procedures are not part of the Data Integrator
class curriculum and are mentioned in the reference material but not a lot of
detail is provided. You are able to call
a database stored procedure anywhere that a SQL statement can be written.
Read the full article...
|
