I am in the process of designing a Booking, Billing and Backlog
datamart. My backend is going to be SQL Server 2K.  Data source is
Baan ERP system.  The transaction level I have to populate the
datamart is at sales order line level.

One of cubes when browsed through proclarity showed
nothing.   To debug the same, I browsed through analysis
services and the values were "#ERR".   There was no
change to the structure of the cube.   The cube

I was running SQL 2000 Standard with the Analysis Services
repository in a SQL database.  
I upgraded SQL to Enterprise.  When a user tried to create
a partitioned cube he got: user-defined partitions are

Maybe a silly question since I am new to SW/OLAP/etc. etc.
I was wondering that if I have a single table having all the things that
can be used as 'measures' PLUS all the possible information about
dimensions in the same table.

One of my tables contains the transaction dates. So based on this table
I tried to create a Time dimension (using the first option - I think
it's called single table or something in the Wizard of Analysis
Manager)....

I installed SQL Server and MS Analysis Svcs on my PC but
I have a problem while trying to browse data. Can
somebody tell me if I have did something wrong???

Definitely a silly question for the experts here :)
What exactly is a Data Mart? Is it more like a fact table and the
associated dimension tables or is it the same thing as a cube or??? I'll
appreciate your guidance and if you can also recommend a couple of URLs

i asked a year ago, but didn't get any real answer.
i would like links to an introduction to warehousing. It sounds like a
useful and interesting idea - but it's like pulling teeth to get an
explanation of what it is.

I've a strange behavior on my server.
The response time is good after a reboot of the computer, but, after a long
work on it (half day or a day)
The performance slow down, so I reboot the server to recover my performance.

Dear all,
I’m a student whose doing extensive research on data warehousing and data mining. With me, is a full dataset of students’ record from a local university. Information’s which is in the dataset consists of students subjects, grades, personal information, library ...

   I am currently evaluating ability of Reporting Services (RS) to work
with output of MDX queries. RS looks very appealing when working with
relational output. But working with  multidimensional output is somewhat
cumbersome. I haven't found any examples so far running against ...

Does anyone know the Total number of Columns or Column
size on SQL 2000?

I am an MS Access developer who is writing his first SQL
Server app.
In MsAccess we have the AutoNumber data type to give
records a unique sequential value. There doesn't appear to

       Can some one tell me how i could automatically
refresh the cube when the DW is updated, I know its
possible through DTS, can someone refer me to a site which
gives step by step details on how i could accompalish this?

Hi!
I want to write some MDX queries that pull the same data I'm retriving into an excel pivot table that is hitting my cube.  Up front, I'm pretty sure this is not doable, but need to ask anyway.  I want some way of hooking into the MSOLAP provider to see the MDX that's ...