Do someone have the patience to explain? I´m a beginner with SQL Datawarehousing. I am working in Sweden for a pracitical training. I have to analys the existing DWH with OLAP, but I don´t succeed. I established the connection between the Database and the Analysis Manager with ODBC. But if i ...more >>

Quoting from The Data Warehouse Toolkit by Kimball: <quote ignoreSpellingMistakes="Yes"> By now we all know that a date dimension is found in every fact table because we are always looknig at performance over time. In a transaction-grained fact table, the primary date column is the transaction...more >>

Hi! I need a little help here. My set up: 2 tables: Person.PersonID, COUNT(UserAction.ActionID) FROM Person LEFT JOIN UserAction ON Person.PersonID = UserAction.PersonID GROUP BY Person.PersonID The problem is that the UserAction table may have multiple records for a PersonID dist...more >>

Hi, We have a d/whse that has grown and what are the best tips for optimizing so that response times are much quicker. Thanks in advance. Anon...more >>

Hi, I am building in a data mart using SQL server DTS. I have confusion that Example Suppose we have text file for Cust table. It has 3 customers A, B, C This information comes in text file from legacy system. We load this data in cust table in staging. Now we get a new te...more >>

Hi guys, is there a way to run a SQL-query on a SQL-Server within Excel? (Is it possible to create any JOIN-querys and DATEDIFF-functions within Excel-Microsoft Query?) Thanks much guys, Mike ...more >>

I've just been trying to do this. I looked on Google and it seems to be a common problem with no obvious solution. I've seen various solutions which don't seem exactly elegant, so I figured I'd post the solution I came up with. It's effectively a single line solution, albeit with various embed...more >>

Hi, Does any one know where I can find examples with T-SQL(or any other DB language) scripts for buliding & loading data in the Fact & Dimension Tables. It will be a great help for me to look at examples. Thanks Steve ...more >>

SQL 2K Some of the jobs in our datawarehouse box running more than expected time-frame. Please advice me , all the areas I have to look into for trouble shooting - including server setup.. Thanks In Advance MS USER ...more >>

after the first iteration (at least working) of my dts/etlm application for a datawarehouse, i decided to do the next step to more professional implementation. is there a book, that covers etlm with a tendency to implementation with dts? currently i decided implement my next iteration with m...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL...more >>

I am using MOLAP storage for my cube. The problem which I am getting is that the cube stops showing the data for the month which it was showing correctly previously. I have populated my fact table with the data from the previous year i.e: from JUN 2003 till todate and is being updated every year. L...more >>

Hi, I have a problem connecting to olap from a .net application the error that I am getting is "SERVE ERROR IN /OLAP TEST APPLICATION" THE OPERATION FAILED DUE TO SECURITY PROBLEMS - THE USER COULD NOT BE AUTHINTICATED " CON.OPEN("PROVIDER=MSOLAP; DATA SOURCE =BNG ;USER ID=SUNNY PWD=SUN...more >>

Hi All, Has anybody tried incrementally updatind a cube from a visual basic program. I am already doing it through DTS, but i need to know how to do through visual basic using the DSO. Many thanks, Yash...more >>

Hi All, I am using the msmdarch.exe command to backup olap database but it's getting stuck. Any clues. Many thanks, Yash...more >>

I installed SQL Server and MS Analysis Svcs on my PC but I have a problem while trying to browse data. I read in another message that i had to install "AS SP3"but what AS SP3 stand for? My Pc is a Windows 2000 SP4 and Sql Server 2000 SP4 --- Posted using Wimdows.net NntpNews Co...more >>

In Our application there is a method which contain a series ( around 7 ) of functions ( we can think it as sql queries). Earlier we use to create one table for each fuction out put and use it as the input to next function. ( we use simple recovery model) Things were working at that time , but to...more >>

Hi! Who knows, where the timeout paramter is set as describe in the following artcle: http://support.microsoft.com/default.aspx?scid=kb;en-us;281117&Product=sql2k Thx! Greets chris ...more >>

Hi I am unable to process my cube it says Database is read only, I am using SQL SERVER 2000 with SA login Why I am getting this error Sunny ...more >>

Hi I am unable to process my cube it says Database is read only, I am using SQL SERVER 2000 with SA login Why I am getting this error Sunny ...more >>

Where is a good introduction to what a warehouse is? i just watched the Microsoft SQL Server blah blah for Business Intelligence flash advertisment. The soothing female voice again was trying to explain was a measure and attribute was, using the terms "attribute" and "measure". The BOL tries...more >>

if the fact table have some string type measure,how to design start schema ? ...more >>

A design question: Say I have a medium-sized fact table w/ a handful of dimension key columns (including a date) and a handful of measures. I necessarily need a primary key on the composite dimension key columns, and I don't know ahead of time which of my dimension key column(s) will be t...more >>

Hi guys, i am new to Sql and seems to be having problems verifiying my backup.Each time i backup, and want to test my backup or view the contents,i do not see file in the backup folder.Pls help...more >>

Is there any way that I can design my dimension hierarchy such that I have more than one paths to the leaf i.e. levelA->levelB->member1 levelA->levelC->member1 where member1 is at the lowest level. -- Thanks Akber....more >>

We have the following scenario: 1 server with MS Analisys services 1 server with MS SQL server the analisys server has the cube storage installed locally while data is mined from SQL Server. i would like to schedule the cube processing. in litterature i found that this can be done usin...more >>

Hi, how can i install an Analysis Services Manager (for the Console) on a machine, that has no Analysis Services installed? Greets Chris ...more >>