|
WITH and Ranking Functions
by Charles Tournear, Senior Consultant,
MCT,
MCSW,
MCSD,
MCBA,
CRCP
The WITH clause, in the Transact-SQL language,
specifies a temporary named query result set, known as a common table expression
(CTE). This is derived from a query and can be used within the execution scope
of a SELECT, INSERT, UPDATE, or DELETE statement. This clause can also be used
in a CREATE VIEW statement as part of its defining SELECT statement. A common
table expression can also be recursive by including references to itself in the
CTE definition.
Read the full article...
Designing Enterprise Security
by Troy Gottfried, Sr. Consultant, BECP, CRCP
There are two types of security in BusinessObjects Enterprise:
(1) Content security and (2) application security.
Securing content includes setting permissions at the global level, folder
level, and sometimes even the object level (i.e., report level or document
level). Application security
encompasses all of the application components that make up the Enterprise
platform: Infoview, Central
Management Console, Designer, Web Intelligence, etc….
While application security is a very important topic, it is difficult to
make suggestions at a conceptual level without full knowledge of the user
environment. Therefore, the
remainder of this article will focus on content security.
Read the full article...
|
Connect Crystal Xcelsius to Crystal Reports
by Kristen St. Jean, Sr. Consultant, CRCP
You may have a need to use data calculated by a Crystal report in an Xcelsius
document. For example, your Crystal
Report may calculate the Sales Revenue for each division, and you would like to
place the actual sales revenue in an Xcelsius document to allow for analysis
using selectors and charts.
Read the full article...
|
Microsoft Business Intelligence
|
Excel Table Analysis
by Michael Mullin, BI Consultant
One aspect of Business Intelligence (BI) is data mining.
You can think of data mining as finding
information in your data that is not readily apparent.
For instance, a business might have an order processing system running on
SQL Server. Such a system would have a
set of tables containing all the data it has on its customers and another set of
tables containing all the data about orders. The system is designed to handle
orders. If you were to request
information for John Smith’s order placed on May 1st, this system
could provide it. That is not data
mining. The system is simply retrieving
data it was designed to create, store and retrieve.
Read the full article...
SSIS Looping with an
ADO Recordset -Part 2
by Sean Beal, Sr. Consultant, CRCP
Last month, we began creating an SSIS
(SQL Server Integration Services) package that leverages the Foreach Loop
container to populate a text file from an ADO Recordset.
We configured variables, a SQL task, and a Foreach Loop container.
This month, we’ll complete our package by defining the Data Flow objects
within the loop that will actually create the desired destination file.
This article assumes a basic working knowledge of SSIS and the Business
Intelligence Development Studio (or Visual Studio 2005).
Read the full article...
|
