i can't remember all ofthe conditions, but i think it centers on having shared dims and unique lowest level members in dims, so if you have these, go to the...

It could have to do with the formula but I'm not sure why.

A really quick thing, unless prototyping I would *always* create a seperate Time dimensional table, mainly because I...

Just looked at your metadata query versus mine, why is your time dimension doing a datepart of 'day' for the year level keys?

What is the key and name formula for...

Just recreated as per yuor specs, drillthrough from within AM works fine and using the spreadsheet/macro as supplied by MP I can't get it to fault??

SET FMTONLY ON select "dbo"."vw_pub_test"."stor_name",DatePart(year,"dbo"."vw_pub_test"."ord_date")...

it doesn't close the function call?  interesting! 

Just out of interest, what are the key and name settings for your month level in the t dimension?

Not saying it's the best way, but the last time I saw someone attempt this, they created the member placeholders outside of the model (ie in your source, possibly use...

it's really reeking of a bug now isn't it?  yeah, my first parent category(ie under which months are nested) does have a full complement of months even though subsequent ones...

You could try adding the key field as member property to th month level, the change your query to use the hierarchisize (spelling?) function, which will let you effectly nest...

sorry (duh) yep, it's the order() fn.  Wrt the fn, you'll obviously not want to break the hierarchy (ie don't use Bdesc or Basc) and if you have a numeric key...

You'll want a 'sort' (which does the 'order by' in mdx).  Are the members in the correct order when browsing the dimension using Analysis Manager?  If not, you should sort...

Definitely.  Look in BOL in the index under DSO, subtopic of databases.  You'll find sample script like below...

Private Sub CreateDatabase()    Dim dsoServer As New DSO.Server  ...

You're right re: the security. 

On the slightly obscur side, when creating the connection (linked server) are/were there two different drivers for AS? (prob listed as OLE DB for OLAP...

A very simplistic approach could be to create a second cube that uses the MailOut (ok, it's not called that but you know what I mean) table as a fact...

neat find....  annoying but neat.

if you take a look at http://support.microsoft.com/kb/304213 , it indicates that you'll never get it to change from 15...

I think this is a known limitation.  Basically the row count is never updated - which is quite a big problem if you go about trying to recreate the aggs...