Its not true. Parent-child dims DO hold aggregations.

There are some caveats though. I've just tried it out and found a situation where this isn't true.

You can only create aggregations in...

Good article, I agree wholeheartedly with all the points raised. I can't believe there are people out there that would ever contemplate the use of MUCK tables.

I have a method...

For what its worth...

SQLBill's solution would allow for situations where you don't have 12 months in a year (e.g. in accounting scenarios you may have 13). I would go with...

I've found what I was looking for. The function is called ROW_NUMBER(). Here's an example of its usage:

select  row_number() over (order by name) as row_num

,  name

from sys.all_objects order by name

Still...

Hi Aaron,

Thanks for that but no, thats not it. Rowcount and Top only return from the "top" of a resultset.

Maybe I imagined it (very possible) but I'm sure I remember...

I figured it was a reserved keyword. I guessed it was something similar to the rownum function (think thats what its called) in Oracle which you can use in a...

The basic premise is to make a call to DSO (Decision Support Objects) in order to process your AS objects. If you don't know anything about DSO well then you've...

Or you are part of the Beta program!

Definately different in my local installation:

HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/MSSQL.1/MSSQLServer/LoginMode

Whilst I don't mind it being wrong...can I have my point back please

Perhaps more constructively then....

Nehman,

Be wary of handing administrator access to people that don't have the skills to carry out a DBA role. I dare say that you don't have these...

I can think of only one way to do this in AS 2005.

1) Extend your dimension table to provide a column for each language that you want to translate into....

Add them to the system administrators role.

You might want to publish this on a more pertinent forum next time.

Why don't you try posting in a SQL Server 2000 newsgroup (which this one isn't)

Ha ha. Fernando and I obviously aren't going to agree about this!

Seeing as you are using Analysis Services the choice should come down to Panorama or ProClarity as they are specifically for use with AS and therefore have features that the...