I am creating a report for user from our live database , if user are
quering on my reports and some of the user are insert or updating on the live
database , will the table lock from any insert or updations ? Any solutions
of that if the db do lock the table .. TQ

  If I create several views from the transaction table for reporting
purpose. Do the view occupy the disk space as well ?

I am going to be a bit cheeky here and ask for some information on Analyst
Services and the like that I have been asked to answer. Unfortunatly I do not
posess the knowledge to do most of this so I was wondering if someone out
there did, or could forward me a web site that could. ...

Hi,
We use SQL2000 starschemas with "innerjoin" between dim-tables och a
facttable.
select distinct country_descr, product_descr, sum(qty),sum(amount)

Previously I had no problems with this tool and used it for moving cubes and
renaming datasources.
Now, however, I am unable to run the client tool.
When 'right click'ing script as <action> it appears to start running then

I'm new to dw i'm just confuse with the terms
1.  what is a warehouse?
Is it just a copy of an OLTP database that has been cleased and transformed
is this a SQL server DB and not an AS DB

Thanks for the insights Peter. Do most of the BI folks do the technical
stuff on they're own, or do they have the technical people do it for them?
Is it common to have someone doing the technical but not alot of business
involvement? I hadnt realized all this.... and will perhaps ...

The ministery of Education is developing a datawarehouse. As a result they
can deliver Ascii files or facttables and dimensiontables. Statistics
Netherlands is allowed to make use of their figures. Is it possible to make a
full copy of their database or should we ask the ascii file ...