Hey Matt,

Sorry to come in so late on thsi but couldn't you achiueve the same thing by simply editing (it's a drop down isn't it?) the Data Source for each...

You should be able to batch the backups using the Batch element - see below for an e.g.  Just note that I have  used the AllowOverwrite element and set it to...

Hey Herb,

Not sure what's going on with that.  I've tested your link and mine in both IE6 and Firefox 1.5 and both either go to download or open the document...

There are several feature differences between Enterprise Edition [EE] and Standard Edition [SE] (see the whole list here).  I think that the trial is Enterprise (where the intent is...

If you can get the table in to the DSV then you can change the properties for each column in each table.  Once (if?) you get it in there, select...

There should be a role (or more than 1) applied to the database in Analysis Services.  To do this, connect to the AS server through Management Studio and expand the...

Embed, sort of...

Take a look here on how to use OPENROWSET to query an AS instance.

Cheers,

Hey Derek,

Two things I thought you could try.

i) pivot your source data (using the activity) to give yourself four measures -> Click, Impression, Invalid Click and Invalid Impression.  (it's implicit...

Not really possible but you could use the project type (in BI Dev Studio) that allows you to 'upgradse' the cube from 2K to 2K5.  Note, as posted in other...

Not sure if you're using it but AS2K5 will allow you to have muliple fact tables in one cube, each feeding a measure group.  The final cube then is the...

Answering your last question first, i don't think you can run Parallel Process (the app) on AS2k5 cubes, but could be wrong. I don't think you'd *want* to run it...

Hey Bruce,

If I understand you correctly t's multiple hierarchies you're after.  In AS2K the way to achieve these is to name the dimension in the pattern of <dim_name>.<hierarchy_name> (yes, that's...

Have you tried predefining the web service (something done on the CF server apparently).  Looks like you can get Basic authentication going, not sure if the windows authentication will go. ...

Yes,

I think we used to use Windows Explorer to get the properties of the relevant cube folder in the data directory.  AS it's MOLAP all of the data and aggregations...