how can I check if my cube has aggregation?

I am not sure how aggregation works in the cube.
Is there a way to check if this succeds?
Thanks,
GUangming
Easiest way is to run the DSO script from my blog.
http://www.geekswithblogs.net/darren...les/57168.aspx
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
|||It is great!
When I ran the script, I got errors like this:
D:\codes\MDX\ListOLAPAggregations.vbs(57, 1)
Microsoft.AnalysisServices.Importer
: The connection string to repository needs to be specified in the 9.0
server pr
operties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
Services
9.0).
I am running AS 9.0. How can I fix this problem?
Thanks,
Guangming
"Darren Gosbell" wrote:

> Easiest way is to run the DSO script from my blog.
> http://www.geekswithblogs.net/darren...les/57168.aspx
> --
> Regards
> Darren Gosbell [MCSD]
> <dgosbell_at_yahoo_dot_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
|||In the msmdsrv.ini, there is nothing for DSO:
<DSO>
<RemoteRepositoryConnectionString/>
<RepositoryConnectionString/>
<RemoteLocksDirectory/>
<LocksDirectory/>
</DSO>
Guangming
"Word 2003 memory Leakage" wrote:
[vbcol=seagreen]
> It is great!
> When I ran the script, I got errors like this:
> D:\codes\MDX\ListOLAPAggregations.vbs(57, 1)
> Microsoft.AnalysisServices.Importer
> : The connection string to repository needs to be specified in the 9.0
> server pr
> operties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis
> Services
> 9.0).
> I am running AS 9.0. How can I fix this problem?
> Thanks,
> Guangming
> "Darren Gosbell" wrote:
|||Darren's script (DSO) is for AS2K.
Your response seems to indicate that you are running AS2K5 (but didn't
mention that in the original posting). In AS2K5, there would be a similar
AMO scipt to do the same for AS2K5.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Word 2003 memory Leakage" <Word2003memoryLeakage@.discussions.microsoft.com >
wrote in message news:1863EE4D-EF45-4644-987D-8C111DC3C084@.microsoft.com...[vbcol=seagreen]
> In the msmdsrv.ini, there is nothing for DSO:
> <DSO>
> <RemoteRepositoryConnectionString/>
> <RepositoryConnectionString/>
> <RemoteLocksDirectory/>
> <LocksDirectory/>
> </DSO>
> Guangming
> "Word 2003 memory Leakage" wrote:
|||In article <e$ihjv00FHA.464@.TK2MSFTNGP15.phx.gbl>,
dwickert@.online.microsoft.com says...
> Darren's script (DSO) is for AS2K.
That's right

> In AS2K5, there would be a similar AMO scipt to do the same.
I don't have any AMO samples yet, but another option for a once off
check would be to go into SQL Management Studio, right click on the
cube, select All Tasks and choose the option to create either an alter
or create script. In the xml you will find a node for AggregationDesign
under each partition that contains a list of the aggregations. It would
probably be easier to save the script to a separate file with a .xml
extension and view it in IE as you can then expand and collapse the xml
nodes.
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell