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

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,
GUangmingEasiest 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_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/darre...cles/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

How automatically process a Cube periodically

Good morning,

I have create a solution with two cubes, but I want that these cubes process automatically, with a batch or a windows task.

But I don't find how to do this. Do I need to create a script or something like that.

I'm totally lost.

Thanks for your help,

You can use SQL Server Integration Services (search for Processing Objects Using Integration Services in BOL), or you could also Analysis Managment Objects (AMO).
|||

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

|||

Titou wrote:

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

I forgot to note that i work with sql server and analysis services 2005

|||In BI Development Studio, create a new SSIS task. In the Control Flow tab, first add a connection manager for your Analysis Services database (bottom tab, right-click), then drag an Analysis Services Processing Task from the toolbar on the left (the tab may be minimized). In the task, set which objects you want processed.

Save locally, and then go to the file menu and do a Save a copy of... And save it to your SQL Server database that Analysis Services is sitting on.

Go to Management studio and connect to the database (not Analysis Services). Go to the SQL Server Agent and right-click on jobs. Add a new job. In the job type, select SSIS job, select the SSIS package that you just created, and voila! You have a job on the database that you can now set to occur periodically.

It's a little confusing at first, but once it gets going, it's pretty simple. After your first one, you'll probably want to go back and add logging, too...

-Doug
|||

I success in the creation of the SSIS task, but when i go to Sql Server, I can't find my file an I can't had or browse to find it, could you help me?

Thanks

|||

Many options are available. Two immediately come to mind. Both involve scripting. When you have the processing dialog box open (just before you process) you will notice a box at the top that says "Script". It will take whatever you are about to do for processing and create an XMLA script a background window.

Once you have the script then:

1) Create a SQL Agent job and a step within it. There is a new option in the step that allows it to run an Analysis Services Command -- this is the XMLA script that you created above. Simply paste it into the step and then schedule the SQL Agent job as needed.

2) Create an SSIS package and select an Analysis Services Execute DDL task. Insert the XMLA script into it and it will execute it as a step in the SSIS package.

Alternatively, you could create an SSIS package and use the Analsyis Services Processing task and specify what object you wish to process. That works well also.

Finally, coming in WR2 of the Samples MSI in April will be a new utility called ascmd (which is patterened after sqlcmd) that allows you to execute XMLA scripts (and MDX queries) from the command line. If you are interested in getting a pre-release version of it, contact me (dwickert@.microsoft.com) and I will point you to the right folks.

Hope that helps.

_-_-_ Dave

|||

Hi.

Thanks, DWBI_Doug! Worked perfectly!

Regards

Kjetil

|||Thank You DWBI_Doug, You saved my day. i ow you one.

How automatically process a Cube periodically

Good morning,

I have create a solution with two cubes, but I want that these cubes process automatically, with a batch or a windows task.

But I don't find how to do this. Do I need to create a script or something like that.

I'm totally lost.

Thanks for your help,

You can use SQL Server Integration Services (search for Processing

Objects Using Integration Services in BOL), or you could also Analysis

Managment Objects (AMO).|||

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

|||

Titou wrote:

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

I forgot to note that i work with sql server and analysis services 2005

|||In BI Development Studio, create a new SSIS task. In the Control Flow tab, first add a connection manager for your Analysis Services database (bottom tab, right-click), then drag an Analysis Services Processing Task from the toolbar on the left (the tab may be minimized). In the task, set which objects you want processed.

Save locally, and then go to the file menu and do a Save a copy of... And save it to your SQL Server database that Analysis Services is sitting on.

Go to Management studio and connect to the database (not Analysis Services). Go to the SQL Server Agent and right-click on jobs. Add a new job. In the job type, select SSIS job, select the SSIS package that you just created, and voila! You have a job on the database that you can now set to occur periodically.

It's a little confusing at first, but once it gets going, it's pretty simple. After your first one, you'll probably want to go back and add logging, too...

