Archived Months
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server data warehouse > july 2006

MS Analysis service over the web
Posted by msnews.microsoft.com at 7/28/2006 10:35:11 PM
Can I access the MS Analysis service over the web to delivery data to my customers that use Pivot Excel tables? RMelo...more >>


excel add-in
Posted by swetha at 7/28/2006 1:59:14 PM
Does the add in for excel work against RS reports? Does it work against local cube files? ...more >>

Client tools to view cubes
Posted by RMelo at 7/28/2006 12:00:00 AM
Hello! I'm a new in DW world and I'm searching for tools to my clients view the cubes generated using SQL 2005. I already found some good products like "Business Objects" toolset but the price is inacessible... :-( The problem to use Excel to visualize the data, for example,...more >>

data ware housing
Posted by vidhya at 7/28/2006 12:00:00 AM
Hai i have just started to learn about the concepts of dataware housing. i came to know there are about 5 services in data warehousing. Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4 Notification services and 5 Reporting services.my doubt i that is there any order...more >>

offline cube
Posted by swetha at 7/26/2006 9:41:57 AM
Hi I tried to view the offline cube created through MDX in a system without Sql server 2005. The error is that there are no visible tables in the data source. The .cub works fine in my m/c with excel 2003(I have SS 2005) So, how do i make it work? ...more >>

fact-less fact table
Posted by vidhya at 7/26/2006 12:00:00 AM
hai can you get give me some ideas for constructing a fact table for dataware housing.And also about the different types of measures in the fact table like full additive measures,semi-additive measures and fact-less fact table vidhya ...more >>

SQL Server 2005 64 bit Connect to Informix.
Posted by Tam OShanter at 7/25/2006 4:02:01 PM
Hello, Looking to see if anyone has had any success with 64 bit drivers for Informix. Specifically, trying to import data into an SQL Server 2005 datawarehouse box with limited success. Any all responses welcome. Thx. Tam. ...more >>

Data Warehousing
Posted by vidhya at 7/24/2006 5:41:09 PM
HAI i have read about few pages in Microsoft dataware housing toolkit by ralph kimball.i find it little difficult and vague to understand the concepts.so i kindly request anybody who have worked with dataware housing to recommened me a book to get a clear picture to start with and then to ...more >>



datawrehousing
Posted by vidhya at 7/24/2006 11:27:18 AM
hai, Am using sql server 2005 standard edition ,can you suggest me any book to get started with data ware housing. Thank you ...more >>

Create star schema in SQL Server 2005?
Posted by Ronald S. Cook at 7/23/2006 4:55:45 PM
Consider me brand new to data warehousing. I'm looking for a simple, real-world example taking a simple transactional table, and getting all "data warehouse" on it. I know there's a star schema to design, but wouldn't I just do that within a regular (OLTP) database? We're looking to get...more >>

unable to deploy analyses services sample project
Posted by julian.kooiker NO[at]SPAM gmail.com at 7/18/2006 2:35:39 AM
I have succesfully followed all the steps in the tutorial, but when I have to deploy my project I get some error messages: Error 1 The following system error occurred: Logon failure: unknown user name or bad password. . 0 0 Error 2 Errors in the high-level relational engine. A connection cou...more >>

Passing strongly typed parameter to MDX to Reporting Services 2005 via URL
Posted by Boby Huntington at 7/17/2006 7:21:21 PM
Hi guys, We've been developing a BI project with SQL Server RS 2005 and AS 2005. The problem is client needs to access RS reports through URL. Things are fine in query analyzer and report manager. However; MDX queries written by the db team expect strongly typed parameters (dimension.hirarcy....more >>

Cube Deploying error in SQL2005
Posted by P at 7/16/2006 2:36:01 PM
Hi All When I deploy a cube it starts processing then comes up with the error "connection was either timed out or lost". This also manages to stop the Analysis Services Service on the Server. Any ideas? Thanks Pete...more >>

Analysis Services Cube using SQL2000 database
Posted by P at 7/12/2006 10:52:01 PM
Hi All I'm trying to build my first Analysis Services (2005) cube based on fact and dimension tables on a SQL200 database on a different server. I'm having problems setting up the data sources - I'm assuming I need two: one for the source SQL2000 tables and one for the target SQL2005 cube....more >>

Creating your first data warehouse
Posted by weluvpaul NO[at]SPAM hotmail.com at 7/6/2006 3:12:53 PM
Hello, I am doing a research project on data warehousing so that I can see what it can do for my workplace. I have googled on this subject and the web sites I found relating to this have not been too detailed. I have a basic set of data and business questions that I want answered already scop...more >>

SCD component in IS
Posted by Stijn Verrept at 7/1/2006 12:13:27 PM
I have a table that I'm importing with IS and a slowly changing dimension component. I followed the wizard to say which columns are historical and which are fixed (I don't have any changing columns). I have a From and Until column in my destination table so I set those too in the wizard. I u...more >>


DevelopmentNow Blog