Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Linear reference / Location as a dimension

Author  Topic  john c Starting Member 1 Post Posted - 2007-09-07 : 19:01:22 Is it possible to build a dimension within a cube such that the data is referenced by a linear location? Let me explain, there are items along a route that are points or linear features. Along the route there can be a number of linear features (begin location, end location), all stopping starting at different locations, overlaps, gaps, and points (a single location). All this is stored in a db with references to the type of feature, such as material of road, install date, contractor, political boundaries, whatever. Trying to query and bring all these diparate "locations" together is difficult and requires a cursor scroll operation. Can a dimension be built on all the locations and the dimensions of the different features can be queried to detrermine the overlaps? john c