Is it possible to teach myself Analysis Services and then claim to be a Junior Data Warehouse guy? I've been a DBA for 4+ years now and have...

ChrisR

08-18-2005 05:11 AM
Peter Nolan

Hi, What's the best way to handle data reloads when you have implemented Type 2 slowly changing dimension? For example, you might have an Account...

Wreck

08-18-2005 04:50 AM
Peter Nolan

Hi again, I come back with my HD issues on a SAN. I'm looking for sample scripts or tool to benchmark my system we do some changes and we'll do...

Jéjé

08-17-2005 05:35 PM
Jéjé

Hi, We need Analysis Service 2005 connect to Teradata directly, but we can¡¦t find the way. There is no odbc driver selection in AS 2005. How can we...

Byron

08-17-2005 04:04 PM
Dave Wickert [MSFT]

Hi, I am new to OLAP / Datawarehousing -- have been reading a lot and have started trying SSAS2005. My questions/requests are: Could someone please...

Ray

08-16-2005 04:30 PM
Ray

I have a pretty simple question. How do you extended the time out value for remote procedure calls between linked servers? Currently I have a...

sfibich

08-16-2005 09:37 AM
sfibich

Hi, To try to improve my performance on a system where I have no control (a long long story...) My problem: the HD subsystem is "bad", I'm on a SAN...

Jéjé

08-16-2005 07:11 AM
Jéjé

Hi again, my second problem is the CXPACKET wait type. during the execution of complex queries when the same table is used multiple times, I have...

Jéjé

08-15-2005 10:02 AM
Jéjé

Anyone know of any good AS performance tuning guides on the web?

Ian W

08-13-2005 07:21 PM
Myles.Matheson@gmail.com

Hi, How can I improve the communication and the data transfert betwee n 2 servers across a 1ghz LAN? I have a data warehouse on a server and my...

Jéjé

08-13-2005 01:37 PM
Jéjé

Is there a good EIS reporting tool for Analysis Services somebody recommended me to check out - Microsoft Open EIS Builder not sure where we can get...

karenmiddleol@yahoo.com

08-12-2005 05:28 AM
Frank Matthiesen

Is there a simple solution in analysis services to calculate the weighted average of two or more calculated memebers without to specify all...

SAUT

08-12-2005 03:49 AM
SAUT

I've built a VB.NET program to use DSO to administer cubes. It compiles clean. But it won't run. It fails on the server's "connect" method...

Pete Ross

08-11-2005 07:09 AM
Pete Ross

