[MS SQLServer] USE [Gigasoft] GO /****** Object: View [dbo].[vTerrain] Script Date: 1/08/2015 10:31:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[vTerrain] AS select * from ( select x, z, y from Gigasoft..Terrain ) src pivot…
UNPIVOT: Converting columns into rows
Convertion of columns into rows is widely used in real tasks. In this article we will talk about different implementations of T-SQL UNPIVOT transformations. Let’s assume we have an aggregated table which contains data about results of the games played…
ADO OLAP
Dim cnPubs As ADODB.Connection Dim cn As ADODB.Connection Dim cat As New ADOMD.Catalog Dim cs As ADOMD.Cellset Dim lIndexCS as long lIndexCS = 0 Set cn = New ADODB.Connection cn.ConnectionString = “Provider=MSOLAP.2;Integrated Security=SSPI;Persist Security Info=False;Data Source= your SQL Server ;Initial…
ADODB for Python
(c) 2004-2005 John Lim (jlim#natsoft.com.my) This software is licensed under a BSD-style license. See LICENSE.txt. Introduction Databases Supported Bug Reports and Help Installation Tutorial Connection Examples Function Reference Error Handling Bind Parameters Changelog Introduction ADOdb is a database abstraction library…
SSAS Deployment Strategies
Introduction Building a data warehouse and then a cube based on the data warehouse has become child’s play, thanks to Microsoft’s business intelligence tools. SQL Server Analysis Service is used to build cubes for slicing and dicing data. After the…
SQL Server Business Intelligence Features – Creating a Simple OLAP Cube
Introduction Multidimensional cubes and transactional databases are two very different things. From experience I have seen even veteran DBAs avoid the subject of cubes completely because it is too much of an unknown area for them. Often cube work…
Build a Cube From an Existing Data Source Using SQL Server Analysis Services
Problem We are just getting started with SQL Server Analysis Services and trying to build our first cube. We have an existing relational data source to use as our starting point. There are a number of steps involved in building…
Create First OLAP Cube in SQL Server Analysis Services
Learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse Download SalesDataAnalysis.zip – 53.7 KB Download Data_WareHouse__SQLScript.zip – 8.1 KB Introduction This article is created to help those…
SQLServer LinkedServer
USE [MarketData] GO /****** Object: StoredProcedure [dbo].[spLinkedServer2Access] Script Date: 19/05/2015 10:24:19 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[spLinkedServer2Access] @Symbol nvarchar(50) = NULL out AS BEGIN SET NOCOUNT ON; /****** Object: LinkedServer [LMD_ACCESS] Script Date:…