I had installed the SP3a patch for Analysis Services.  
Everything was working fine for a day and then now when I
try restarting the MSSQLOLAPService it gets into a loop
and automatically gets restarted again and again.  

i'm wondering if it's an acceptable practice to use views to extend fact
tables in the warehouse.  e.g., if you have an existing fact table, and
for some subset of the data in that fact table you'd like to add new
measures, etc., would it be better to create a new fact table ...

I have a cube with a calculated member The calculation for the calculated member "MyMembers" is a simple addition
[Measures].[NoOfOwners] + [Measures].[NoOfUsers
In the MDX select statment I use the "non empty" expression on both columns and rows. My MDX query goes like this
SELECT

How do you backup a SQL database so the logs are commited
to the database file?  Will a backup using Veritas Backup
Exec do it for us or do I need to use SQL to backup the
product?

I have learned how to transfer data from my OLTP database into a
different database, learned and have ensured that the data has been
'scrubbed', have created tables which I plan to use for my dimensions
and fact(s) and and eventually successfully created cubes using Analysis

how to import data into sqlserver2000 from oracle 7.please
give me a solution

I want set a 1-to-1 relationship between two tables in a
diagram.  The master table's (main)link field is a PK
(HQID).  The second table (table2) has a PK (tbl2_id) and
a field (HQID2).  I want a 1-to-1 between main.hqid to

Can I safely remove the model, msdbdata and/or the master
databases from SQL2000 (they may actually have been from
SQL7) without affecting the program operation and
population?  I am incredibly low on storage (that is whole

I am creating the data model for an insurance related datawarehouse, I have 3 types of Claims that we want to report on
health, dental and drug.  Some of the data the user needs will be in all 3 but others will be in only one or two of the fact tables
My question is should these 3 ...

here is my problem, I try to insert values in a partitioned view and it does not work! Please Help :
CREATE TABLE Mai1998Sale
  (OrderID   INT      PRIMARY KEY
  CustomerID      INT         NOT NULL

Can anyone recommend some good reading on Datawarehousing theory ?

I am doing performance tuning on a data warehouse load process that
executes a series of stored procedures to migrate data from one
database to another. The processing is an elephant that takes 4 days,
and I am currently focusing on indexing.

I am currently developing data warehouse design documentation for our company as our first step in creating a data warehouse.  During the design I ran into an issue:
Our users want to answer this question: "What are our Export sales?
Now that is a tricky question and I'll explain ...