MVC: Custom Validation

Please see my other MVC articles. Using Custom Validation within a View While MVC provides many robust attributes within a Model to satisfy many validation scenarios, some situations exist which require custom logic to validate a user’s input. This article will illustrate how to implement your own routines to validate user input. First, create a…

T-SQL: Common Table Expressions

Please see my other Database Development articles. Performing Recursive Queries. Prior to SQL Server 2005, performing recursive actions on data required the use of temporary tables, cursive, or some other memory-intensive method. Now, performing such operations requires much less code and avoids the previous performance increase. For this example, we’ll begin with a generic table…

T-SQL: Rank()

Please see my other Database Development articles. Ranking Functions There are several new impressive advancements in the latest version of t-sql; this article will focus on “Ranking” functions. Prior to the release of SQL Server 2005 with its t-sql enhancements, working with blocks of related data was clunky at best. T-sql authors mostly relied on…

SSAS Viewing a Cube in Excel

Using Excel to View Cubes and Configure Pivot Table Reports Similar to my article SSAS BIDS Cube Browser, Microsoft provides another tool for any end user to view a cube’s measures and dimensions to configure highly analytical reports. First, use the wizard under the Data tab to configure an connection to your cube. In the…

SSAS: BIDS Cube Browser

Using BIDS to Configure Cube Reporting Microsoft provides a cube browser within the Business Intelligence Development Studio (BIDS) which allows a developer to view cubes and construct reports using dimensions and measures.  The functionality is similar to using Excel to view and configure cube reporting. For this article, I will use the sample data warehouse…

SSAS: OLAP Schemas

Arranging Database Tables to Support Rich, Effective Analysis In traditional systems used for e-commerce or other common input/edit systems commonly referred to as online transactional processing (OLTP), there should be no instances of duplicate data, for OLAP the opposite is true. For OLTP systems the focus is on the fastest method of providing high-volume additions…

Cognos Development

Cognos Development Cognos: An Overview Cognos: Framework Manager Cognos: Report Studio – Objects Types Cognos: Report Studio – Creating a Report Cognos: Report Studio – Filters and Prompts Cognos: Framework Manager – Relations Cognos : FrameWork Manager – Models Cognos: Report Studio – Report Advancements

SharePoint: Working with Workflow variables

Using SharePoint Designer to create custom workflows for sending alert emails. When collaborating on SharePoint lists, some team members may need notification when actions are performed on lists. For example, let’s pretend a user wishes to be notified via email when an item is added to a list. To illustrate this functionality, I will begin…

SharePoint: Workflows with Custom Alerts

Using SharePoint Designer to create custom workflows for sending alert emails. When collaborating on SharePoint lists, some team members may need notification when actions are performed on lists. For example, let’s pretend a user wishes to be notified via email when an item is added to a list. To illustrate this functionality, I will begin…