Use of Macro in metric designer

[monika]

whenever the data updates every month,we need to execute each extract.I was thinking of macro which dynamically make the execution of extracts every month.Does anyone has idea of using macro in metric designer?
or could you please suggest me any possible solution for the same?

[Erik]

You can publish the extract tasks from Metric Designer to Cognos Connection and then schedule them just like you can schedule reports, events etc. You can bundle you extracts into jobs and have them run in a particular order. Once they have all run and the data has been moved into the staging tables, you then need to run the "Transfer from Staging to metric store" which can also be a part of your job.

[monika]

I am new to metric studio....so please tell me in some detail how can I publish the extract tasks from Metric Designer to Cognos Connection ?.....does it mean to use publish to content store or anything else?

I would be highly grateful for your help..............

[monika]

I am new to metric studio....so please tell me in some detail how can I publish the extract tasks from Metric Designer to Cognos Connection ?.....does it mean to use publish to content store or anything else?

I would be highly grateful for your help..............

To reduce the task of executing extract  whenever data comes,can any one suggest the way to automate this task?
Please reply if u can provide any answer to this.