So for example, you'd like to change the source table that is 'feeding' a partition? or the query (if it's not a table direct feed)? If you access...

Hey kate,

normally you hit that error when you're trying to process the partition(s) without having processed your dimensions first. Are your DTS packages set up to process the dims...

yep

Is there a way to setup those connections to the OLAP using a Standard...

Have you actually applied the query log/s to the existing AS2K cubes to create aggregations? If so, you could review the aggregations created for the cube in AS2K and...

hey Rick, I may not have fully understood the problem but tried to replicate what you'd described using some of the sample data from Adventureworks (and the adventure works...

We used to use yet another method, ensuring we always used a specific date dimension key format (integer, YYYYMMDD format) we would use the Excel library to get the current...

sorry, misread your post - what changes are you looking to make to the partition that it won't let you make?

You should be able to do this but you may run in to a problem if you have only 1 partition. From memory it will let you drop partitons...

Hi Prasad,

If you've built the dimension using the wizard then AS kindly uses the PK of the dim as the Key attribute for the dim but sets the Name property...

You'd be suprised how many people actually dom't know about deploying packages, i've seen a lot of people put 'production' packages out there and require the end user to execute...

Technically 3 is a 'Resource'

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.catalogitem.type.aspx

Looks like the doco maybe had 5 & 6 reversed?  Unknown = 0?

Forgot to mention, Liz also wrote some/most of the the perf guide for AS2K5 also and i think it too covers off the usage of attributes for aggregation candidates.

re: the points in the prior and previous messages:

1) even in Standard Edition you can actually have 3 partitions (it's Enterprise where you're not limited).  If your data supports the...

Not saying that it's not possible but i think you have two different approaches happening here.  When you set up your AS connection via the web/http, the OLEDB driver understands...

Stefan,

have you used any tracing to see how often the cache or aggregates are being hit for your queries?  This might also indicate whoich partition(s) are being hit most frequently...