-Doug|||

I success in the creation of the SSIS task, but when i go to Sql Server, I can't find my file an I can't had or browse to find it, could you help me?

Thanks

|||

Many options are available. Two immediately come to mind. Both involve scripting. When you have the processing dialog box open (just before you process) you will notice a box at the top that says "Script". It will take whatever you are about to do for processing and create an XMLA script a background window.

Once you have the script then:

1) Create a SQL Agent job and a step within it. There is a new option in the step that allows it to run an Analysis Services Command -- this is the XMLA script that you created above. Simply paste it into the step and then schedule the SQL Agent job as needed.

2) Create an SSIS package and select an Analysis Services Execute DDL task. Insert the XMLA script into it and it will execute it as a step in the SSIS package.

Alternatively, you could create an SSIS package and use the Analsyis Services Processing task and specify what object you wish to process. That works well also.

Finally, coming in WR2 of the Samples MSI in April will be a new utility called ascmd (which is patterened after sqlcmd) that allows you to execute XMLA scripts (and MDX queries) from the command line. If you are interested in getting a pre-release version of it, contact me (dwickert@.microsoft.com) and I will point you to the right folks.

Hope that helps.

_-_-_ Dave

|||

Hi.

Thanks, DWBI_Doug! Worked perfectly!

Regards

Kjetil

How automatically process a Cube periodically

Good morning,

I have create a solution with two cubes, but I want that these cubes process automatically, with a batch or a windows task.

But I don't find how to do this. Do I need to create a script or something like that.

I'm totally lost.

Thanks for your help,

You can use SQL Server Integration Services (search for Processing Objects Using Integration Services in BOL), or you could also Analysis Managment Objects (AMO).
|||

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

|||

Titou wrote:

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

I forgot to note that i work with sql server and analysis services 2005

|||In BI Development Studio, create a new SSIS task. In the Control Flow tab, first add a connection manager for your Analysis Services database (bottom tab, right-click), then drag an Analysis Services Processing Task from the toolbar on the left (the tab may be minimized). In the task, set which objects you want processed.

Save locally, and then go to the file menu and do a Save a copy of... And save it to your SQL Server database that Analysis Services is sitting on.

Go to Management studio and connect to the database (not Analysis Services). Go to the SQL Server Agent and right-click on jobs. Add a new job. In the job type, select SSIS job, select the SSIS package that you just created, and voila! You have a job on the database that you can now set to occur periodically.

It's a little confusing at first, but once it gets going, it's pretty simple. After your first one, you'll probably want to go back and add logging, too...

-Doug
|||

I success in the creation of the SSIS task, but when i go to Sql Server, I can't find my file an I can't had or browse to find it, could you help me?

Thanks

|||

Many options are available. Two immediately come to mind. Both involve scripting. When you have the processing dialog box open (just before you process) you will notice a box at the top that says "Script". It will take whatever you are about to do for processing and create an XMLA script a background window.

Once you have the script then:

1) Create a SQL Agent job and a step within it. There is a new option in the step that allows it to run an Analysis Services Command -- this is the XMLA script that you created above. Simply paste it into the step and then schedule the SQL Agent job as needed.

2) Create an SSIS package and select an Analysis Services Execute DDL task. Insert the XMLA script into it and it will execute it as a step in the SSIS package.

Alternatively, you could create an SSIS package and use the Analsyis Services Processing task and specify what object you wish to process. That works well also.

Finally, coming in WR2 of the Samples MSI in April will be a new utility called ascmd (which is patterened after sqlcmd) that allows you to execute XMLA scripts (and MDX queries) from the command line. If you are interested in getting a pre-release version of it, contact me (dwickert@.microsoft.com) and I will point you to the right folks.

Hope that helps.

_-_-_ Dave

|||

Hi.

Thanks, DWBI_Doug! Worked perfectly!

Regards

Kjetil

|||Thank You DWBI_Doug, You saved my day. i ow you one.