I thought you could only do this (create offline) in the pivottable when it's based on an OLAP cube to begin with?  An alternate approach you could take is to...

Two comments, neither of which will necessairly give you an answer as to why this is happening. -> Why use a view (that crossjoins and then uses filters to remove...

I'm not sure what's going wrong (or right ) with your aggregations but I would hazard a guess that it's related to the aggregation...

Hi Michael,

I haven't tried to restore a 2000 AS DB to a 2005 one but I would imagine that it wouldn't work.  The file structure of the cubes in the...

Ever since hearing the announcement of the sale, the business analyst side of me has been asking 'why'?  I can see that the sale gives (very justified) dues to Steve,...

Do you want to group them permanently (ie in the dimension)?  If so, I don't suppose you're using AS2K5?  If yes, then you can use the Descretization feature (new in...

Definitely sounds like calculated members.  I haven't been able to test AS2K5 with Off07 yet but this post indicates that (in beta 2 at least) there is a setting...

What version of Excel are you using?  Also, can you confirm that you're using calculated measures (ie calc members in the measures 'dimension') or calculated members (categories that exist in...

Phil, have you checked out Partitioning at all yet?  If you're using AS2K5 it's quite simple to implement and maintain.  AS2K is still quite easy to create the partitions but...

Another option that I've been keen to try out but haven't yet is the Synchronize option, i think this is meant to let you synchronize one DB to another server...

If you're looking to go from AS2005 to AS2005 then you can simply backup the database and restore it to the other server.  Backup and Restore work in a very...

You could also try this suggestion if all else fails. 

Have you tried testing this connection string in anoher application (like excel) to connect to the repository?  I remember seeing something about this error indicating a malformed connection string.

Hey Hendra,

First point, you should possibly try a smaller aggregation setting, 100% can often mean that performances id degraded (plus it's unlikely that AS will let you do this anyway...

Sorry, am working almost exclusively with 2005 now which has this built in.  You're right, /net express (which is VB.net) is quite different to the old VB6 code.

Just a thought...