Hi, I have heavy updates and the most frequent problem is the PAGEIOLATCH_SH wait type. The update is blocked by himself (using the sp_who1, I see...

Jéjé

08-10-2005 10:19 AM
Jéjé

What is Datawarehouse and How can we take benefit out from it. ??

Manish

08-10-2005 08:13 AM
Peter Nolan

I have a POITEM Table which has just three columns InvetoryID, DateofOrder, VendorID I have under the same InventoryID ,multiple DateofOrders and...

Sam

08-10-2005 07:16 AM
Sreejith

I have a data modelling challenge I need to store multiple values in the attributes of a dimension. The dimension I need to model is the...

karenmiddleol@yahoo.com

08-06-2005 11:12 AM
Mark Malakanov

Can sombeody point me in the right direction. How can I convert a relational database to a datawarehouse? Thanks

Luis Esteban Valencia

08-05-2005 01:09 PM
Akinja

Hi! I use Excel Pivot Tables as OLAP Cube Browser, for cubes which are on an SQL Server Analysis Services Server. This works fine and I'm hapy with...

Jérémie Gent

08-05-2005 09:16 AM
Dave Wickert [MSFT]

Hi, I'm looking at using checksum to check for changes in our data warehouse, and have seen comments on the checksum not always being unique. Just...

Wreck

08-03-2005 11:20 PM
Wreck

We have a table which data is over a million but less 2 billion. We define an integer field to hold primary keys but we do not like to choose GUID...

yan

08-03-2005 05:10 PM
Mark Malakanov

I have a customer dimension: account level key - account number name - account number + sales region + description iIf the sales region changes, the...

Tom

08-02-2005 08:15 AM
Tom

how difficult is it to convert access tables to SQL that can continue to be linked to an Access GUI.

mike

08-01-2005 04:01 AM
Peter Nolan

We have an anomaly where over time the hierarchy of a dimension changes. With that, we are only allowed to have "1" hierarchy. It is basically an...

ricocali@hotmail.com

08-01-2005 03:59 AM
Peter Nolan

I'm looking for some advice/tips on implementing DW on SQL server with data from Oracle databases. What are the common problems, best...

MC

08-01-2005 03:48 AM
Peter Nolan

I have a problem in one of my production server: the rows number is exactly 2 billion records and when you do delete, insert, that row number was not...

David Liu

07-22-2005 03:00 PM
Peter Nolan

Hi, I'm looking for samples models for an HR model and specially the employee dimension table. What is better a slow changing dimension (with full...

Jéjé

07-21-2005 07:44 AM
Mumtaz Zaheer

Hi. I have Question.. If possible install the olap server with winXP to make cubes in my computer non in the server to practices? if is yes, what am...

Nacho

07-21-2005 01:25 AM
Dave Wickert [MSFT]

Hi, I have an Analysis Services database that contains 5 cubes. Is it possible to migrate the database and cube roles from a development machine to...

Tom

07-21-2005 01:21 AM
Dave Wickert [MSFT]

Friends, We have created a good web site for various resources related to the process of knowledge discovery in data. The site is in its early...

Admin For www.eruditionhome.com

07-21-2005 12:15 AM
Admin For www.eruditionhome.com

Hi, I'm still new to datawarehousing and right now I'm stuck on ETL. So can anybody give me some links to a good online resurces about ETL...

Mark00

07-20-2005 04:05 PM
Peter Nolan

Hi, The process msmdsrv.exe (ver 8.00.2039) takes more than 95% cpu. The PC is very very slow. What can I do? I have SP4 for Analysis Services...

§Chrissi§

07-20-2005 12:50 PM
BeWyched

I have about 16 new columns I am bringing into the datawarehouse from an AS400 system. Getting them in is no problem. I need to 'massage'...

marcmc

07-20-2005 03:07 AM
Mumtaz Zaheer

Hi There, I got a generic DW question. Let me preface this I need to design a report that displays data for 3 branches of same companies, Branch A...

ERS Developer

07-19-2005 09:13 AM
JT

Hi, I have some issues with a server which is connected to a slow SAN. the iometer utility says: SAN= 260io/sec - 8mb/s (32kb block...

Jéjé

07-18-2005 08:33 PM
Jéjé

Hi. I have Question.. If possible install the olap server with winXP to make cubes in my computer non in the server to practices? if is yes, what am...

Nacho

07-15-2005 11:13 AM
Nacho

The date in SQL shows up as 729089 Even in Excel the grid shows for eg. the data as 3/29/3896 when I format the date as a Date. I was provided the...

Sam

07-13-2005 01:00 PM
Sam

Hi everyone, I have installed on a DELL SC420 server running Win2000 and MS SQL Server 2000 SP3. I am running a statistic process on the sql svr....

oLiVieR CheNeSoN

07-13-2005 07:31 AM
oLiVieR CheNeSoN

I just downloaded the 32-bit Developer Edition June CTP onto a new laptop running Windows XP. I am working through the Analysis Services tutorial...

Peter

07-12-2005 01:47 PM
Peter

Hi, We have an application that access multiple databases for generating reports and running various queries. These databases are segregated as...

Ajay

07-12-2005 07:20 AM
Peter Nolan

Hi all, hope I am in the right newsgroup! I was looking for insight into a data warehouse design decision. We are going to have multiple sql2000...

SolarCoder

07-12-2005 07:14 AM
Peter Nolan

Hi, I have a DTS package where I load 1.5 millions of rows in a staging table, and I perform multiple updates. 1 of these updates update the entire...

Jéjé

07-10-2005 04:43 AM
Peter Nolan

Hi, I have read the SQL 2005 features comparison and I have some questions: (http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx) *...

Jéjé

07-08-2005 10:43 AM
Peter Nolan

I have been arguing with my partner if we shoud or not design a normalized data base or denormalized. How, can we know when we should choose one or...

Lina Manjarres

07-08-2005 10:19 AM
Peter Nolan

Okay, I have a problem that I need some suggestions with. I have a 30 Gig database that I need to sync across a T1 every night. This database is a...

Scott M

07-08-2005 10:10 AM
Peter Nolan

My current project now is how to synchronize (data transfer) between Production Database & Reporting Database using DTS, but I have no idea how to do...

Resant

07-08-2005 08:04 AM
JT

SQL 2000; I have a table that has info from 2001 thru 2005, I want to create new tables and move records from the original table to the new tables,...

vidro

07-08-2005 06:51 AM
Danny

-=-=- Sorry for the dup post, I'm posting it under my MSDN universal acct now :) -=-=- Okay, I have a problem that I need some suggestions with. I...

Scott M

07-07-2005 06:17 PM
Scott M

Does anyone have any opinion on what is the best front end reporting solution to use with MSAS 2005? I'm looking for features like: - ease of...

07-07-2005 05:25 AM

I work in consumer goods company and now design OLAP Data Warehouse. My OLAP tables consist of : 1. Customer - all our customer data {CustomerID,...

Resant

07-06-2005 09:08 PM
Resant