Cam someone recommend a good newbie book for Analysis Services? One with
step by step labs would be ideal.
TIA, ChrisR

Does anyone use this in their organization?
1. What is the administrative effort? Does it require a lot of
setup/support?
2. What is the learning curve like for the users?

I want to display some numbers in a map.
These numbers come from a data warehouse and/or an OLAP cube
I'm looking for a webbased tool.
I want to display some colors linked to some values and I want to display

OK, here's the situation:
The "data warehouse" that our ERP provider sold us has evolved into more of
an operational data store.  We are in the process of developing a more
traditional star-schema data warehouse.  The ODS is getting quite large,

I am very perplexed with this problem I'm having. I work for a website-based
company and my job is to create a data warehouse based on usage of the site.
We have a Central Logging Database that logs every single hit to the site,
then i have a stored procedure that picks up these ...

We are using BI Accelerator and we faced the problem that it is not possible
to insert new rows. We have some shared dimensions and when we define cubes
we also have to add list of dimensions. Very quickly we fill in the whole
space of the worksheet. The worksheet is protected ...

Are there any routines out there that will automatically convert a table (A)
with numerous numeric fields to a new table (B) with just one numeric field.
Thus the number of records in the table (B)  would be the number or records
in A mutliplied by the number of numeric fields.

For e.g
I want the amount of a customer between 2nd March 2004 and 2nd October
2004.
Basically How to filter this as i cannot put it in a where clause.i.e

For example, say I have a purchase fact table.  Then I have a customer
dimension.  In the customer dimension, we have city, state, name, etc, and
then we have a group level that needs to have a heirarchy exposed.  For
example:

I'm getting unexpected behavior when running DBCC SHRINKFILE on my 9 GB data
file. First, it's been running in excess of 10.5 hours now and, second, it
is ever-so-slowly *growing* the used portion of the file. For instance, when
I look at the 'Space allocated' section of the ...

I hope somebody can help in solving next problem.
Our SqlServer 2000 (installed on Win2003 EE) processes 15 millions of
records each day. It works fine about 7-8 days and then it starts to
slow down. Sometimes it seems that processing is stopped. There are

I am a former DBA that has moved into a totally new role and
environment, as a data architect on an enterprise data warehousing
project for the national statistics office.  I've started reading the
Kimball Data Warehouse Toolkit (2nd Edition) and now have a feel for

I have created a package to do this which simply returns with the erro
'1 task(s) failed during execution'.  I can process the dimensions an
cubes manually in analysis Manager  fine.
SQL and analysis Manager are both on the same server and the tas

Hello, im trying to extract and merge data from several tables into one
table, to indetify which table each row of data has come from I would like to
insert a column which references the table name. Below is an example of the
code:-

We had a stored procedure that was created while
ansi_nulls was on. Is there a way to tell if SP has any of
the ansi settings changed from default? Just curious.
Sk