Anyone with experience with SAS-datawarehouse.
Good or bad? Why?
They have a lot of front end tools.
/Kent J.

We have a large DW running on a server with 4GB memory, and mostly reponse is
fine.
However when we make a query which has several dimensions each of which may
have hundreds or more values, then add in a few measures. It will take a long

Can anyone add to / comment on / improve / criticise this logic for
indexing a fact table in a star schema:
Presuming a fact table with 4 dimensions:
* Brand

Hoping someone out there has some advice on what to me seems like a common
database problem.
We have a high-throughput 24/7 transactional system that we're looking to
mirror to a different physical server, the intent being to redirect our

I have tried to load the below data into a SQL-table using a DTS-active
script package.
The data:
================================

some times when exporting a cube of a pagina Web with OWC to Excel, after 5
minutes does not finish and if it finishes not they see the data. That I can
do? thank you very much to help me

I would like to know on how to SCHEDULE restart a server
which is running on a Windows 2003 Server platform at
anytime we desire.
thank you.

I'm trying to import data into my table and I'm received an error message
that I've been able to resolve.
The message is:
Error Source: Microsoft Transformation Services (DTS) Data Pump

I installed Analysis Services and then I installed
SP3 for SqlServer2k and
SP3 for Analysis Services
But I am still getting an error when browsing the cube

I have to plan a datawarehouse structure where the primary reporting usage
is to list detailed information about customers.
And also, we have OLAP cube for analysis purpose.
I'll have 100 000 customers and a fact table containing between 35 to

We are currently trying to implement a BI solution for a data warehouse,
but can't seem to get the last few kinks worked out.
I have a cube made by BI that has monthly partitions.  The problem is
that whenever I add new dimention information (which should be an

Our SQL Server database is being utilized by many Applix/iHelpdesk
forms.  On a cloumn with a 'text char(16)' datatype, we recently found
2 <Long Text> errors on a table.  The Applix developers said their
application was locked up.  My DBArtisan can disply only two records.

I inherited a rudimentary data warehouse and would like to gather data on
which tables and which indexes are being used. Queries to the warehouse are
typically  issued via ODBC from an ACC2003 front-end.
I have chosen SQL profiler as the tool to identify object usage. I thought

Hi, All!
I'm experimenting with MSSABI and look this problem - after running
SetCurentDay.dts package every measure values  mutiplied by 6.
Here is my steps:

When you install the Accelerator it only has the ProClarity Generator.
?is there any other available?