|
Home > Archive > MS SQL Data Warehousing > October 2005 > how can I check if my cube has aggregation?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how can I check if my cube has aggregation?
|
|
|
|
| Word 2003 memory Leakage 2005-10-17, 1:24 pm |
| I am not sure how aggregation works in the cube.
Is there a way to check if this succeds?
Thanks,
GUangming
| |
| Word 2003 memory Leakage 2005-10-17, 1:24 pm |
| It is great!
When I ran the script, I got errors like this:
D:\codes\MDX\ListOLA
PAggregations.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/darre...cles/57168.aspx
>
> --
> Regards
> Darren Gosbell [MCSD]
> < dgosbell_at_yahoo_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
| |
| Word 2003 memory Leakage 2005-10-17, 1:24 pm |
| In the msmdsrv.ini, there is nothing for DSO:
<DSO>
< RemoteRepositoryConn
ectionString/>
< RepositoryConnection
String/>
< RemoteLocksDirectory
/>
<LocksDirectory/>
</DSO>
Guangming
"Word 2003 memory Leakage" wrote:
[color=darkred]
> It is great!
>
> When I ran the script, I got errors like this:
>
> D:\codes\MDX\ListOLA
PAggregations.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:
>
| |
| Dave Wickert [MSFT] 2005-10-20, 8:24 pm |
| 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" < Word2003memoryLeakag
e@discussions.microsoft.com>
wrote in message news:1863EE4D-EF45-4644-987D- 8C111DC3C084@microso
ft.com...[color=darkred]
> In the msmdsrv.ini, there is nothing for DSO:
>
> <DSO>
> < RemoteRepositoryConn
ectionString/>
> < RepositoryConnection
String/>
> < RemoteLocksDirectory
/>
> <LocksDirectory/>
> </DSO>
>
> Guangming
>
> "Word 2003 memory Leakage" wrote:
>
| |
| Darren Gosbell 2005-10-20, 8:24 pm |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
|
|
|
|
|