Can any one Suggest some good books on Data Warehouse
(Begner to Expert Level)
Thanks
Sai

A new Systems Architect is trying to tell me that a data warehouse typically
contains thousands of fact tables and hundreds of thousands of dimensions.
So you know, my business is in the retail sector.  I specifically asked if
he meant THOUSANDS of MEMBERS, not dimensions, and he's ...

I have started to learn Analysis Services. I did the tutorial step by step,
but the last step "create the 'Sales' cube" doesn't work. I get the error
message "Unable to create cube 'sales'" - Unspecified error. It doesn't even
work with the manuelly in footmart creatd cube. What is ...

What is the procedure for moving a database from one c:\
to D:\ on the same computer.
I figure I have to use sql analyzer but once there what
are the steps.

Our database is a SQL Server 2000 (sp3).  We are
populating the database from transactions on the web which
run through an IPSEC tunnel.
Over the course of several days our counter column on one

We build Analysis Services cubes sitting on Sybase
relational end.   We have partitions on of our big
cube.   When I try to process any of the partitions(that
are worth 10 days of data) after an hour or so I get an

Is there a way to reconstruct a table which was deleted without restoring
the whole data base?
Database recovery model is simple. Sqlserver version is 2000 sp3.
TIA

I have the following table.
EXISTING TABLE:
COL1    COL2    COL3    MESSAGE               
TOM    CLERK    VA    TOM IS A GOOD CLERK. AGE:32,

While going through an article I came across the subject terms and
wanted to ask the experts if these are "basically" the same thing as
"BI" or are these totally different?
I'll appreciate any pointers/help from anyone.

Hola a todos,
tengo un problema bastante a menudo con este tema, y me gustar?a
AUTOMATIZARLO de alguna forma.
sabr?a alguien decierme como podr?a hacerlo

I'm working in a Windows 2003 Server, SQL Server 2000 and Analysis Services 2000
I have created two models in Analysis Services (MOLAP)
- MODEL 1 gets info directly from the relational  FACT table: "FCT_SALES
- MODEL 2 gets info from a view with: "SELECT * FROM FCT_SALES

Does anyone have some sample DSO code to change the Data Source of a cube? I
am aware of the DSO/XML utility, but have been unsuccessful in using
it--consumes all available memory on my PC (1Gig of RAM).
Thanks,

I am trying to migrate timestamp fields in Teradata and
DB2 to SQL server.  The problem is that Teradata and DB2
store timestamps to an accuracy of 1 microsecond, while
SQL Server stores it to the nearest 3.33 milliseconds

I am trying to set up an orders datamart, which would be fed from our ERP
daily. Requirement is to know at any given time what are the bookings, what
is the backlog and how much has been billed.  I am trying to create a
dimensional model.  My structure is as follows.

I have created a cube that uses "calculated members" for %
calcs.
The data has processed fine on the SLQSERVER 2000 Analysis
server.