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 ...

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

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

Hi! I need a little help here.  My set up:
2 tables:
Person.PersonID, COUNT(UserAction.ActionID)
FROM Person LEFT JOIN UserAction

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

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?)

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.

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".

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 ...

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 -

I'm wondering in general about the main purpose of BI.  More specifically,
should BI be used only for internal business intelligence, e.g., trends and
analysis for senior managment and marketing, or can it also be appropriately
used for daily operational reports?  We have ...

Im a member of a team planning a data warehousing project. We have multiple data sources which are aggregated in a staging area. This is then denormalised and imported into the datawarehouse database.
I am looking at ideas for incremental data refresh, rather than a drop and ...

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

I have a problem connecting to olap from a .net
application
the error that I am getting is
"SERVE ERROR IN /OLAP TEST APPLICATION"

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!