In the previous part of the article, we had a look at the Report Builder overview and described the Report Builder 2.0 interface. In this part by Jayaram Krishnaswamy, we will discuss about Enabling and reviewing My Reports, and will see how to Modify a basic report.Read Working with the Report Builder in Microsoft SQL Server 2008: Part 2 in full
As noted in Part 1, OLAP presents Business Intelligence via what is known as a CUBE. A Cube has many dimensions and it provides a faster method to access the intelligence compared to the structured querying where the overhead of 'Joins' makes it inefficient. Taking the example of a 'Sales' Cube having everything related to sales we can identify the dimensions as the Sales Outlet, The Customers , the Products and the time period over which sales are being audited or looked into. We also notice that there are certain measures that we are interested related to these 'dimensions' like 'Store Sales', 'Cost of Products, 'number of units sold' etc. The Analysis Services analyzes these intricate relationship that exist in a cube. In this part we will see the process of creating a Cube in VS 2008.Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 2 in full
Microsoft Windows Mobile Platform is now fully supported with .NET technology. We can develop and deploy .NET-based applications directly on to smart devices enabled with Microsoft Windows Mobile operating system.This article by Jagadish Chatarji Pulakhandam and Sunitha Paruchuri shows an example of deploying such an application.Read Deploying .NET-based Applications on to Microsoft Windows CE Enabled Smart Devices in full
In the first part of this article we concentrated on two aspects Problem and Design. We started with the Problem, that is, defining what we need to implement the Friends concept, finding and inviting friends to join our network and developing an alert system. We then moved to Design wherein we actually finalized the requirements. And finally we began with the Solution, that is, actually implementing the features. In this part of the article by Andrew Siemer, we will continue with the solution part.Read ASP.NET Social Networks—Making Friends (Part 2) in full
A cube in the context of Business Intelligence is a multidimensional representation of business facts that can be accessed quickly to provide specific information. (This can be accomplished by properly written queries in a relational database, but the overhead involved in processing the query, which may involve a large number of 'joins', is simply not efficient). While a relational model is more suited to OLTP, a different model is necessary for OLAP. Whereas highly normalized tables are a norm for OLTP, the model for OLAP does not require normalization. The SQL Server Analysis Services that supersedes the earlier versions is specifically meant for analyzing data in the archives or in OLTP databases to be retrieved and burnished to provide the 'Intelligence' by mining for facts hidden in the data. This two part article by Dr. Jayaram Krishnaswamy describes how a Cube is designed using Visual Studio 2008 and how it may be browsed on the Analysis Server. In Part 1, the necessary items for creating the Cube, namely the Data Source and Data Source Views are described.Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 1 in full
In this article by Alexandru Serban, let's take a more realistic software development scenario. What I am going to build is a room-reservation system for the newly launched Orbital Hotel. As you well know, this is the very first space building, after the International Space Station, used for tourism, allowing people to enjoy a view of our blue planet and stars from their private rooms. OK, OK, the Orbital Hotel doesn't yet exist, but when it does, it must have a room reservation system anyway. Who knows, it might be this one.Read Visual SourceSafe:Creating a Service-Oriented Application in full
Developing AJAX applications that involve complex client-side programming and communication with the server side raises the need for equally complex debugging tools and techniques.
Most of today’s AJAX frameworks, including the Microsoft AJAX Library, offer built-in capabilities for debugging and tracing.
In this article by Cristian Darie and Bogdan Brinzarea, we will learn about the capabilities built in the Microsoft AJAX Library, and we’ll also learn about third-party debugging and tracing tools.Read Debugging AJAX using Microsoft AJAX Library, Internet Explorer and Mozilla Firefox in full
The secret of getting ahead is getting started. The secret of getting started is breaking your complex overwhelming tasks into small manageable tasks, and then starting on the first one—Mark Twain
In this article, we will cover the data types that you are most likely to use. We will also take an overview of the others. In addition, we will also cover field classes, which are where the special features are enabled.Read Data Types in Microsoft® Dynamics™ NAV in full
Filtering is one of the very powerful tools within NAV C/AL. Filtering is the application of defined limits on the data to be considered in a process. Filter structures can be applied in at least three different ways, depending on the design of the process.
Read Filtering in Microsoft® Dynamics™ NAV in full
SQL Server Integration Services, using its designer interface, or BIDS, has made it possible to process data using many of the data flow related items in its Toolbox without writing a line of code. This is a very attractive option for someone who is a beginner with some knowledge of databases, and for end users who may want to look up some detail buried in the data. This tutorial by Dr. Jayaram Krishnaswamy shows how the designed package extracts data from an SQL Server 2005 and processes it using several of its built-in transformations.Read Data Processing using Derived Column and Aggregate Data Transformations in full