MVC: Class Diagram – Building a Class

Please see my other MVC articles. Leveraging a GUI tool to quickly construct a class. In this article I will demonstrate Visual Studio’s Class Diagram tool which allows developers to quickly construct a C# class with much less errors. First, I’ll create a new model class to demonstrate this feature. Next, I’ll invoke the tool.…

SSAS Designing a Cube

Ensuring Rich Reports based on Cubes Often when beginning business intelligence development, specifically within data warehouses, a team may inefficiently “reinvent the wheel” rather than leverage existing reports and processes which may prove valuable to the organization. When cubes are designed, even new ones, the following steps will help to ensure the data they produce…

T-SQL: Format Date Values

Please see my other Database Development articles. Leveraging Format() for greater control over date values. When displaying date values from a resultset, it is common to reformat them according to various specified business rules. Using the t-sql Format along with specifying pattern provides an easy-to-use method, especially when abstracted into a reusable user-defined function.

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

SSRS: 2008 Updates

New features and updates to the latest version of Reporting Services. Here are just some of a few of my favorite improvements made to the 2008 release of SSRS. The most noticeable to me was the absence of the “Data” tab within the designer. Instead of having to click back and forth between tabs when…