i am looking for a good program to query sql server olap data.
i tried ms excel but  i was looking for something better.
i've seen proclarity,it is good  but the new version cost too much for my
customer.

I have a problem.
My problem is :
I have two tables reprezentoing a tree, first table representing nades,
and second representing links

We're putting together our data warehouse, and I had a questions regarding
design of fact tables for our situation.  We have invoices and payments to
those invoices...would I include all information in one fact table, or would
I separate them into two tables?  If I do two tables, ...

Is there a way to monitor schedule jobs and restart the jobs automatically
when it faills and if it fails then notify the responsible person, is there
a tool to do this ?

Apologies if this is not the correct newsgroup - I've also posted this
message to the microsoft.public.dotnet.framework.adonet newsgroup...
As part of a datawarehoue application, I have a Windows service which
iterates through a mySQL DataReader (using the CoreLab native .NET ...

I have 2 cubes, one runs smootly and another one has an
error message 'The query could not be processed : The
data provider didn't supply any further error information'
Anyone know how to solve it, please let me know.  Your

I have 2 instant of SQL server on the same machine.
1st instant keep most of the static information - Dimensional data
2nd instant keep most of the transaction information.
When I try to use the Analysis Services, I have 2 connection, but they can't

I have to create a query which evalaute, for each year, the employees who
reached a particular number of absences and when this value is reached.
I have 1 000 000 records in my absence table.
my table is like this:

I'm about to build  data warehouse of approx 15 Gb.  The biggest table is
expected to be of 10 000 000 records. How  will MS SQL 2000 Standard Edition
cope with it?
Thanks,

I need an extraction software that needs to be capable of capturing a table
(or tables) displayed on the web and converting it to a file as a list of
records with
comma separated values.  The records will be converted to insert commands

I have a datbase design problem
I have a hierarchy that includes 5 levels and each level have a table
EX :
TABLE_L1

I work in ETL and had a table clustered index create fail
to due to the filegroup being full.  Its created after
the data is inserted.  I just read where I could use the
create in tempdb option, but here I don't think that

I am creating a table with following  fields:
CREATE TABLE     Employee (
EmployeeID                bigint    NOT NULL,
EmpName                   Varchar(50),

I expect a 3 terabyte warehouse would need no less than
8 processors
32 GIG ram
SAN storage for data, logs, backups

this seems like the best place for this question.
I've had cause to review the MSFT position/tools in the BI area. I'm
surprised!!! I feel like MSFT have made MUCH more progress than generally
talked about in newsgroups and customers I work with.  All I ever hear from