Articles with this tag assume an intermediate knowledge within this category.
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 new class which contains a “using…
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 containing information about people. On the “Person”…
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 “GROUP BY” statements and then had to…
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…
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…
Combine data from worksheets into a new worksheet. Beginning with two worksheets containing fictitious data where both share a column – you need at least one “key” between the two, I will use Excel to combine both sheet’s data into one worksheet. First, save the spreadsheet somewhere easily accessible. Define Dataset Ranges In Excel, name…
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…
