how can I check if my cube has aggregation?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Word 2003 memory Leakage - 14 Oct 2005 21:57 GMT

I am not sure how aggregation works in the cube.

Is there a way to check if this succeds?

Thanks,

GUangming

Reply to this Message

Darren Gosbell - 17 Oct 2005 08:07 GMT

Easiest way is to run the DSO script from my blog. :)

http://www.geekswithblogs.net/darrengosbell/articles/57168.aspx

Signature

Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Reply to this Message

Word 2003 memory Leakage - 17 Oct 2005 14:12 GMT

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

> Easiest way is to run the DSO script from my blog. :)
>
> http://www.geekswithblogs.net/darrengosbell/articles/57168.aspx

Reply to this Message

Word 2003 memory Leakage - 17 Oct 2005 14:22 GMT

In the msmdsrv.ini, there is nothing for DSO:

    <DSO>
        <RemoteRepositoryConnectionString/>
        <RepositoryConnectionString/>
        <RemoteLocksDirectory/>
        <LocksDirectory/>
    </DSO>

Guangming

> It is great!
>
[quoted text clipped - 17 lines]
> >
> > http://www.geekswithblogs.net/darrengosbell/articles/57168.aspx

Reply to this Message

Dave Wickert [MSFT] - 17 Oct 2005 19:51 GMT

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.

Signature

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.

> In the msmdsrv.ini, there is nothing for DSO:
>
[quoted text clipped - 28 lines]
>> >
>> > http://www.geekswithblogs.net/darrengosbell/articles/57168.aspx

Reply to this Message

Darren Gosbell - 18 Oct 2005 01:52 GMT

> 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.

Signature

Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Reply to this Message