Sunday, July 27, 2008

What are those guys in Bangalore and Beijing upto?

With globalization time is not the only constraint and we need to contend with space (location, fortunatlely on earth). Storing Spatial information has become very important to know what those guys are doing in Bangalore or Beijing.

SQL Server 2008 can handle this very well. If you believe the earth is flat you can use the 'Geometric' data, on the other hand if you believe the earth is not flat but round (or oval) you cannot just use coordinates but you use longitudes and latitudes, in other words the geographic representation. SQL Server 2008 handles both of them well.

This time around Microsoft is doing it properly, I mean, adhering to well known standards. Open Geospatial Consortium (OGC) Simple Features for SQL Specification version 1.1.0 in the case of Geometric data and uses well known GPS latitude and longitude coordinates for geographic representation.

I will be back next time with more on this.

Friday, July 25, 2008

Give generously to the International Rescue Committee

For the forlorn, the forgotten and for those whose hopes appears to have foreclosed.

Give generously your time and resources to this organization



International Rescue Committee

Creating a Cube in SSAS 2008



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 buried 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, etc. We also notice that there are certain measures that we are interested in 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 on ---> Part 2

Cube with SSAS using VS2008
DMCA.com Protection Status