I'm a new in DW world and I'm searching for tools to my clients view the
cubes generated using SQL 2005.
   I already found some good products like "Business Objects" toolset but
the price is inacessible... :-(

Can I access the MS Analysis service over the web to delivery data to my
customers that use Pivot Excel tables?
RMelo

I tried to view the offline cube created through MDX in a system
without Sql server 2005.
The error is that there are no visible tables in the data source.
The .cub works fine in my m/c with excel 2003(I have SS 2005)

Looking to see if anyone has had any success with 64 bit drivers for
Informix. Specifically, trying to import data into an SQL Server 2005
datawarehouse box with limited success.
Any all responses welcome.

hai,
 Am using sql server 2005 standard edition ,can you suggest me any book to
get started with data ware housing.
Thank you

Consider me brand new to data warehousing.  I'm looking for a simple,
real-world example taking a simple transactional table, and getting all
"data warehouse" on it.
I know there's a star schema to design, but wouldn't I just do that within a

I have succesfully followed all the steps in the tutorial, but when I
have to deploy my project I get some error messages:
Error    1    The following system error occurred:  Logon failure: unknown
user name or bad password. .        0    0

I'm trying to build my first Analysis Services (2005) cube based on fact and
dimension tables on a SQL200 database on a different server.
I'm having problems setting up the data sources - I'm assuming I need two:
one for the source SQL2000 tables and one for the target SQL2005 ...

I have got a problem! I have just installed Analysis
Services, and am able to build and process cubes, however,
unable to browse cubes. When I tried to browse the cube by
right clicking on a cube and selecting the option 'browse

I am doing a research project on data warehousing so that I can see
what it can do for my workplace.  I have googled on this subject and
the web sites I found relating to this have not been too detailed.  I
have a basic set of data and business questions that I want answered

I have a table that I'm importing with IS and a slowly changing
dimension component.  I followed the wizard to say which columns are
historical and which are fixed (I don't have any changing columns).
I have a From and Until column in my destination table so I set those

Can anyone recommend any books on analysis services and/or MDX.
We're a pretty tech savvy bunch of developers who need some kick start
books on using 2005 analysis services, warehousing principles, writing
MDX queries, designing cubes etc