Thoughts about Aggregation Manager

 
Initial thoughts about Aggregation Manager:
  1. Would like to see this inside of Visual Studio. We use the deployment wizard to rollout changes – changes to the aggregations must be done in a different script.
  2. Confusing at first how to save the changes to the aggregation (didn’t know you had to right click on the Measure Group and select ‘Save To Server"). Wasted about an hour of my time when I closed it down and didn’t save it. Thought that when it said the "Aggregation Design had been updated with X aggregations" it was saved.
  3. Weirdness with the Physical Aggregation Size option on the partition. Haven’t figured out why it’s showing all zeros when the partition does have aggregations associated with it.
  4. Would rather see the dimension and attribute names rather than ID’s
  5. Don’t understand the difference between selecting the checkbox for the Dimension or the Key. Would like to see other checkboxes automatically selected if a parent is selected. (this probably makes no sense)

In all, it’s nice to have a tool like this. Just would really, really like to see it integrated into VS.

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to Thoughts about Aggregation Manager

  1. Greg says:

    I completely agree with your suggestions. We\’ve integrated the Aggregation Manager code into BIDS Helper, so now you can use it from Visual Studio:
    http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Aggregation%20Manager&referringTitle=Home
     
    I\’ve also reported my full list of issues (which somewhat overlaps with yours) here:
    http://www.codeplex.com/MSFTASProdSamples/WorkItem/View.aspx?WorkItemId=268

  2. Jesse says:

    Good stuf Greg – I\’ll check it out

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s