Ray,

I don't know how the records are transfered but,  with the a statement like this: 'Select COUNT(*) FROM T1 (NOLOCK)' You can count how many records are in de destination...

Still my question standes. Because I don't want the average price. I need the unit price at lowest level. And it will be aggregated if we look...

I don't see why spending big bucks on BusinessObjects when you have most of the functionality for 'free' if you have licenses for SQL Server 2000 and Office.

Andre,

A few weeks back I went to microsoft where they presented excel OLAP reporting, a part of the new office Solution Accelorator.

One of the new features was to be able...

Thanks Steve.

No I have another question:

Do you know how I can get that color coding in excel PTS?

I know that in excel you can use conditional formating. But when...

Bart,

I've found a problem.

On the lowest level I have moer then 65.000 records attached to one parent level.

So more then 65.000 product under one catalog entry.

Trying to solve the problem...

Bart,

DB : SQL Server

Nr of rec's Top table 7. Bottom table +/- 600.000

No changes done to the server.

Not at the SQL Server and not at the analysis server.

Bart,

You're not alone...

All the levels in my dimension are varchar.

Other detail:

The data I want to get is in 7 different tables (For each level 1 table)

All joined togheter...

I have the same problem. The only difference is that I get this error when trying to process a new dimension.

The source of the problem is a bit deeper...

I'm running SQL 2000 with SP3.

And I've tried it from EM en QA with the sp.

Yes. I've tried the name of the machine. A dot, LocalHost, ...

I've tried all that. Still no result.

Greetings,

Nico

With VBA using the DSO structure you can create cube, dimensions, ...

The only difference between Oracle en SQL Server as data source is the data source...

This is an object you...

Chris,

I suppose you want to use data mining in your reporting. And not dimensions and cubes?

Connecting to dimensions and cubes is quit simple. You can just use...

Thx,

I got to work in VB script. But we wanted it to be an all sql deployment.

So finally after long hours of trying a college of mine got it...

Jeremy,

When you process a cube you normaly get a windows where he says what he's doing. (Processing dimension x, ...) One of the things you can see there...