I set up drillthrough action in my cube in MS SQL 2000 AS and it's working
fine when I explore the cube with the cube browser in AS, but when I try to
invoke the drillthrough action in MS Excel 2003 I get an message the there
are no details to be displayed - it failes.

  I have created 3 fields in for my table , FieldA , B and C all asc order.
  What is the diff if I perform the query like :
A)  Select * From TableA
     Where FieldA = 'A' And FieldB = 'B' And FieldC = 'C'

  What is the difference I create a view from TableA with 3 fields and I
select 3 fields from TableA ? Let's assume TableA have 20 field attach to it
  Will it increase the performance when I select from view ?

What tools (companies) have you found to work well with your Data Warehouse,
easy to use by non-developers and also interface with MS Reporting Services?

What is datawarehouse?
Is there any good website related to learning from the beginning of
datawarehouse?
Is datawarehouse in Oracle and SQL server different? I am good in SQL Server

Hey All,
Please have a quick read and add your opinions.
I work in the insurance industry.
In our datawarehouse there's a policy header table and a policy transaction

I have a data warehouse that imports all of the required profile,
transactions, logs, etc. on a daily basis and has been running fine.  The
other night, I started to receive the following errors during the web log
import.  

Recently we have migrated the datawarehouse server  to windows 2003 server
from windows 2000 server.
Since then all dts packages are getting timedout with the following error.
Step Error Source: Microsoft OLE DB Provider for SQL Server

  What is the diffence I create 1 file on the same disk under 1 file group
and
multiple files on same disk under 1 file group ?

 I already create clustered and non clustered index in order to improve the
reports performance. But after I test several times on my reports , the
processing time almost the same as before I index the table.
 Any other method to increase the performance ? Can I index the ...

What is the different between calcualted member and calculated cells?
Is there any guildeline in using calculated member and calculated cells?

there is anything to do to improve the DBCC indexdefrag command?
currently I defrag my indexes after every datawarehouse load.
(only if I have 10% of fragmentation or more)
but the process is long, this takes 35minutes.

Howdy - -
    I have to keep time series on large amounts of numeric data (millions
of rows).  I had the idea of storing these data as int and converting to
decimal in views; this way, my numeric columns shrink down to four bytes

I have a Product dimension on which I expect about 90 attributes
mainly they are related to classifying the material.
Can somebody please share ideas how I can implement such a large set of
dimension attributes any other alternatives you can think off.

I'm thinking I may have worked with a data warehouse before, but how can I
be sure?  I am applying for jobs that ask for an understanding of multiple
data warehouses but the definition for data warehouse to me is unclear since
i'm not sure if i've seen one (or worked with one).  ...