In that case has anyone seen a basic tool for viewing the attributes in each aggregation and perh
In taht case has aaps even deleting them/editing the XMLA file a little bit? The reason I am looking for a tool is to make sense out of 2000 aggregations created by the wizard.
A new sample app for viewing and editing aggregations should become available as part of SP2...
Thanks,
Akshai
|||what is the name of that sample? I have SP2 final, but only samples under Microsoft SQL Server\90\Sample\Analysis Services are:\Administrator\ActivityViewer
\DataMining\Data Mining Web Controls
\DataMining\SQL Server Data Mining Plug-In Algorithms
\Programmability\AMO
\Tutorials\Lesson4
\Tutorials\Lesson7
I checked the Programmability\AMO sample, but all it does is provide drilldown into properties. I can drill into aggregations but it's very laborious to use to find see which attributes each aggregation aggregates, because you would need to click 2 times on each dimention in each aggregation to see which attributes it affects. I did not see an ability to create a new aggregation or change an aggregation.
Did I miss something?
Where is the sample that Edward and you mention ?
|||
It's called AggregationManager and is under Administrator/AggregationManager.
I don't think the samples are included in the main SP2 download. I think you have to download them separately. The SQL Server sample are now all available from codeplex. The download page for the SSAS samples is here http://www.codeplex.com/MSFTASProdSamples/Release/ProjectReleases.aspx?ReleaseId=2461
The AggManager sample only works with a deployed database. I am looking to add support for this tool directly in BIDS through a project I am working on at www.codeplex.com/BIDSHelper. I hope to get an initial beta release out in the next week or two if you are interested.
