Not sure exactly what's happening with your system bu i don't believe that 26 UBO aggs = 1 DS aggregation; an aggregation record is an aggregation record, you're just using two...

Jamie,

Not sure if this is what Phil was saying, but I think there is  lack of conversation (in many places on the net) regarding SQL2K5 due to a lack of people...

You should be able to do this, try the following:

1. go to the custom dimension settings in your role, there should be 3 tabs

2. go to the 'Common' tab

3. Set...

I actually thought that the opposite was true, they (Msft) provide no upgrade path/s from beta to beta or beta to RTM.  I'm pretty sure that i can put this...

Glad you got it going.

The Service Pack 2 refers to the Win NT5.1 (ie Win XP), the version is correct for SQL SP3. 

Cheers,

Steve.

Ok, pulling at straws now, but you could try the suggestion in http://support.microsoft.com/Default.aspx?kbid=837188

from a msft transcript re: SP3 -->

Let's move to setup do's and don'ts (slide 11). As I...

Good ol' pass-through security   At leats you have a working solution!

re: RS is better on relational vs olap, yes and no. 

I've been...

Cognos, but there again they'll bleed you for the licenses.

ZAP (my old stomping ground) will have this type of functionality in by June/july, and Cizer *may* look at doing it...

Hey Phil,

I have a feeling  that it's only on enterprise (so we get it in dev too).  I saw a doc that had the...

I think this is a known problem (with a solution) in SP3, but you may want to get your SQL & AS in order first and then work on this...

Not sure if you've looked at these but will post anyway.  I haven't done the XPSP2 thing yet, but you may need to do the enabling of the apps prior...

I haven't looked at BO's product set but I have spent a fair amount of time with the Cognos suite and also Cizer's Report Builder & Quick Query (which I...

Hey L2L,

Any more details on your portal?  If you're using asp.net you could try using ADOMD.net (or raw low level xmla) which will let you specify connection details, passes through...

Have you tried putting a log file (2nd last param) to see if any exceptions/errors are being thrown? Using your sample cmdline, just add another parm like

msmdarch /a SQLBox "F:\AS\ADW"...

Yes, thats where I would try it.

I'm not a big AS400 user, so can't guarantee that this will solve your problem.