Where can I find information about
How to move your database from OLTP to OLAP
what are the steps (stage1 stage2 indexing issue etc..)
with real source code examples

Does anyone here have any experience integrating a CRM system and a
warehouse within the enterprise?
Any documentation/white papers would be appreciated.
Thanks,

I am starting the task of creating a data warehouse for my company's OLTP
system and we would like to offload reporting to a reporting schema at a
data warehouse.   We have 2 kinds of reports: operational (used daily and
need data just about real time) and analytical (used to ...

I am in the middle of creating a data warehouse and wanted to add some
FK constraints.
However, I've found that when creating them via the 'relationships'
tab, something strange occurs!

I would be most grateful for any comments regarding the following
proposed datawarehouse architecture:
1. Backroom Box
This is where all the ETL work will be done.

Im having the symptoms described in:
http://support.microsoft.com/kb/287079/en-us
But have tried the workaround to no avail. An important note would be that I
have Excel on Box1 and AS on Box2. When connecting to AS on Box1, this issue

Howdy all. Im a total AS newbiew so please bear with me. I RClick the server/
Restore Database/ "\\path.cab", but the message I get is "Cannot attach to
the OLAP data directory".
Ideas?

we are processing a large number od small(ish) partitions, and I was
wondering if using Lazy Processing would process the partitions in parallel.
The partitions are built in serial. If Lazy Processing is set, would AS2000
process each partition in turn on the background thread? Or ...

I'm trying to create a 'YTD Actual' Member in SQL Server 2005 Analysis
Services. Here is the code:

I want to monitor an AS2000 installation to see if and where we have any
bottlenecks in the cube processing. Does anyone know of a good document or
advice to offer. I have already read the SQL Server 2000 Resource Kit on
monitoring AS. It lists the counters to examine, but I'm ...

I keep on getting the following error while processing a cube in SSAS
2005:
Connection could not be established to the Data Source with
DataSourceID <my_data_source_name>

I'm trying to establish the quickest and easiest solution to a problem
involving copying data from our live server to our test one.
The database contains approximately 30 tables with about 500mb of data
expanding at about 10% a month. The issue is that in order to refresh the

Hi everyone, I'm setting up two Analysis Services servers in NLB
following the directions in the link
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/olapsite.mspx
After some tries, both servers are working fine alone (trough each

In TSQL how to use OPENXML to open an ntext field in a table? I can not read
the ntext into a local var as TSQL does not allowe ntext local variables.

I have an SSAS 2005 cube w/a product dimension which contains the
following hierarchy:
Company -->  Store --> Department --> Product
I have just converted the Product dimension to be SCD Type 2, so that